数据库实验报告3.doc

实验七数据安全性实验
实验内容:
1. 建立教学数据库teaching
create database teaching
on primary
(
name=teaching1,
filename='g: ',
size=10mb,
filegrowth=10%
)
log on
(
name='teaching1_log',
filename='g:\ ',
size=1mb,
maxsize=5mb,
filegrowth=1mb
)
2. 建立教学数据库的三个基本表:
S (S#, SNAME, AGE, SEX) 学生(学号,姓名,年龄,性别)
SC (S#, C#, GRADE ) 选修(学号,课程号,成绩)
C (C#, CNAME, TEACHER) 课程(课程号,课程名,任课教师)
use teaching
CREATE TABLE C
(
C# CHAR(10),
CNAME CHAR(10),
TAECHER CHAR(10),
constraint C#_fk foreign key (C#) references SC (C#)
S 表,SC表略.
3. 输入数据
use teaching
INSERT INTO S(S#,SNAME,AGE,SEX)VALUES('S1','WANG',20,'M');
INSERT INTO S(S#,SNAME,AGE,SEX)VALUES('S2','LIU',19,'M');
INSERT INTO S(S#,SNAME,AGE,SEX)VALUES('S3','CHEN',22,'M');
INSERT INTO S(S#,SNAME,AGE,SEX)VALUES('S4','WU',19,'M');
INSERT INTO S(S#,SNAME,AGE,SEX)VALUES('S5','LOU',21,'F');
INSERT INTO S(S#,SNAME,AGE,SEX)VALUES('S8','DONG',18,'F');
INSERT INTO SC(S#,C#,GRADE)VALUES('S1','C1',80);
INSERT INTO SC(S#,C#,GRADE)VALUES('S1','C2',70);
INSERT INTO SC(S#,C#,GRADE)VALUES('S1','C3',85);
INSERT INTO SC(S#,C#,GRADE)VALUES('S1','C4',90);
INSERT INTO SC(S#,C#,GRADE)VALUES('S1','C5',70);
INSERT INTO SC(S#,C#,GRADE)VALUES('S2','C1',85);
INSERT INTO SC(S#,C#)VALUES('S2','C2');
INSERT INTO SC(S#,C#)VALUES('S2','C3');
INSERT INTO SC(S#,C#)VALUES('S2','C4');
INSERT INTO SC(S#,C#)VALUES('S2','C5'