Question

PersonID FacilityID StartDate EndDate Name Address Address City Phone Person MgtContract Facility (1,) (0,) State (0,) (1,1) in (1.) Rental StorageUnit Size (0,*) UnitID RentAmount StartDate End Date Description

          PersonID
FacilityID
StartDate EndDate
Name
Address
Address
City
Phone
Person
MgtContract
Facility
(1,*)
(0,*)
State
(0,*)
(1,1)
in
(1.*)
Rental
StorageUnit
Size
(0,*)
UnitID
RentAmount
StartDate
End Date
Description

Added by Leslie J.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Chandra Jain

Step 1

The primary key is PersonID. Show more…

Show all steps

Thanks for your feedback!

Create a relational schema for each of the following diagrams using the following notation: Table names are shown in boldface with attributes listed in parentheses. Primary keys are underlined. Foreign keys are indicated by a separate statement that indicates the table referenced on the line immediately following the attribute list. Person (PersonID, Name, Address, City, Phone) Facility (FacilityID, Address, City, State) MgtContract (PersonID, FacilityID, StartDate, EndDate) Rental (PersonID, FacilityID, StorageUnitID, StartDate, EndDate) StorageUnit (StorageUnitID, Size, Description)