Reverse engineer a well-formed Entity Relationship diagram from the Property Management schema given below. Document any

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Reverse engineer a well-formed Entity Relationship diagram from the Property Management schema given below. Document any

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply