牛肉汤料包配方大全:什数据库的SQL SERVER帮忙做下作业（重奖）

/*1。student表
student_id(学生标识)
student_name(姓名)
sex(性别)
birth(出生年月)
class_id(班级号)
entrance_time(入学时间)
home_addr(家庭住址)
主关键字：student_id
*/
create table student(
student_id int primary key,
student_name varchar(50),
sex char(2) check(sex in('男','女')),
birth datetime,
class_id int,
entrance_time datetime,
home_addr varchar(1024)
);

/*
2.department表
dipartment_id(系标识)
department_name(系名)
department_header(系主任)
teacher_num(系教师人数)
主关键安：department_id
*/
create table department(
department_id int primary key,
department_name varchar(50) ,
department_header int,
teacher_num bigint
);

/*
3.teacher表
teacher_id(教师标识)
teacher_name(姓名)
sex(性别)
birth(出生年月)
department_id(系号)
profession(职位)
home_addr(家庭住址)
postalcode(邮政编码)
telephone(联系电话)
主关键字：teacher_id
*/
create table teacher(
teacher_id int primary key,
teacher_name varchar(50),
sex char(2) check(sex in('男','女')),
birth datetime,
department_id int references department(department_id),
profession varchar(10),
home_addr varchar(500),
posttalcode char(6),
telephone varchar(20)
);
alter table department add constraint for_department_teacher
foreign key(department_header) references teacher(teacher_id);

/*
4.class表
class_id(班级标识)
monitor(班长)
classroom(教室地点)
student_num(学生人数)
主关键字：class_id
*/
create table class(
class_id int,
monitor int references student(student_id),
classroom varchar(200) not null,
student_num int,
primary key (class_id)
);
alter table student add constraint for_student_class
foreign key(class_id) references class(class_id);

/*
5.course表
course_id(课程标识)
course_name(课程名)
book_id(书号)
total_period(总学时)
week_period(周学时)
credit(课程学分)
主关键安：course_id+department_id
*/
create table course(
course_id int not NULL,
course_name varchar(30),
book_id int,
total_period int,
week_period smallint,
credit smallint,
primary key(course_id)
);

/*
6。book表
book_id(教材标识)
bood_name(书名)
publishing_company(出版社)
author(作者)
price(书价)
主关键字：book_id
*/
create table book(
book_id int primary key,
book_name varchar(200),
piblishing_company varchar(200),
author varchar(50),
price money
);
alter table course add constraint for_course_book
foreign key(book_id) references book(book_id);

/*
7.Class_course表
class_id(班级号)
course_id(课程号)
主关键字：chass_id.course_id
*/
create table Class_course(
class_id int not null,
course_id int not null,
primary key(class_id,course_id),
foreign key (class_id) references class(class_id),
foreign key (course_id) references course(course_id)
);

/*
8。student_course表
course_id(课程号)
student_id(学号)
grade(学习成绩)
credit(学分)
semester(学期)(哪一学期学习的)
school_year(学年)(哪一年学习的)
主关键字：course_id+student_id
*/
create table student_course(
course_id int references course(course_id),
student_id int references student(student_id),
grade smallint check(grade>-1),
credit int check(credit>-1),
semester int,
school_year int check(school_year>999 and school_year<10000),
primary key(course_id,student_id)
);
/*
9. techer_course_class表
techer_id(教师号)
course_id(课程号)
class_id(班级号)
semester(学期)
school_year(学年)
course_schedule(课程时间安排标识)
course_classroom(课程地点安排标识)
主关键字：techer_id+course_id+class_id
*/
create table teacher_course_class(
teacher_id int,
course_id int,
class_id int,
semester int check(semester in(1,2)),
school_year int,
course_schedule varchar(200),
course_classroom varchar(200),
primary key(teacher_id,course_id,class_id),
foreign key(teacher_id) references teacher(teacher_id),
foreign key(class_id,course_id) references class_course(class_id,course_id)
);

呵呵，这个太困难了，你要加大悬赏我看才可能有人帮忙。

其实蛮容易的，只要有SQL server这个软件。可是我家没有……要不然我就帮你做了……
我刚学会SQL server。

未免太那个把。

做是能做,可是,工程量太大!