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 write a 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