DateBuy Customer Property CustID {PK} PropID {PK} Name 1.. 1 *.. 1 OfferPrice Address SellPrice Phone{1.. 2} purchase PropAddr Fax Agency 1. 1 AgencylD {PK} sell Name 1.. 1 Staff StaffID {PK} FName...


Subject: Database
Identify
ALL
errors and correction on the entity relationship diagram (ERD) given in Figure 5.
i. Circle the errors identified on the diagram.
ii. For each error identified, correct them. Show your corrections either by redrawing the corrected diagram OR by describing how the errors should be corrected next to the circles that you have identified.


DateBuy<br>Customer<br>Property<br>CustID {PK}<br>PropID {PK}<br>Name<br>1.. 1<br>*.. 1<br>OfferPrice<br>Address<br>SellPrice<br>Phone{1.. 2}<br>purchase<br>PropAddr<br>Fax<br>Agency<br>1. 1<br>AgencylD {PK}<br>sell<br>Name<br>1.. 1<br>Staff<br>StaffID {PK}<br>FName<br>LName<br>Days Work<br>/Commission<br>Figure 5: Conceptual ERD<br>

Extracted text: DateBuy Customer Property CustID {PK} PropID {PK} Name 1.. 1 *.. 1 OfferPrice Address SellPrice Phone{1.. 2} purchase PropAddr Fax Agency 1. 1 AgencylD {PK} sell Name 1.. 1 Staff StaffID {PK} FName LName Days Work /Commission Figure 5: Conceptual ERD

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here