Solutions To Hands On Exercises

mysql> Create table customer_master(
cust_id Varchar(10) Primary Key,
cust_name Varchar(20),
date_created Date,
opening_balance Float(10,2)
);

mysql> Create table customer_detail(
cust_id Varchar(10) Primary Key,
permanentaddr Varchar(35),
offaddr1 Varchar(35),
offaddr2 Varchar(35),
pincode Int(6),
landlineno Double,
mobileno Double,
offtelephone Double,
Foreign Key (cust_id) REFERENCES customer_master (cust_id)
);

mysql> Create table transaction_detail(
cust_id Varchar(10),
transaction_id Varchar(15) Primary Key,
name Varchar(15),
chequeno Int (10),
amount_deposit Float(10,2),
amount_withdrawn Float(10,2),
running_balance Float(10,2),
dated Date,
Foreign Key (cust_id) REFERENCES bank_db.customer_master(cust_id)
);