Scribd
Upload
2 views2 pages

Bank Normalization Assignment

The document outlines the process of normalizing a banking system database from UNF to 3NF using ASCII tables and sample data. It includes detailed tables for bank transactions, accounts, loans, and branches, illustrating the transformation into normalized structures. The final tables clearly separate data into distinct entities, ensuring data integrity and reducing redundancy.

Uploaded by

anujgol343
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views2 pages

Bank Normalization Assignment

The document outlines the process of normalizing a banking system database from UNF to 3NF using ASCII tables and sample data. It includes detailed tables for bank transactions, accounts, loans, and branches, illustrating the transformation into normalized structures. The final tables clearly separate data into distinct entities, ensuring data integrity and reducing redundancy.

Uploaded by

anujgol343
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Database Normalization - Banking System

(Assignment 12a)
This document demonstrates normalization from UNF to 3NF with ASCII tables and sample data.

UNF TABLE (Bank_Transaction)

+----------+--------------+-------------+--------+------------+--------------+----------------+------
| Account | Customer | Branch | City | Loan_IDs | Loan_Amt | Transaction_ID | Trans
+----------+--------------+-------------+--------+------------+--------------+----------------+------
| A101 | Rahul Sharma | SBI Pune | Pune | L1,L2 | 50000,30000 | T1,T2 | 2000,
| A102 | Sneha Joshi | SBI Mumbai | Mumbai | L3 | 70000 | T3 | 2500
+----------+--------------+-------------+--------+------------+--------------+----------------+------

ACCOUNT TABLE

+----------+--------------+-------------+--------+--------------+------------+
| Account | Customer | Branch | City | Manager | Contact |
+----------+--------------+-------------+--------+--------------+------------+
| A101 | Rahul Sharma | SBI Pune | Pune | Mr. Patil | 987654 |
| A102 | Sneha Joshi | SBI Mumbai | Mumbai | Mr. Mehta | 912345 |
+----------+--------------+-------------+--------+--------------+------------+

LOAN TABLE

+--------+----------+-------------+
| LoanID | Account | Amount |
+--------+----------+-------------+
| L1 | A101 | 50000 |
| L2 | A101 | 30000 |
| L3 | A102 | 70000 |
+--------+----------+-------------+

TRANSACTION TABLE

+-------------+----------+-------------+
| TransID | Account | Amount |
+-------------+----------+-------------+
| T1 | A101 | 2000 |
| T2 | A101 | 1500 |
| T3 | A102 | 2500 |
+-------------+----------+-------------+

FINAL 3NF TABLES

ACCOUNT

+----------+--------------+-------------+
| Account | Customer | Branch |
+----------+--------------+-------------+
| A101 | Rahul Sharma | SBI Pune |
| A102 | Sneha Joshi | SBI Mumbai |
+----------+--------------+-------------+

BRANCH

+-------------+--------+--------------+------------+
| Branch | City | Manager | Contact |
+-------------+--------+--------------+------------+
| SBI Pune | Pune | Mr. Patil | 987654 |
| SBI Mumbai | Mumbai | Mr. Mehta | 912345 |
+-------------+--------+--------------+------------+

LOAN

+--------+----------+-------------+
| LoanID | Account | Amount |
+--------+----------+-------------+
| L1 | A101 | 50000 |
| L2 | A101 | 30000 |
| L3 | A102 | 70000 |
+--------+----------+-------------+
TRANSACTION

+-------------+----------+-------------+
| TransID | Account | Amount |
+-------------+----------+-------------+
| T1 | A101 | 2000 |
| T2 | A101 | 1500 |
| T3 | A102 | 2500 |
+-------------+----------+-------------+

You might also like