(EER) Extended - Entity - Relationship

1) (30 points) Consider the BANK ER diagram in Figure 1 and suppose that it is necessary to keep track of different types of ACCOUNTS (SAVINGS ACCTS, CHECKING_ACCTS, ...), LOANS (CAR LOANS, HOME LOANS, BUSINESS LOANS, ...), and CUSTERMERS (STUDENTS, HOME OWNERS, EMPLOYEES, BUSINESSMEN, ...). Suppose that it is also desirable to keep track of each ACCOUNT's TRANSACTIONS (deposits, withdrawals, checks ...) and each LOAN's PAYMENTS; both of these include the amount, date, and time. Modify the BANK ER Diagram to form an EER diagram, using EER concepts of specialization and generalization. State any assumptions you make about the additional requirements Figure 1: An ER diagram for a BANK database schema BANK BRANCHES BANK BRANCH CodeNa Addr Branch.no Addr ACCTS LOANS Acct no Balance Loan no Amount ACCOUNT Type LOAN Type AC LC Ssn Name Phone CUSTOMER Addr