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: –
- Person Opens an Account
- 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: