Willow brook School Case Study Willowbrook School is a small private school that has retained your services as a systems analyst to assist in the development of a new information system for the...

Willow brook School Case Study
Willowbrook School is a small private school that has retained your services as a systems analyst to assist in the development of a new information system for the school’s administrative needs.
Now that you have designed a user interface, you are ready to focus on the data design of the Willow brook School’s information system. To perform the following tasks, refer back to the documentation given in earlier weeks and also ones you prepared from the systems analysis phase.
Q1. Create an ERD for the Willow brook School’s information system showing relationships and cardinalities and notation as explained in Data Design lecture recording.



Q2. Design fully normalized 3NF tables for the system. Use the real-world normalization examples as explained in Data Design lecture  and Chapter 9 of your text that illustrates the use of correct standard notation format