數(shù)據(jù)庫課程設(shè)計文檔(學生考勤管理系統(tǒng)c)(已改無錯字)
2022-09-07 16:23:20 本頁面
【正文】 urse(o,class_time)（4）批假表參照了學生表的學生代碼foreign key(sno)references student(sno),5．數(shù)據(jù)庫的運行與維護5．1數(shù)據(jù)庫的初始化（包括數(shù)據(jù)庫、表以及視圖的建立）（1）創(chuàng)建考勤管理系統(tǒng)create database kaoqinon(name=kaoqin,filename=39。D:\39。,size=20mb,maxsize=200mb,filegrowth=2mb)log on(name=39。kaoqin_log39。,filename=39。d:\39。,size=10mb,maxsize=100mb,filegrowth=2mb)。（2）創(chuàng)建學生表create table student(sno char(12)primary key,sname char(20)not null,ssex char(2)check(ssex in(39。男39。,39。女39。)) not null,sdept char(20)not null,sentrance_time datetime not null,spassword char(12)not null,class_code char(12)not nullforeign key(class_code) references class(class_code))（3）創(chuàng)建課程表create table course(o char(12),ame char(20)not null,credit char(6)not null,class_time char(12) not null,tno char(12)not nullprimary key(o,class_time),foreign key(tno) references teacher(tno),)。（4）創(chuàng)建班級表create table class(class_code char(12)primary key,class_name char(20) not null,tno char(12) not null,班主任foreign key(tno) references teacher(tno)參照教師表)。（6）創(chuàng)建教師表 tno char(12)primary key,tname char(20)not null,tsex char(2)check(tsex in(39。男39。,39。女39。))not null,tentrance_time datetime not null,tpassword char(12)not null,tdept char(20)not null,troom char(20)not null,ttitle char(20)not null)。（7
語文相關(guān)推薦
鄂ICP備17016276號-1