Answered You can hire a professional tutor to get the answer.
Draw the ER diagram for the following problem. A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each...
Draw the ER diagram for the following problem. 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_ChargeSAVINGS: Acct_No, Date_Opened, Balance, Interest_RateLOAN: Acct_No, Date_Opened, Balance, Interest_Rate, PaymentAssume that each bank account must be a member of exactly one of these subtypes.Assume that each bank account must be a member of exactly one of these subtypes.On the other hand an account may be any two of this subtype at the same time. Using generalization develop an EER model segment to represent this situation. Remember to include subtype discriminator.
