Results 1 to 2 of 2

Thread: Need answer to this question ?

  1. #1
    Join Date
    Jul 2013
    Posts
    2

    Need answer to this question ?

    . Suppose you are designing a database for a bank. There are entities Account, Branch, Account_Owner, etc. Account_Owner is a person. There are different types of accounts, and Account represents all possible types of accounts, such as checking, saving, loans, etc. Accounts can be owned by a person or by a married couple. If a person owns Account, the spouse may be assigned as a second owner later. Accounts can be open in a Branch, and this Branch is associated with this Account for the life of the Account. What are the connectivites between Account and Account_Owner as well as between Account and Branch? Why?

  2. #2
    Join Date
    May 2014
    Posts
    3
    There is an excellent discussion on implementation of multiple connectivities in banking database: dba.stackexchange.com/questions/42434/database-design-two-1-to-many-relationships-to-the-same-table

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •