A Bank uses a database system for maintaining information about its customers. This database is
used for the following requirements:
 To find the customer id, name, account number and balance of various customers.
 To find the deposits and withdrawals made by a customer for a specific period.
 To calculate the interest on the customer deposit.
Perform the following tasks for the Bank:
i. Draw an ER diagram for the Bank. Specify key attributes and constraints on each entity type
and on each relationship type. Note any unspecified requirements and make appropriate
assumptions to make the specification complete.
ii. Design normalized tables in 3NF from the ER diagram drawn in part (i), with the required
integrity constraints. 

To solve this problem, we need to follow a systematic approach by first understanding the entities and their relationships, and then designing an appropriate Entity-Relationship (ER) diagram. After creating the ER diagram, we can convert it into normalized tables in the Third Normal Form (3NF).

i. Drawing the ER Diagram:

Entities:

1. Customer: Represents a customer of the bank.
2. Account: Represents a bank account held by a customer.
3. Transaction: Represents a deposit or withdrawal made in an account.

Relationships:

1. A customer can have one or more accounts (one-to-many relationship between Customer and Account).
2. An account can have multiple transactions _____ ___ ___ _________ __________.
   _________ _______ _______ ___ _________ ____ _______ ___ _______ ____.
   ________ ________ ______ _____ ________ _______ _____ _____ ______ ______ ______.
   ___ ________ ___ _____ _______ ______ ________.
   _________ _____ _______ ___ _________ _____ ___ ________ ________ ___.
   ________ _________ ___ _____ ________.
   __________ _________ _________ ______ __________ ________.
   _____ ________ _______ ____ __________ ________ ________ __________ _____ ______ ____.
   _________ _____ ______ ________ ______ _____ ___ _____ _______ _______.
   _____ _________ _________ ____ _________ __________.
   _________ ______ ____ ________ _______ __________.
   ___ __________ _________ ________ ____.
   ________ _________ __________ _____ _______ _________ _____ _________ __________ _____.
   ________ ________ __________ ___ ______ _______ _________ ______ ______ _______ ____.
   _________ ________ __________ ______ __________ __________ ______ ________ _________.
   ___ ____ ______ ______ __________ ________ ______ ___ _____.
   _____ ___ __________ ____ ______ ___ ________ _______ ____ ___.
   ________ __________ ___ _________ ___ ____ _____.
   __________ ____ _______ ________ _____ ___ _____ _________ ________.
   _____ _______ ____ ___ ___ _________ _________.
   ___ _______ _______ ______ _____ _____ ________ ____ ________ _________ _______.
   ___ ___ _________ ___ _________ ___ _______ ___.
   __________ _________ ____ __________ ____ _____ __________.
   ___ ___ ______ ______ ______ ________ ______.
   _____ ____ __________ ______ __________ ___.
   ________ ___ ___ ______ ___ __________ _________.
   _______ ___ __________ __________ _______ ______.
   ______ ________ _____ _________ ________.
   ___ ______ ________ _____ ___ _________ __________ _________ ________ _____ _________ _____.
   _____ _________ _______ ____ ___ _______ _____ ________.
   ___ _____ ____ ________ _____ _______ ________ ___ __________ _______ _________.
   _____ _______ ___ __________ _______ ____ ____.
   ______ ____ ____ ___ ______ _______ _________ ______.
   _________ _____ _________ ____ _____ _________ ________ __________ __________.
   ____ _____ _______ ________ ______ ________ _________ ________.
   _________ _________ _______ _______ ___ ________ _________ _____ _________ _________ __________.
   ___ _________ _________ ___ _______ _______ _____ _____ ______ __________ ______.
   __________ __________ _______ ____ _________ ______ _____ _________.
   ______ __________ __________ ________ _____ ___ _____ ________ ___ _________.
   ________ ________ _____ _______ __________ ____ _____ _____ ___ __________ ________.
   ______ _________ __________ ________ _______.
   ________ ________ ______ __________ _______ _____.
   _______ ________ ___ ____ _______.
   ____ ____ _________ ___ ______.
   ____ ___ ______ _______ _________ _________ ____ ___ _________ __________ ____ ________.
   ________ ________ ______ ________ ______ __________ ________.
   ___ _______ _________ ___ ____ ___ ___.
   _________ _______ ____ ___ __________ _________ ____ __________ ______ ____ ____ _____.
   _____ _________ ______ ____ __________ ____ _____ _______ _______ _______ _________ ________.
   ______ _______ ________ __________ _______ ________ ________ ___ ___.
   _______ _________ __________ _____ ______ __________ ____ ________ ________ ____ ____ ___.
   ____ ________ _______ _________ ____ ___ __________.
   _______ _________ __________ ________ ____ ___ ________ ____.
   ______ __________ ______ ______ _____ ___ _______ ___ ____.
   __________ ________ ___ _________ _____.
   _____ ________ _______ ____ _________ _______ ______ __________ _______ _______ ________.
   _________ ____ ________ ______ ___ ____ ___.
   ______ __________ __________ ______ ______ _______ ________ _________ ____ _________ _____ ________.
   _________ __________ __________ ____ _________ _______ _______ ____ ____.
   _____ ______ ___ ________ ________ __________ _____ _____ __________.
   ______ ____ ____ ___ __________ ________.
   Get Full Answer on WhatsApp