Consider the BANK ER schema in Figure 3.22, and suppose that it is necessary to keep track of different types of ACCOUNTS (SAVINGS ACCTS, CHECKING ACCTS, ...) and LOANS (CAR LOANS, HOME LOANS, ...). 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 schema, using ER and EER concepts of specialization and generalization. State any assumptions you make about the additional requirements. Figure 3.22 An ER diagram for a BANK database schema. BANK BRANCHES Code Name: Addr ACCTS Acct no N BANK BRANCH Addr Branch no LOANS N Balance Loan no Amount Type LOAN Туре M M ACCOUNT A_C N San Name Phone CUSTOMER Addr LC