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

By | August 1, 2014

MASTER OF COMPUTER APPLICATIONS
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:

 

ERD_Banking_System

Leave a Reply