A bank requires a database designed to keep track of its customers accounts. Each customer may have a number of accounts. Each of these accounts may be in the name of one or more customers. Each account is located in a particular branch of a bank. In addition, each customer may have zero or more loans with the bank. Each loan must be with one or more customers. Each loan is also located in a particular branch. The database must record the following information: The name of the bank, its address and its main telephone number The address and the sort code for each branch The name of each customer, the customers address and the customers telephone number For each bank account: the account number, its balance and the type of the account For each loan: the loan account number, the outstanding balance and the interest rate The database must also record the various relations between the different entities in the database Draw an entity relationship diagram for the database. In your diagram, illustrate which are the key attributes, which relationships are optional and mandatory and the cardinality of the relationships Define a set of database tables that implement the entity-relationship diagram. Indicate which attributes will represent the primary key for each table, which attributes are foreign keys and which attributes cannot have a null value The referential integrity rules do not allow unmatched foreign key values. What would be the consequences of this rule for your database design?
A bank requires a
The name of the bank, its address and its main telephone number
The address and the sort code for each branch
The name of each customer, the customers address and the customers telephone number
For each bank account: the account number, its balance and the type of the account
For each loan: the loan account number, the outstanding balance and the interest rate
The database must also record the various relations between the different entities in the database
Draw an entity relationship diagram for the database. In your diagram, illustrate which are the key attributes, which relationships are optional and mandatory and the cardinality of the relationships
Define a set of database tables that implement the entity-relationship diagram. Indicate which attributes will represent the primary key for each table, which attributes are foreign keys and which attributes cannot have a null value
The referential integrity rules do not allow unmatched foreign key values. What would be the consequences of this rule for your database design?
Step by step
Solved in 2 steps with 1 images
