--班级
create table Class(
ClassID int not null primary key ,
Cname varchar(20) not null,
)
--学生
create table Student(
StudentID int not null primary key ,
Sname varchar(20) not null,
SPassword varchar(20) not null,
SSex varchar(20) not null check (ssex='男' or ssex='女'),
IDcard varchar(20) not null,
ClassID int references class(ClassID),
)
--老师
create table Teacher(
TeacherID int not null primary key ,
Tname varchar(20) not null,
TPassword varchar(20) not null,
TSex varchar(20) not null check (tsex='男' or tsex='女'),
Title varchar(20) not null,
)
--用户
create table Users(
Account varchar(20) primary key not null,
Password varchar(20) not null,
Type varchar(20) not null,
)
--课程
create table Course(
CourseID int not null primary key,
Kname varchar(20) not null,
Grade varchar(20) not null,
FirstCourse varchar(20),
CTime varchar(20) not null,
)
--选课
create table Selection(
StudentID int references student(StudentID),
CourseID int references Course(CourseID),
primary key(studentid,COURSEID),
)
--授课
create table Teaching(
TeacherID int references teacher(TeacherID),
CourseID int references Course(CourseID),
create table Class(
ClassID int not null primary key ,
Cname varchar(20) not null,
)
--学生
create table Student(
StudentID int not null primary key ,
Sname varchar(20) not null,
SPassword varchar(20) not null,
SSex varchar(20) not null check (ssex='男' or ssex='女'),
IDcard varchar(20) not null,
ClassID int references class(ClassID),
)
--老师
create table Teacher(
TeacherID int not null primary key ,
Tname varchar(20) not null,
TPassword varchar(20) not null,
TSex varchar(20) not null check (tsex='男' or tsex='女'),
Title varchar(20) not null,
)
--用户
create table Users(
Account varchar(20) primary key not null,
Password varchar(20) not null,
Type varchar(20) not null,
)
--课程
create table Course(
CourseID int not null primary key,
Kname varchar(20) not null,
Grade varchar(20) not null,
FirstCourse varchar(20),
CTime varchar(20) not null,
)
--选课
create table Selection(
StudentID int references student(StudentID),
CourseID int references Course(CourseID),
primary key(studentid,COURSEID),
)
--授课
create table Teaching(
TeacherID int references teacher(TeacherID),
CourseID int references Course(CourseID),