数据库系统原理实验一参考题答案
- 格式:doc
- 大小:193.50 KB
- 文档页数:13
姓名:专业:班级:学号:科目:数据库系统原理实验日期:
实验题目:实验1 SQL SERVER 的安装及使用,数据库的建立
MAXSIZE=50,
FILEGROWTH=5
)
LOG ON
(
NAME='Students_Log',
FILENAME='E:\ SQL_DATEBASE\Students_Mis_log.ldf',
SIZE=5MB,
MAXSIZE=25MB,
FILEGROWTH=5MB
)
GO
(2)调用(USE)数据库:Students_Mis_2018
use Students_Mis_2018
GO
(3)分别建立4个数据表的表结构(CREATETABLE):系(Depts),学生(Students),课程(Courses),选课(Reports)
CREATETABLE Depts
(
Dno CHAR(5)PRIMARYKEY,
Dname CHAR(20)NOTNULL
)
GO
CREATETABLE Students
(
Sno CHAR(5)PRIMARYKEY,
Sname CHAR(20)NOTNULL,
Ssex CHAR(2),
Sage INT,
Dno CHAR(5),
CONSTRAINT FK_Dno FOREIGNKEY(Dno)REFERENCES Depts )
GO
CREATETABLE Courses
(
Cno CHAR(6)PRIMARYKEY,
Cname CHAR(20),
Pre_Cno CHAR(6),
Credits INT
)
GO
CREATETABLE Reports
(
Sno CHAR(5),
Cno CHAR(6),
Grade INTCHECK(Grade>=0 AND Grade<=100),
PRIMARYKEY(Sno,Cno),
CONSTRAINT Student_Report FOREIGNKEY(Sno)REFERENCES Students, CONSTRAINT Report_Course FOREIGNKEY(Cno)REFERENCES Courses
)
GO
(4)分别对4个表插入表数据(INSERT)
INSERT
INTO depts
VALUES ('D01','自动化')
INSERT
INTO depts
VALUES ('D02','计算机')
INSERT
INTO depts
VALUES ('D03','数学')
INSERT
INTO depts
VALUES ('D04','通信')
INSERT
INTO depts
VALUES ('D05','电子')
INSERT
INTO depts
VALUES ('D06','化学')
SELECT*
FROM Depts
INSERT
INTO Students
VALUES ('S01','王建平','男',21,'D01') INSERT
INTO Students
VALUES ('S02','刘华','女',19,'D01') INSERT
INTO Students
VALUES ('S03','范林军','女',18,'D02') INSERT
INTO Students
VALUES ('S04','李伟','男',19,'D03') INSERT
INTO Students
VALUES ('S05','黄河','男',18,'D03') INSERT
INTO Students
VALUES ('S06','长江','男',20,'D03') SELECT*
FROM Students
INSERT
INTO Courses
VALUES ('C01','英语','',4) INSERT
INTO Courses
VALUES ('C02','数据结构','C05',2) INSERT
INTO Courses
VALUES ('C03','数据库','C02',2) INSERT
INTO Courses
VALUES ('C04','DB-设计','C03',3) INSERT
INTO Courses
VALUES ('C05','C++','',3) INSERT
INTO Courses
VALUES ('C06','网络原理','C07',3) INSERT
INTO Courses
VALUES ('C07','操作系统','C05',3) SELECT*
FROM Courses
INSERT
INTO Reports
VALUES ('S01','C01','92') INSERT
INTO Reports
VALUES ('S01','C03','84')