编辑代码

CREATE DATABASE SelCourse_DB;
USE SelCourse_DB;
CREATE TABLE Students
(
    SN			char(10)PRIMARY KEY,
    SName		varchar(8),
    Sex		char(2),
    Age		tinyint,
	   Place		varchar(20),
    Party		varchar(10),
    ClassNO	char(4)
);
CREATE TABLE Classes
(
    ClassNO	char(10),
    CName		varchar(30),
    Leader		varchar(8),
    PRIMARY KEY(ClassNO)
);
DROP table Students;
CREATE TABLE Students
(
    SN		char(10),
    SName	varchar(8) NOT NULL,
    Sex		char(2) DEFAULT '男',
    Age	tinyint,
    Place	varchar(20),
    Party	varchar(10),
    ClassNO	char(4),
    PRIMARY KEY(SN),
    FOREIGN KEY(ClassNO) REFERENCES Classes(ClassNO),
    CHECK(Age>=0 AND Age<=150)
);
INSERT INTO Classes VALUES('1710','一班','李四');
INSERT INTO Classes VALUES('1711','二班','吴七');
INSERT INTO Students VALUES(
'171001','张三','男',20,'北京','中共党员','1710');
INSERT INTO Students VALUES(
'171002','李四','男',21,'天津','共青团员','1710');
INSERT INTO Students VALUES(
'171003','王五','男',19,'上海','中共党员','1710');
INSERT INTO Students VALUES(
'171004','赵六','男',20,'重庆','群众','1710');
INSERT INTO Students VALUES(
'171101','吴七','男',22,'北京','中共党员','1711');
INSERT INTO Students VALUES(
'171102','刘八','男',21,'北京','中共党员','1711');