Use standard notation for representing tables. Underline primary keys and italic

Question

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

STUDENT (Stud_ID, Surname, Forename, Matriculated, College, Email, Sup_ID) SUPERVISOR (Sup_ID, Surname, Forename, Add

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

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

Explanation / Answer

1.
FARMER (FName PRIMARY KEY, LName, Country, State)
COW(TagNo PRIMARY KEY,Breed,DOB,Owns FOREIGN KEY)

2.
AUTHOR(AuthNo PRIMARY KEY, AuthName)
BOOK(ISBN PRIMARY KEY,Title,Writes FOREIGN KEY)

3.
CUSTOMER(CustomerID PRIMARY KEY,LastName,FirstName,Address,City,State,ZIP,Phone,Email)

4.
PROPERTY(PropertyID PRIMARY KEY,PropetyType,Address,City,State,ZIP)
HOUSE(PropertyID FOREIGN KEY,NumberOfBedrooms)
APARTMENT_HOUSE(PropertyID FOREIGN KEY,NumberOfUnits,ManagerName)
COMMERCIAL(PropertyID FOREIGN KEY,NumberOfUnits,TotalFloorSpace)

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.