need Help Quick on assignment on class I don't understand.

 

Willowbrook SchoolChapter 9Willowbrook School is a small private school that has retained your services as a systemsanalyst to assist in the development of a new information system for the school’sadministrative needs.BackgroundNow that you have designed a user interface, you are ready to focus on the data design ofthe Willowbrook School’s information system. To perform the following tasks, refer backto the DFDs you created in Chapter 5, and the documentation you prepared from thesystems analysis phase.Tasks1.Create an ERD for the Willowbrook School’s information system withrelationship or cardinality notation.2.Design fully normalized 3NF tables for the system. Use the real-worldnormalization examples starting on page 372 of your text that illustrates the use ofcorrect standard notation format.3.Create a final ERD for the system by incorporating any new entities identifiedduring normalization.4.Use realistic, sample data to populate the fields for at least three records in eachtable as identified by your normalization method(s).

Attachments:

• 1496019275-Ch09_Willowbrook 1.doc