Answered step by step
Verified Expert Solution
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,
- 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, and a unique 5-digit code.
- 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.
- 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.
- 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.
- (25 pts) 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, and a unique 5-digit code.
- 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.
- 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.
- 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started