數(shù)據(jù)庫(kù)課程設(shè)計(jì)文檔(學(xué)生考勤管理系統(tǒng)c)-資料下載頁(yè)
2024-08-19 16:23本頁(yè)面
【正文】 ）班級(jí)選課表create table class_course(class_code char(12) not null,o char(12)not null,class_time char(12),primary key(class_code,o,class_time),foreign key(class_code)references class(class_code),foreign key(o,class_time)references course(o,class_time))。（8）學(xué)生個(gè)人出勤情況統(tǒng)計(jì)表create table attendance(currenttime char(20) not null,class_time char(12),sno char(12)not null,o char(12)not null,attendance_state char(12) not null,primary key(sno,o,currenttime),check (attendance_state in(39。正常39。,39。遲到39。,39。曠課39。,39。早退39。,39。請(qǐng)假39。)),foreign key(sno)references student(sno),foreign key(o,class_time)references course(o,class_time))alter table attendanceadd constraint DF_attendance_state default39。正常39。 for attendance_state。（9）建立批假表create table leave(off_start datetime not null,off_end datetime not null,sno char(12) not null,teachername char(20) not null,primary key(sno,off_start,off_end),foreign key(sno)references student(sno),)alter table leaveadd reason varchar(100)。（9）創(chuàng)建視圖create view attendance_viewasselect ,sname,ame,currenttime,attendance_statefrom student ,course,attendancewhere = and = 6．系統(tǒng)運(yùn)行界面展示6．1考勤人員界面（1）登錄界面（2）首頁(yè)（3）點(diǎn)名窗體（4）查看請(qǐng)假學(xué)生具體信息窗體（1）查看學(xué)生出勤狀況窗體（2）教師批假窗體（1）查看出勤信息窗體（1）查看界面（2）用戶管理界面
語(yǔ)文相關(guān)推薦
鄂ICP備17016276號(hào)-1