教務(wù)網(wǎng)絡(luò)管理系統(tǒng)(編輯修改稿)
2025-05-09 12:58 本頁面
【文章內(nèi)容簡介】 go/*創(chuàng)建book表*/create table book(book_id char(13) not null,book_name varchar(30) not null,publish_pany varchar(50) not null,author nvarchar(8) null,price numeric(5,2) null)go/*創(chuàng)建class表*/create table class(class_id char(6) not null,monitor nvarchar(8) null,classroom nvarchar(13) null,student_num smallint null)go/* 創(chuàng)建teacher表*/create table teacher（teacher_id char(9) not null,teacher_name nvarchar(8) not null,sex bit not null,birth smalldatetime not null,department_id char(6) not null,profession nvarchar(16) not null,telephone nvarchar(15) null,home_addr nchar(40) null, postalcode postalcode null)go/*創(chuàng)建course表*/create table course（course_id char(10) not null,course_name nvarchar(20) not null,book_id char(13) not null,total_perior tinyint null,week_perior tinyint null,credit tinyint null)go/*創(chuàng)建class_course表*/create table class_course(class_id char(6) not null,course_id char(10) not null)go/*創(chuàng)建student_course表*/create table student_course(course_id char(10) not null,student_id char(8) not null,grade tinyint not null,credit tinyint not null,semester bit null,school_year char(9) null)go/*創(chuàng)建teacher_course_class表*/create table teacher_course_class(teacher_id char(9) not null,course_id char(10) not null,class_id char(6) not null,semester bit not null,school_year char(9) not null,course_schedule varchar(50) null,course_classroom varchar(13) null)go創(chuàng)建約束主鍵約束student表use jwglalter table studentadd constraint student_id_pkprimary key(student_id)goBOOK表：use jwglalter table bookadd constraint book_id_pkprimary key(book_id)goCLASS表use jwglalter table classadd constraint class_id_pkprimary key(class_id)goTEACHER表use jwglalter table teacheradd constraint teacher_id_pkprimary key(teacher_id)goCOURSE表use jwglalter table courseadd constraint course_id_pkprimary key(course_id)goCLASS_COURSE表use jwglalter table class_courseadd constraint class_course_id_pkprimary key(class_id,course_id)goSTUDENT_COURSE表use jwglalter table student_courseadd constraint student_course_id_pkprimary key(student_id,course_id)goTEACHER_COURSE_CLASS表use jwglalter table teacher_course_classadd co
公司管理相關(guān)推薦
鄂ICP備17016276號-1