2create tb.sql

一个教学管理系统,可以满足一般课程设计的要求

use scdb
create table scdb.dbo.student
(
s_id         char(10) primary key,
s_name       char(10) not null,
age          tinyint,
sex	     char(2),
class        char(20))

create table scdb.dbo.lesson
(
l_id         char(4)primary key,
l_name       char(20) not null,
l_time       char(3),
l_fen       char(3))

create table scdb.dbo.choose
(
s_id         char(10) references student(s_id),
l_id         char(4) references lesson(l_id),
mark         tinyint check(mark between 0 and 100 ))

create table scdb.dbo.teacher
(
t_id         char(4) primary key,
t_name       char(4))

create table scdb.dbo.kecheng
(
l_id         char(4) references lesson(l_id),
t_id         char(4) references teacher(t_id))

create table scdb.dbo.users
(
u_id    char(10) primary key,
u_name  char(10),
u_mima  char(10))