Banking_DBMS

Datebase for keeping customer records of a bank //// Description//// A bank can have multiple branches and each branch can have multiple accounts and loans. • Customer attributes : aadhaar no, customer name, dob, address, mobile, email, gender, age. • Account attributes : account no, balance, type. • Loan attributes : loan no, amount, type. • Branch attributes : IFSC code, address. /// Sample Questions ////

1. Retrieve all the customers of a branch.
2. Retrieve all the customer addresses who have loan.
3. Retrieve the bank address to which the given account belongs to.
4. Retrieve the balances and liabilities of a customer.
5. Retrieve customers who has multiple accounts.