A solid database is designed according to the principles of Normalization. Therefore, it is imperative that an E/R model be created in at least the 3rd Normal Form where there exist no partial and/or transitive dependencies and a primary key is defined for each table.
A solid database is designed according to the principles of Normalization. Therefore, it is imperative that an E/R model be created in at least the 3rd Normal Form where there exist no partial and/or transitive dependencies and a primary key is defined for each table.