DBMS Lab Experiment 2

gistfile1.txt

INSERT INTO student40 VALUES (1,'Ramu');
INSERT INTO student40 VALUES (2,'Raja');
INSERT INTO student40 VALUES (3,'Vignesh');
INSERT INTO student40 VALUES (4,'Sairam');
INSERT INTO student40 VALUES (5,'Kishore');
INSERT INTO student40 VALUES (6,'Mohan');
INSERT INTO student40 VALUES (7,'Naveen');
INSERT INTO student40 VALUES (8,'Yashwanth');
INSERT INTO student40 VALUES (9,'Pavan');
INSERT INTO student40 VALUES (10,'Chandu');
CREATE TABLE membership40 (mem_no int primary key,stud_no int NOT NULL);
INSERT INTO membership40 VALUES (101,1); 
INSERT INTO membership40 VALUES (102,2); 
INSERT INTO membership40 VALUES (103,3); 
INSERT INTO membership40 VALUES (104,4); 
INSERT INTO membership40 VALUES (105,5); 
INSERT INTO membership40 VALUES (106,6); 
INSERT INTO membership40 VALUES (107,7); 
INSERT INTO membership40 VALUES (108,8); 
INSERT INTO membership40 VALUES (109,9); 
INSERT INTO membership40 VALUES (110,10);
CREATE TABLE book40(iss_no int primary key,book_name varchar(20) author varchar(20));
INSERT INTO book40 VALUES (11,'CO','Morris Mano');
INSERT INTO book40 VALUES (12,'OS','William'); 
INSERT INTO book40 VALUES (13,'OOPS','Blaguru'); 
INSERT INTO book40 VALUES (14,'DS','DWH'); 
INSERT INTO book40 VALUES (15,'DWH'Paulraj,''); 
INSERT INTO book40 VALUES (16,'MC','Rajkamal'); 
INSERT INTO book40 VALUES (17,'CC','Vetle'); 
INSERT INTO book40 VALUES (18,'DBMS',Elmasri''); 
INSERT INTO book40 VALUES (19,'CS','Simon'); 
INSERT INTO book40 VALUES (20,'SE','Pressman');