Q.1. Consider the following Chen ER schema for a database related to a BANK. Now, we are provided with the following additional information:

a) It is necessary to keep track of different types of ACCOUNTS (such as, SAVINGS_ACCTS, CHECKING_ACCTS, TRUST) and it is also desirable to keep track of each account's TRANSACTIONs (Amount, Type, Date and Time).

b) It is also necessary to keep track of different types of LOANS (CAR_LOANS, HOME_LOANS, CREDIT_LINE, PERSONAL) and to keep track of each loans PAYMENTs such as Amount, Type, Date and Time. Redraw only the relevant entity types of the BANK ER-Schema (slide#3) using EER concepts of specialization and generalization to include above (a and b) information. State any additional assumptions you need to make. Place your after ERD version on Slide 4 with your Assumption Statements.

N Bank Chen model before mods BANK BRANCHES BANK_BRANCH Code Name Addr Addr Branch no ACCTS LOANS N N Acct no Balance Loan_no Amount ACCOUNT Type LOAN Type M M AC LC N N San Name Phone CUSTOMER Addr