drop table rltp_mngr;  
drop table product;  
drop table cust;  
drop table account;  
drop table transaction;  
drop table acctype;  
drop table txntype;  
  
create table rltp_mngr(rltp_id number,rltp_name varchar2(50));  
Insert into rltp_mngr values(10, 'Phil');  
Insert into rltp_mngr values(20, 'Jack');  
  
create table product(rltp_id number,prod_id number,prod_name varchar2(50));  
Insert into product values(10,1, 'Personal');  
Insert into product values(20,1, 'Business');  
 
create table cust(rltp_id number,prod_id number,cust_id number,cust_name varchar2(50));  
insert into cust values(10,1,2,'Fixed');  
insert into cust values(20,1,2,'Fixed');  
 
Create table account(rltp_id number,prod_id number,cust_id number,acc_id number,acc_name varchar2(50),acc_balance number(18,2));  
insert into account values(10,1,2,3,'Savings',3000);  
insert into account values(10,1,2,7,'Savings',3000);  
insert into account values(20,1,2,3,'Savings',3000);  
 
create table transaction(rltp_id number,prod_id number,cust_id number,acc_id number,txn_id number,txn_amt number(18,2));  
insert into transaction values(10,1,2,3,4,500);  
insert into transaction values(10,1,2,3,5,500);  
insert into transaction values(10,1,2,3,6,500);  
insert into transaction values(10,1,2,7,8,500);  
insert into transaction values(20,1,2,3,4,500);  
 
create table acctype(rltp_id number,prod_id number,cust_id number,acc_id number,acc_type varchar2(5),acc_code varchar2(10));  
insert into acctype values(10,1,2,3,'X','ZZ');  
insert into acctype values(10,1,2,3,'X','YY');  
insert into acctype values(10,1,2,7,'X','AA');  
insert into acctype values(10,1,2,7,'X','BB');  
  
create table txntype(rltp_id number,prod_id number,cust_id number,acc_id number,txn_id number,txn_code varchar2(10));  
insert into txntype values(10,1,2,3,4,'11');  
insert into txntype values(10,1,2,3,4,'12');  
insert into txntype values(10,1,2,7,8,'11');  
insert into txntype values(10,1,2,7,8,'12');  
insert into txntype values(10,1,2,7,8,'13');