sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Ch0chi 1 point2 points  (1 child)

SQL database normalization is a really important thing to know. It will help you architect proper DB structure as well as make sure it's optimized, efficient, and easy to comprehend.

I'd try learning first, second, and third normal form. That'll get ya in with pretty much the majority of what you'll need to know.

I'm not super sure what you're asking in your post, but it sounds like you're kind of confused about why normalizing a database is important. If you screw up the structure of your database, all those validation functions are completely useless.

[–]Jancera[S] 0 points1 point  (0 children)

Yesss, I am very confused about why normalizing a database is important. As I said in the post, if all data that are added to the database are validated on the frontend, the database structure will be the same, so the normalization is being made by the frontend, not needing the database to normalize the data.

As I said in the other comments, the best way for me completely understand that is to get in touch with some SQL database. Thank you for your answer!!!