数据库系统概论,第三章学生-课程数据库创建步骤:
1.创建数据库
create database 学生课程;
2.创建模式
create schema ST
3.创建表及插入信息
create table "ST".Student(
Sno nvarchar(20),
Sname nvarchar(10),
Ssex nchar(2),
Sage int,
Sdept nvarchar(8)
);
INSERT
INTO ST.Student(Sno,Sname,Ssex,Sage,Sdept)
select '200215121'as Sno,'李勇'as Sname,'男'as Ssex,'20'as Sage,'CS'as Sdept
Union All
select '200215122'as Sno,'刘晨'as Sname,'女'as Ssex,'19'as Sage,'CS'as Sdept
Union All
select '200215123'as Sno,'王敏'as Sname,'女'as Ssex,'18'as Sage,'MA'as Sdept
Union All
select '200215125'as Sno,'张立'as Sname,'男'as Ssex,'19'as Sage,'IS'as Sdept
Union All
select * from ST.Student
create table "ST".Course(
Cno int,
Cname nvarchar(20),
Cpno int,
Ccredit int,
);
insert
into ST.Course(Cno,Cname,Cpno,Ccredit)
select 1 as Cno,'数据库' as Cname,5 as Cpno,4 as Ccredit
Union All
select 2 as Cno,'数学' as Cname,'' as Cpno,2 as Ccredit
Union All
select 3 as Cno,'信息系统' as Cname,1 as Cpno,4 as Ccredit
Union All
select 4 as Cno,'操作系统' as Cname,6 as Cpno,3 as Ccredit
Union All
select 5 as Cno,'数据结构' as Cname,7 as Cpno,4 as Ccredit
Union All
select 6 as Cno,'数据处理' as Cname,'' as Cpno,2 as Ccredit
Union All
select 7 as Cno,'PASCAL语言' as Cname,6 as Cpno,4 as Ccredit
Union All
select * from ST.Course
CREATE TABLE "ST".SC(
Sno NVARCHAR(10),
Cno INT,
Grade INT
);
insert
into ST.SC(Sno,Cno,Grade)
SELECT '200215121'AS Sno,'1' AS Cno,'92' AS Grade
Union All
SELECT '200215121'AS Sno,'2' AS Cno,'88' AS Grade
Union All
SELECT '200215121'AS Sno,'3' AS Cno,'80' AS Grade
Union All
SELECT '200215122'AS Sno,'2' AS Cno,'90' AS Grade
Union All
SELECT '200215122'AS Sno,'3' AS Cno,'78' AS Grade
Union All
SELECT * FROM ST.SC