1. A new banking system has one fixed customer ID which can be used to open many accounts in different banks. An account can belong to one or more customers. The following E-R diagram shows this:
<img src='./qimages/9564-1.jpg'>

Perform the following tasks for the given E-R diagram:

(a) Design and implement normalised relations/tables for the E-R diagram. You should include primary key, validation checks and referential
integrity constraints in your implementation.

(b) Enter about 5 — 6 sets of meaningful data in each table.

(c) Design and implement the following queries/forms/reports for the database designed above Create two forms -one for entering customer information and the other for entering account information.

(ii) Find the total of all account balances which have Bank ID ="SBI".

(iii) List the details of all accounts that belong to Customer_ID ="COOl".
Create a report of customer_name, age and monthly_income of all the customers in the order of customer_names. List all the accounts having balance less than RS 5000.