Create an ER diagram for the following requirements. Use cardinality ratio and participation constraints to indicate the
Posted: Mon Jun 06, 2022 6:12 pm
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
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