4.0

最新推荐文章于 2024-03-22 10:22:23 发布

朝向高处的旅途

最新推荐文章于 2024-03-22 10:22:23 发布

阅读量559

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库

本文链接：https://blog.youkuaiyun.com/airuozhaoyang/article/details/22221151

数据库专栏收录该内容

23 篇文章

订阅专栏

本文详细介绍了使用SQL创建数据库及表的过程，包括学生信息表、课程表和选课记录表，并填充了示例数据。

create database jxgl;
use jxgl;

Create Table Student
( Sno CHAR(5) NOT NULL PRIMARY KEY(Sno),
Sname VARCHAR(20),
Sage SMALLINT CHECK(Sage>=15 AND Sage<=45),
Ssex CHAR(2) DEFAULT '男' CHECK (Ssex='男' OR Ssex='女'),
Sdept CHAR(2));

Create Table Course
( Cno CHAR(2) NOT NULL PRIMARY KEY(Cno),
Cname VARCHAR(20),
Cpno CHAR(2),
Ccredit SMALLINT);

Create Table SC
( Sno CHAR(5) NOT NULL CONSTRAINT S_F FOREIGN KEY REFERENCES Student(Sno),
Cno CHAR(2) NOT NULL,
Grade SMALLINT CHECK ((Grade IS NULL) OR (Grade BETWEEN 0 AND 100)),
PRIMARY KEY(Sno,Cno),
FOREIGN KEY(Cno) REFERENCES Course(Cno));

INSERT INTO Student VALUES('98001','钱横',18,'男','CS');
INSERT INTO Student VALUES('98002','王林',19,'女','CS');
INSERT INTO Student VALUES('98003','李民',20,'男','IS');
INSERT INTO Student VALUES('98004','赵三',16,'女','MA');

INSERT INTO Course VALUES('1','数据库系统', '5',4);
INSERT INTO Course VALUES('2','数学分析',null ,2);
INSERT INTO Course VALUES('3','信息系统导论','1',3);
INSERT INTO Course VALUES('4','操作系统原理','6',3);
INSERT INTO Course VALUES('5','数据结构','7',4);
INSERT INTO Course VALUES('6','数据处理基础',null,4);
INSERT INTO Course VALUES('7','C语言','6',3);
INSERT INTO Course VALUES('8','MISS哈哈导读','6',3);

INSERT INTO SC VALUES('98001','1',87);
INSERT INTO SC VALUES('98001','2',67);
INSERT INTO SC VALUES('98001','3',90);
INSERT INTO SC VALUES('98002','2',95);
INSERT INTO SC VALUES('98002','3',88);