Exam403.pdf - Question A bank has three types of accounts...

This preview shows page 1 - 3 out of 7 pages.

Question: 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. Using generalization, develop an EER model segment to represent this situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor. Remember to include a subtype discriminator.
Details of the bank situation definition: The bank account is sub divided into the three categories such as checking, saving, and loan. • The CHECKING account type contains the attributes of the Acct No, Date Opened, Balance, and Service Charge. • The SAVINGS account type contains the attributes of the Acct No, Date Opened, Balance, and Interest Rate.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture