@Ravnish_Singh

CREATE TABLE Student (Roll int PRIMARY KEY, Name varchar(25) , Course varchar(10) ); CREATE TABLE Subject (Roll int references Student, SubCode int, SubName varchar(10) );

create table employee ( fname varchar(255), minit varchar(255), lname varchar(255), pan integer, bdate date, address varchar(255), sex varchar(255), salary integer, supepan integer,

CREATE TABLE BANK( bank_ID numeric primary key, bank_name varchar(20) not null, bank_address varchar(20) ); INSERT INTO BANK VALUES(001,'SBI','Godha colony'); INSERT INTO BANK VALUES(002,'PNB','Rajwada'); INSERT INTO BANK VALUES(003,'MET','Geeta co

CREATE TABLE BANK( bank_ID numeric primary key, bank_name varchar(20) not null, bank_address varchar(20) ); INSERT INTO BANK VALUES(001,'SBI','Godha colony'); INSERT INTO BANK VALUES(002,'PNB','Rajwada'); INSERT INTO BANK VALUES(003,'MET','Geeta co

CREATE TABLE branch ( branch_name text, assets text, branch_city text ); INSERT INTO branch VALUES ('Mahesh nagar', 'M.G. road', 'Indore'); INSERT INTO branch VALUES ('Raj mohlla', 'Bus stand', 'Bhopal'); INSERT INTO branch VALUES ('Rajwada', 'R

CREATE TABLE customer ( CustomerID integer, customer_name text, street text, city text, amount integer ); INSERT INTO customer VALUES (1,'AMIT', 'M.G.road', 'Indore',5000); INSERT INTO customer VALUES (2,'ARPIT', 'Bus stand', 'Bhopal',6000); IN