Determine cardinality→ Define relationships between entities (one-to-one, one-to-many).
Analyze data requirements→ Determine the attributes each entity needs.
Apply normal forms→ Eliminate redundancy and improve data consistency.
Example Usage:
After identifying entities likeStudentsandCourses, applying3rd Normal Form (3NF)ensures that data isorganized without redundancy.
Why Other Options Are Incorrect:
Option A (Analyze data requirements) (Incorrect):Doneearlierto define attributes.
Option C (Determine cardinality) (Incorrect):Donebeforenormalization to establish relationships.
Option D (Discover entities) (Incorrect):Done at thebeginningof database design.
Thus, the correct answer isApply a normal form, as normalization is thelast step in logicaldesign.
[Reference:Database Normalization and Design Process., ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit