a) Identify ALL errors and correction on the entity relationship diagram (ERD) given in Figure 5. Provide your answers in Appendix 1 by: i. Circle the errors identified on the diagram. ii. For each...

Subject: Database

Extracted text: a) Identify ALL errors and correction on the entity relationship diagram (ERD) given in Figure 5. Provide your answers in Appendix 1 by: 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 Customer Property CustID {PK} ProplD {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