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