Entity Relationship ER diagram for a Banking System – IGNOU MCA Assignment 2014-15

By | August 1, 2014

Course Code : MCS-023
Course Title : Introduction to Database Management Systems
Assignment Number : MCA (2)/023/Assign /2014-15
Maximum Marks : 100
Weightage : 25%


Construct an ER diagram for a Banking System. Clearly indicate the entities, relationships, cardinality and the key constraints. Also, derive the un-normalized relational database tables with the help of this diagram.

The General Things needed in a Banking System are: –

  1. Person Opens an Account
  2. Person using ATM for Transaction

The person opens an Account in a Bank and gets a account number and ATM card. The person can make transactions in ATM centres. The Details of the Transaction has to be maintained Between Three Entitys. i.e. User, Account, ATM

User Table:

User_ID Name (First_Name, Last_Name) Address Contact_Number


Account Table:

Account_Number User_ID Account_Type (Saving_Account, Current_Account, Over_draft_Account) Balance


ATM Table:

ATM _Number ATM_Place ATM _Cash_Limit


Opening_Account Table:

Date User_ID Account_Number ATM _Number

Transaction Table:

Date User_ID Account_Number ATM _Number Transaction_Type (Deposit_Cheque, Deposit_Cash, Withdraw_Cash)


ER Diagram:



Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.