Banking_DBMS_Project. FOR 12 STUDENTDS THANK YOU

DBMS BASIC MANUAL

1. Banking Management System (DBMS Project) Class 12 Computer Science Project

2. Index 1. Introduction to DBMS 2. Project Overview 3. Objectives 4. ER Diagram 5. Database Schema 6. Procedure 7. Sample Queries 8. Advantages 9. Conclusion

3. Introduction to DBMS • DBMS is software to store, retrieve, and manage data. • In banking, DBMS helps manage customer accounts, transactions, and reports. • Example: MySQL, Oracle.

4. Project Overview • This project manages customer accounts and transactions. • Features include deposits, withdrawals, transfers. • Generates mini statements and balance reports.

5. Objectives • Design a database for banking operations. • Maintain accuracy and consistency of data. • Perform basic operations using SQL queries. • Generate reports like mini statements.

6. ER Diagram (Concept) Entities: - Customer (Customer_ID, Name, Address, Phone, Email) - Account (Account_No, Customer_ID, Type, Balance) - Transaction (Trans_ID, Account_No, Type, Amount, Date, Time) Relationships: - A Customer can hold multiple Accounts. - An Account can have multiple Transactions.

7. Database Schema Customer(Customer_ID, Name, Address, Phone, Email) Account(Account_No, Customer_ID, Account_Type, Balance) Transaction(Trans_ID, Account_No, Type, Amount, Date, Time)

8. Procedure / Methodology 1. Create database BankDB. 2. Create Customer, Account, Transaction tables. 3. Insert sample data. 4. Perform operations (Deposit, Withdraw, Transfer). 5. Run queries for reports.

9. Sample Queries • SELECT Balance FROM Account WHERE Account_No=5001; • SELECT * FROM Transaction WHERE Account_No=5001 LIMIT 5; • SELECT Name, Balance FROM Customer, Account WHERE Customer.Customer_ID = Account.Customer_ID AND Balance < 1000;

10. Advantages • Fast and easy retrieval of data. • Secure transaction management. • Reduces manual errors. • Useful for automatic report generation.

11. Conclusion The Banking Management System demonstrates the use of DBMS for real-life financial operations, ensuring accuracy, security, and efficiency in managing customer accounts and transactions.