Question: A bank has a database with accounts. For each account it records the (unique) account number and the current balance. The database also has

A bank has a database with accounts. For each account it records the (unique) account number and the current

A bank has a database with accounts. For each account it records the (unique) account number and the current balance. The database also has information about depositors -- their name, (unique) social-security number, and their address. Finally, the bank also stores, for each account, the depositor or depositors (in the case of joint accounts), that own the account. There is only one reasonable E/R diagram for this database structure. Draw this E/R diagram, and then tell which of the following appears in the E/R diagram for this bank's database. a) A diamond labeled Accounts. b) An oval labeled social-security-number with an underline. Oc) A recangle labeled depositor-name. d) A diamond labeled address.

Step by Step Solution

3.48 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The detailed answer for the above question is provided below 1 Entities Account with attributes acco... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Banking Questions!