Data model the attached registration form and draw an ERD in Chen's notation. Identify and name all Entities, Attributes, Primary Keys, and Relationships. Specify the Cardinality in one of the participation notations discussed in class. Use appropriate table types we discussed in class. Make these assumptions... Email addresses are different for each person and all people have one and only one. Fall OR Spring may be selected, not both. No need to save information about which school this is for or the school address.

Hint: Your solution should have between 3 and 4 Entities in Chen's notation.

1) Submit the ERD in Chen Notation. In addition to the ERD, submit descriptions about how you would build each relationship you define. Identify any new tables you would create, any new columns, any new foreign keys, and the identify the table & column each foreign key refers to. Do this for each and every relationship in your diagram.

REGISTRATION FORM (please print clearly) ORTH HORE SEMESTER(S) select Fal Spring 20 RT CADEMY Name: Address: Phone (emergency): E-mail Address: Course:_ Course: Course: AMOUNT ENCLOSED: Mail completed form with check/money order made payable to: North Shore Art Academy 1 Washington Ave, Glen Head, NY 11545 REGISTRATION FORM (please print clearly) ORTH HORE SEMESTER(S) select Fal Spring 20 RT CADEMY Name: Address: Phone (emergency): E-mail Address: Course:_ Course: Course: AMOUNT ENCLOSED: Mail completed form with check/money order made payable to: North Shore Art Academy 1 Washington Ave, Glen Head, NY 11545