数据库实验报告（包含建表语句，查询语句）

create database huanglei

use huanglei;

student_id char(8) not null primary key,

student_name char(8) not null ,

student_sex bit not null,

student_birth smalldatetime not null,

class_id char(6) not null,

entrance_date smalldatetime not null,

foreign key (class_id) references class(class_id)

)

create table student2(

foreign key (class_id) references class(class_id)

)

create table class

(class_id char(6)not null primary key,

monitor nvarchar(8) null,

classroom varchar(13)null,

student_num smallint null default 0 )

create table course

(course_id varchar(50) not null primary key,

course_name varchar(50) not null,

primary key(course_id,student_id),

foreign key (course_id) references course(course_id),

foreign key (student_id) references student(student_id)

01')

insert student values('4080412','huan','1','1987-09-25','40804','2008-09-

01')

01')

01')

09-01');

09-01');