Reverse engineer a well-formed Entity Relationship
diagram from the Property Management
schema given below. Document any assumptions that you make
by writing them out in a
sentence.
ALL THE BOLD WORDS ARE PRIMARY KEYS
SHOW AN ER DIAGRAM WITH ALL RELATIONS AND CARDINALITY
USING THE SCHEMA BELOW
Owner(ownerID)
OwnerName(business, private, ownerID)
ownerID is a foreign key to
Owner
Property(propID)
Owns(propID, ownerID)
ownerID is a foreign key to Owner
propID is a foreign key to
Property
Renter(renterID)
Staff(works-for-branch, name)
works-for-branch is a foreign key to
Branch
Branch(branchID)
Views(renterID, staffname, staffbranch,
propID)
renterID is a foreign key to
Renter
staffname, staffbranch is a foreign key
to Staff
propID is a foreign key to
Property
ViewDates(renterID, staffname, staffbranch, propID,
date)
renterID, staffname, staffbranch, propID
is a foreign key to Views
Reverse engineer a well-formed Entity Relationship diagram from the Property Management schema given below. Document any
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am