When designing a database,you should ____.
A) make sure entities are in normal form before table structures are created
B) create table structures then normalize the database
C) only normalize the database when performance problems occur
D) consider more important issues such as performance before normalizing

Question

Quizplus · Accepted Answer

It is best to make sure entities are in normal form before creating table structures to ensure data consistency, reduce data redundancy, and improve database performance. Normalization helps to eliminate data anomalies and ensures that data is stored efficiently in tables. Creating table structures before normalizing the database can lead to poor database design and data integrity issues. It is also important to consider performance issues, but normalization should be the foundation of the database design.

When Designing a Database,you Should ____