create table department (dept_id varchar2(50) primary key,dept_name varchar2(50),bank_id varchar2(50) REFERENCES bank1(bank_id) ,doj date);
create table bank1(bank_id varchar2(50) primary key,bankname varchar2(50),sal varchar2(50),customername varchar2(50),phno number(10),email varchar2(50));
create table employee(emp_id varchar2(50) primary key,dept_id varchar2(50) REFERENCES department(dept_id),empfirstname varchar2(50),emplastname varchar2(50),sal number(12),phno number(10),email varchar2(50),bank_id varchar2(50)REFERENCES bank1(bank_id));

insert into bank1 values(:bank_id,:dept_name,:bankname,:customername,:phno,:email);
insert into department values(:dept_id,:dept_name,:bank_id,:doj);
insert into employee values(:emp_id,:dept_id,:empfirstname,:emplastname,:sal,:phno,:email,:bank_id);




select * from bank1