R
@Ravnish_Singh
ric
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) );
Employees
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,
bank database management system
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 colony');
INSERT INTO BANK VALUES(004,'SWISS','Baker street');
INSERT INTO BANK VALUES(005,'NXI','Putin Hall');
new
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 colony');
INSERT INTO BANK VALUES(004,'SWISS','Baker street');
INSERT INTO BANK VALUES(005,'NXI','Putin Hall');
Branch
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', 'Railway station', 'Dewas');
INSERT INTO branch VALUES ('Gandhi bhawan', 'Cenral library', 'Rewa');
customer
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);
INSERT INTO customer VALUES (3,'SOURABH', 'Railway station', 'Dewas',1000);