Answer to Problem 2.4
In this database you should define a company entity type with two subtypes: AR_co and AP_co. The company entity type stores all facts that are common attributes — in this case, the address and contact person. The AR_co entity subtype tracks the balance owed from this company while the AP_co entity subtype tracks the balance owed to this company.
Return to details of ER modeling.
page revision: 0, last edited: 12 Aug 2008 17:10