Best Practices for ER Diagrams to Relational Models

The procedure in the last lesson converts a two entity diagram without a single judgement call.

Real diagrams have forty entities. They have relationships with attributes of their own, weak entities owned by weak entities, and one-to-one links that should probably be one table.

This lesson covers the parts where the procedure needs a decision from you, and what to decide.

Composite attributes: split, and do not keep the whole

Break Full_Name into first_name, middle_initial and last_name. Do not also keep a full_name column.