Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an ER diagram for the following requirements. Use cardinality ratio and participation constraints to indicate the relationship constraints. A Bank has a name, address,

  1. Create an ER diagram for the following requirements. Use cardinality ratio and participation constraints to indicate the relationship constraints.
    1. A Bank has a name, address, and a unique 5-digit code.
    2. Each bank has several branches. Each branch has a branch number that is unique among the branches of the bank it belongs to (but may be the same as a branch for a different bank). Each branch has a location.
    3. Each branch maintains its own set of accounts. An account has a unique account number, a type (such as checking or savings) and a current balance. An account may be shared between more than one customers.
    4. Each customer may have several accounts. A customer has a name, a social security number, an address, and a list of phone numbers where they may be reached.
    5. (25 pts) Create an ER diagram for the following requirements. Use cardinality ratio and participation constraints to indicate the relationship constraints.
      1. A Bank has a name, address, and a unique 5-digit code.
      2. Each bank has several branches. Each branch has a branch number that is unique among the branches of the bank it belongs to (but may be the same as a branch for a different bank). Each branch has a location.
      3. Each branch maintains its own set of accounts. An account has a unique account number, a type (such as checking or savings) and a current balance. An account may be shared between more than one customers.
      4. Each customer may have several accounts. A customer has a name, a social security number, an address, and a list of phone numbers where they may be reached.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Neo4j

Authors: Gregory Jordan

1st Edition

1484200225, 9781484200223

More Books

Students also viewed these Databases questions