姓名:专业:班级:学号:科目:数据库系统原理实验日期:
实验题目:实验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