You are ready to begin considering data design issues for the Willowbrook School project. Refer back to the DFDs you have prepared and the documentation from the systems analysis phase. Perform the following tasks:
Assignments
1. Using the Functional Decomposition Diagrams and Data Flow Diagrams you developed for chapters four and five as source documents, create an ERD that includes cardinality notation.
2. Design tables in 3NF.
3. If you identified any new entities during normalization, create a final entity-relationship diagram for the system.
4. Use sample data to populate the fields for at least three records in each table.
When all of the answers for the given project are completed and a consensus is reached, everyone in the group will attach the completed answers to the assignment in the Week 6 assignments area.