CS 3310 Lab 6 Complete Solution

Question: #1565

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.

Solution: #1549

CS 3310 Lab 6 Complete Solution

STUDENT (KSUID, LastName, FirstName) PARKING SPACE (ParkingSpaceNo, LotName, KSUID) 2. Solution FARMER (FNAME,LNAME, County, State, TagNo) COW (TagNo, Breed, D...