Use the below figure to complete the following steps: Transform the EER diagram

Question

Use the below figure to complete the following steps:

Transform the EER diagram to a set of relations and develop a relational schema

Diagram the functional dependencies and determine the normal form for each relation

PROPERTY Property ID Street Address City State Zip RENTER Renter ID First Name Middle Initial Last Name Address Phone# E Mail RENTAL AGREEMENT Agreement ID End Date Rental Amount Nbr Rooms BooksBase Rate Property Type Property Type = M" BEACH PROPERTY MOUNTAIN PROPERTY Blocks to Beach (Activity)

Explanation / Answer

Renter (renterid, firstname, middleinit, lastname, address, phonenum, email, agreementid)

Rental_Agreement (agreementid, begindate, enddate, rentalamount, propertyid)

Property (propertyid, streetaddress, citystate, zip, nbrrooms, baserate, property_type)

Attribute in bold= primary key

Attribute in italics= foreign key

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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