computer
 






 

Question by  selva59 (16)

What are the basic normalization sql rules to follow?

I would like a list of rules to follow in order to set up a clean data network.

 
+7

Answer by  faithfulservant (37)

Normalization means that every record in every table refers to a unique set of data with no part of the data reproduced in any other record. Normalization also normally uses lookup tables and unique ID to refer to the data. Doing so, gives you control over your data through a single access point instead having to update multiple records.

 
+7

Answer by  Randy998 (226)

Make sure that you store data in separate tables per object. Example would be authors and books. Keep the author info in 1 table and the books in another table. In the books table the foreign key would be the id from the authors id. Don't duplicate data.

 
+6

Answer by  mrandy (140)

Your data model should comply to at least 3 normal forms: 1. Data in a field is atomic (holds just one value) 2. Every field in a row depends on full primary key (not a part of it) 3. Non-primary fields have no relation with each other

 
+5

Answer by  hussain (5)

The Structured Query Language Make sure that you store data in separate tables per object. Example would be authors and books. Keep the author info in 1 table and the books in another table. In the books table the foreign key would be the id from the authors id. Don't duplicate data.

 
You have 50 words left!