EERD Exercise (2).docx - Question 1 A bank has three types...

This preview shows page 1 out of 1 page.

Question 1 A bank has three types of accounts: checking, savings, and loan. Following are attributes for each type of account: CHECKING: Acct No, Date Opened, Balance, Service Charge SAVING: 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 specialization/generalization, develop an EER model to represent this situation. Question 2 A company branch (identified by branch number, with address information consists of street, city and postcode) has at least one staff.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture