1. A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account: CHECKING: Acct No, Date Opened, Balance, Service Charge. SAVINGS: Acct No, Date Opened, Balance, Interest Rate. LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment. Assume that each bank account must be a member of exactly one of these subtypes.
i. Using generalization, develop an EER model segment to represent this situation and indicate supertype and subtype. Show the subtype discriminator
ii. Defined Generalisation and Specialisation
