1. A database system is to be designed to keep track of custumers and their bank accounts. The following E-R diagram depicts it:

<img src='./qimages/13950-1.jpg'>

Please note the following assumptions

• Cust_id and account_no are the primary keys of Customer and Account entities respectively.

• A customer can have many accounts. An account can also be joint (in the name of many customers).

• PAN is the unique permanent account number of a customer.

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

Design and implement normalised relations/tables. You must include primary key, validation checks and referential integrity constraints in your implementation.

Enter about 5 sets of meaningful data in each table.

Design and implement the following queries/forms/reports for the database.

Create two forms one for entering the customer information and the other for entering the account information.

Find the sum of all the account balances held by a customer whose cust_id is "C001".

List the account number of the account which has maximum balance.

List the details of all the account holders of the account whose account_no is "A00l".

Display the information of all the customers in the order of customer name (cust_name).