Use standard notation for representing tables. Underline primary keys and italicize foreign keys.

For example:

STUDENT (Stud_ID, Surname, Forename, Matriculated, College, E-mail, Sup_ID)

SUPERVISOR (Sup_ID, Surname, Forename, Address, E-mail, Telephone)

STUDENT_SUPERVISOR (Stud_ID, Sup_ID)

Submit as a Microsoft Word Document in Dropbox area of D2L labeled Lab 6 submission

1. Convert the ER Diagram below to a list of tables. Be sure to identify primary keys and foreign keys.

2. Convert the ER Diagram below to a list of tables. Be sure to identify primary keys and foreign keys.

3. Convert the ER Diagram below to a list of tables. Be sure to identify primary keys and foreign keys.

4. Convert the ER Diagram below to a list of tables. Be sure to identify primary keys and foreign keys.

5. Map the following super-type, sub-type relationship to tables. Be sure to identify primary keys and foreign keys.