set1inse.txt

一个c语言开发的小型的dbms系统

INSERT INTO Student VALUES('98131001','student0', 'F',20); 
INSERT INTO Student VALUES('98131002','student1', 'F',21); 
INSERT INTO Student VALUES('98131003','student2', 'F',22); 
INSERT INTO Student VALUES('98131004','student3', 'F',23); 
INSERT INTO Student VALUES('98131005','student4', 'F',24); 
INSERT INTO Student VALUES('98131006','student5', 'M',25); 
INSERT INTO Student VALUES('98131007','student6', 'M',26); 
INSERT INTO Student VALUES('98131008','student7', 'M',27); 
INSERT INTO Student VALUES('98131009','student8', 'M',28); 
INSERT INTO Student VALUES('98131010','student9', 'M',29); 
INSERT INTO Course VALUES('Cno0','CourseName0',4);
INSERT INTO Course VALUES('Cno1','CourseName1',4);
INSERT INTO Course VALUES('Cno2','CourseName2',4);
INSERT INTO Course VALUES('Cno3','CourseName3',4);
INSERT INTO Course VALUES('Cno4','CourseName4',4);
INSERT INTO Course VALUES('Cno5','CourseName5',4);
INSERT INTO Course VALUES('Cno6','CourseName6',4);
INSERT INTO Course VALUES('Cno7','CourseName7',4);
INSERT INTO Course VALUES('Cno8','CourseName8',4);
INSERT INTO Course VALUES('Cno9','CourseName9',4);
INSERT INTO SC VALUES('98131001','Cno1',71);
INSERT INTO SC VALUES('98131001','Cno2',81);
INSERT INTO SC VALUES('98131001','Cno3',91);
INSERT INTO SC VALUES('98131001','Cno4',89);
INSERT INTO SC VALUES('98131002','Cno1',90);
INSERT INTO SC VALUES('98131002','Cno2',62);
INSERT INTO SC VALUES('98131003','Cno2',85);
INSERT INTO SC VALUES('98131008','Cno1',50);