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.

e4.png

Return to details of ER modeling.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License