EssayproSolutions

Exercise 4: Draw a BANK Entity Relationship diagram using ER and EER concepts of specialization and generalization. State any assumptions you make about the additional requirements.

Exercise 4:

Draw a BANK Entity Relationship diagram using ER and EER concepts of specialization and generalization. State any assumptions you make about the additional requirements.

The database allows to keep track of ACCOUNTS (identified by AccountID, Balance, Account Type). Account can be of two sub-types either SAVINGS_ACCTS or CHECKING_ACCTS.

LOANS can be of several sub-types such as CAR_LOANS, HOME_LOANS, PERSONAL.

It is also desirable to keep track of each ACCOUNT’s TRANSACTIONS by recording its data and time, transaction type (e.g. deposits, withdrawals, checks, … ) and amount.

Every Loan has several payments. For each PAYMENT of the loan the Date, Payment Type and Amount is recorded.