CS 3310 Lab 6 Correct Answers

Download Now

CS 3310 Lab 6

Mapping ER Diagrams to Tables

Practice

Complete the ADBC ‐ ER to Table animation

[http://adbc.kennesaw.edu/index.php?mainmenu=db&submenu=er_to_tables]

Submission

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.