JDBC Assignment
Banking Database System:
BankCustomer
CUST_ID CUST_NAME ADDRESS ACC_TYPE
CUST_ID : customer identification number [primary key]
NAME : Name of the customer
ADDRESS : Address of the Customer
ACC_TYPE : Account type i.e savings/current
CustomerAccount
CUST_ID BALANCE
CUST_ID : customer identification number [foreign key]
BALANCE : account balance
By using above tables writes the Program to cover all the below operations:
1) Find customer details of the given customer account
2) Get balance of the given customer account
3) Deposit amount into the given customer account
4) Withdraw amount from the given customer account (minimum balance should be 1000)
5) Show all the customer details and account balances