Create an ER diagram for the following requirements. Use cardinality ratio and participation constraints to indicate the

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Create an ER diagram for the following requirements. Use cardinality ratio and participation constraints to indicate the

Post by answerhappygod »

Create an ER diagram for the following requirements. Use
cardinality ratio and participation constraints to indicate the
relationship constraints.
a. A Bank has a name, address, and a unique 5-digit code.
b. 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.
c. 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.
d. 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. Please ans this
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply