Build entity-relationship diagrams from requirements analysis
Identify entities, attributes, and relationships and validate them
Resolve many-to-many and complex relationships into binary relationships
Define primary and foreign keys and enforce entity integrity
Apply generalization hierarchies and data integrity rules
Normalize relational tables using functional dependencies
