数据库实验报告3.doc

蚃实验七数据安全性实验蒈实验内容:(蚇name=teaching1,肅filename='g:',薂size=10mb,衿filegrowth=10%螈)膄logon羁(虿name='teaching1_log',螀filename='g:\',蒆size=1mb,莁maxsize=5mb,莀filegrowth=1mb薇):肄S(S#,SNAME,AGE,SEX)学生(学号,姓名,年龄,性别)膀SC(S#,C#,GRADE)选修(学号,课程号,成绩)蚈C(C#,CNAME,TEACHER)课程(课程号,课程名,任课教师)羇useteaching薄CREATETABLEC袁(蒆C#CHAR(10),肅CNAMECHAR(10),羃TAECHERCHAR(10),蚁constraintC#_fkforeignkey(C#)referencesSC(C#)蒇膄莂S表,(S#,SNAME,AGE,SEX)VALUES('S1','WANG',20,'M');莆INSERTINTOS(S#,SNAME,AGE,SEX)VALUES('S2','LIU',19,'M');蚄INSERTINTOS(S#,SNAME,AGE,SEX)VALUES('S3','CHEN',22,'M');芁INSERTINTOS(S#,SNAME,AGE,SEX)VALUES('S4','WU',19,'M');袂INSERTINTOS(S#,SNAME,AGE,SEX)VALUES('S5','LOU',21,'F');蒇INSERTINTOS(S#,SNAME,AGE,SEX)VALUES('S8','DONG',18,'F');肇羄莈葿INSERTINTOSC(S#,C#,GRADE)VALUES('S1','C1',80);膅INSERTINTOSC(S#,C#,GRADE)VALUES('S1','C2',70);莄INSERTINTOSC(S#,C#,GRADE)VALUES('S1','C3',85);聿INSERTINTOSC(S#,C#,GRADE)VALUES('S1','C4',90);芆INSERTINTOSC(S#,C#,GRADE)VALUES('S1','C5',70);芃INSERTINTOSC(S#,C#,GRADE)VALUES('S2','C1',85);螃INSERTINTOSC(S#,C#)VALUES('S2','C2');衿INSERTINTOSC(S#,C#)VALUES('S2','C3');莇INSERTINTOSC(S#,C#)VALUES('S2','C4');蚆INSERTINTOSC(S#,C#)VALUES('S2','C5');膃INSERTINTOSC(S#,C#,GRADE)VALUES('S3','C1',90);薀INSERTINTOSC(S#,C#,GRADE)VALUES('S3','C2',85);荿INSERTINTOSC(S#,C#,GRADE)VALUES('S3','C3',95);螄INSERTINTOSC(S#,C#)VALUES('S3','C4');蚂INSERTINTOSC(S#,C#)VALUES('S3','C5');莀INSERTINTOSC(S#,C#,GRADE)VALUES('S4','C1',70);膆INSERTINTOSC(S#,C#,GRADE)VALUES('S4','C2',60);膇INSERTINTOSC(S#,C#,GRADE)VALUES('S4','C3',80);肁INSERTINTOSC(S#,C#)VALUES('S4','C4');肀INSERTINTOSC(S#,C#,GRADE)VALUES('S4','C5',65);芈INSERTINTOSC(S#,C#,GRADE)VALUES('S5','C1',90);芅INSERTINTOSC(S#,C#)VALUES('S5','C2');螅INSERTINTOSC(S#,C#,GRADE)VALUES('S5','C3',90);螁INSERTINTOSC(S#,C#)VALUES('S5','C4');艿INSERTINTOSC(S#,C#)VALUES('S5','C5');莃膄薁useteaching肆INSERTINTOC(C#,CNAME,TAECHER)VALUES('C2','MATHS