Step 4, data model mapping, consists of converting the entity relationship diagram into tables in Fourth Normal Form (and documenting those instances that do not conform to this standard). In this database, the Student Athletes table has fields labeled "Sport 1" and "Sport 2". In 4NF, these fields would be separated into another table, comprised of PID and Sport as a joint primary key. I made the design decision to implement two identical text fields of 3 characters to simplify merges for queries and reports.

The database design process is comprised of the following steps*:

Step Description
1 Requirements collection and analysis
2 Conceptual database design
3 Choice of a DBMS
4 Data model mapping (also called logical database design)
5 Physical database design
6 Database system implementation

Other Links:

Last modified by Blaise Byron Faint on: June 3, 1999