Background
After completing the user interface, input, and output design for the new information system, you
will now focus on the data design of the DBMS that will support the system. Begin by reviewing
the DFDs that you prepared in Chapter 5 and the object models that you created in Chapter 6.
Tasks
1. Create an initial ERD for the new system that contains at least eight entities.
2. Analyze each relationship to determine if it is 1:1, 1:M, or M:N.
3. Normalize your designs for all tables to ensure they are 3NF, and verify that all primary,
secondary, and foreign keys are identified properly. Update your ERD to reflect any changes.
4. Review the Data Dictionary you created in Chapter 5 and double-check all data dictionary
entries. Make sure that the entries for data stores, records, and data elements are documented
completely and correctly. Determine what codes, if any, will be used and be sure they are
documented in the data dictionary.
0 comments