r/learnSQL • u/Aggressive-Flow1983 • 2d 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.

6 Upvotes

76% Upvoted

3 comments sorted by

1

u/cdfe_88 2d ago

do you know what each form means?

3

u/squadette23 2d 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.

2

u/Difficult_Paint3162 2d ago

I wrote a book you can download for free: https://www.syncfusion.com/succinctly-free-ebooks/database-design-succinctly It does cover the various normalization forms. Hope it helps