Practice Chapter 3 Solutions.pdf - ISYS 464 Managing Enterprise Data Practice Chapter 3 Solutions Question 1 Assume the following scenario A bank has

Practice Chapter 3 Solutions.pdf - ISYS 464 Managing...

This preview shows page 1 - 2 out of 2 pages.

ISYS 464: Managing Enterprise Data Practice Chapter 3 Solutions Question 1 Assume the following scenario : 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.
Image of page 1
Question 2 Draw an EER diagram for the following problem: A nonprofit organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name, Address, City/ State/Zip, and Telephone.
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Spring '14
  • B MAK
  • Interest, Non-profit organization, nonprofit organization

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes