insert

INSERT INTO class VALUES ('cse','computer science and engineering');
INSERT INTO class VALUES ('cste','computer science and telecommunication engineering');
INSERT INTO class VALUES ('csit','computer science and information engineering');
INSERT INTO class VALUES ('acce','applied chemistry and chemical engineering');
INSERT INTO class VALUES ('fims','fisheries and marine science');
INSERT INTO class VALUES ('pham','pharmacy');
INSERT INTO class VALUES ('ice','information and communication engineering');
INSERT INTO class VALUES ('am','applied mathematics');
INSERT INTO class VALUES ('eshs','environmental science and haphazard studies');
INSERT INTO class VALUES ('mbge','microbiology and genetics engineering');


INSERT INTO student VALUES(1,'jannat','cse');
INSERT INTO student VALUES(2,'mawa','cste');
INSERT INTO student VALUES(3,'koli','csit');
INSERT INTO student VALUES(4,'ferdous','mbge');
INSERT INTO student VALUES(5,'keya','am');
INSERT INTO student VALUES(6,'jahid','fims');
INSERT INTO student VALUES(7,'sagar','pham');
INSERT INTO student VALUES(8,'naeem','ice');
INSERT INTO student VALUES(9,'kona','eshs');
INSERT INTO student VALUES(10,'kamrul','acce');


INSERT INTO lab VALUES(23,6,'physics');
INSERT INTO lab VALUES(24,7,'chemistry');
INSERT INTO lab VALUES(25,8,'biology');
INSERT INTO lab VALUES(26,13,'cse');
INSERT INTO lab VALUES(27,14,'eee');
INSERT INTO lab VALUES(28,15,'botany');
INSERT INTO lab VALUES(29,56,'mathematics');
INSERT INTO lab VALUES(30,57,'java lab');
INSERT INTO lab VALUES(31,58,'aeronatics');
INSERT INTO lab VALUES(32,59,'agriculture');


INSERT INTO allotment VALUES(2,23,'saturday');
INSERT INTO allotment VALUES(3,24,'sunday');
INSERT INTO allotment VALUES(4,23,'monday');
INSERT INTO allotment VALUES(10,32,'monday');
INSERT INTO allotment VALUES(7,27,'tuesday');
INSERT INTO allotment VALUES(8,28,'wednesday');
INSERT INTO allotment VALUES(5,29,'thrusday');
INSERT INTO allotment VALUES(6,30,'saturday');
INSERT INTO allotment VALUES(1,25,'sunday');
INSERT INTO allotment VALUES(9,26,'tuesday');