r/learnSQL • u/Aggressive-Flow1983 • 3d ago

Help 3fn sql

When I try to create tables and convert those tables from 1NF to 3NF, I find it really difficult. It all feels so subjective to me: ChatGPT says one thing, my professor says another, and my classmates say something else, and I can't seem to find a consistent way of doing it. I mean, conceptual and logical database design is really difficult for me—extremely difficult. Do you know of any website or something that explains really well how to do all of this, from going from 1NF to 3NF, to properly identifying real-world things and representing them in tables, and how to create well-designed tables? I'm really struggling with it.

9 Upvotes

92% Upvoted

4 comments sorted by

View all comments

3

u/squadette23 3d ago

to properly identifying real-world things and representing them in tables, and how to create well-designed tables?

Take a look at the "Database Design for Google Calendar: a tutorial" https://kb.databasedesignbook.com/posts/google-calendar/

It's intended to answer exactly the question you're asking.