【正文】 損壞設(shè)備名 char 12 I37 Ischange 是否需更換 char 6 I38 Supplyname 耗材名稱(chēng) char 10 I39 RentNo 借用編號(hào) char 6 I40 RentReason 借用目的 char 40 I41 RepaireRecordNo 維修記錄編號(hào) char 6 I42 RepairTime 維修時(shí)間 samlldatetime I43 DamageInfo 損壞信息 char 50 設(shè)備損壞信息描述 I44 DamageTime 報(bào)告時(shí)間 samlldatetime 數(shù)據(jù)結(jié)構(gòu)的描述如下 表所示： 數(shù)據(jù)結(jié)構(gòu)編號(hào) 數(shù)據(jù)結(jié)構(gòu)名 組成 含義說(shuō)明 DS1 Student Sno,Sname,BirthYear,Pname,ClassNo, AttendSum, Image,Dept 學(xué)生信息 DS2 Teacher Tno,Tname,Dept,Title, 教師信息 DS3 Course Cno,Cname,Time,WeekNo, Weekday,SectionNo 課程信息 DS4 Classroom RoomNo,Roomname, Campusname,Buildname, Capacity,IsUsable, RemainCapacity,Type 教室信息 DS5 Group Leadername,IDType, ID,Tel 單位信息 DS6 Repairer RepairerNo,Repairernam,State,Tel 維修員信息 07 信管專(zhuān)業(yè) 072 班數(shù)據(jù)庫(kù)系統(tǒng)概論課程設(shè)計(jì)論文 8 DS7 Curriculum Cno,Tno,WeekNo, Weekday, SectionNo,RoomNo 課程表 DS8 RepaireRecord RepaireRecordNo， RoomNo, RepairerNo,Devicename,Ischange, Supplyname,RepaireTime 維修記錄 DS9 AdjClassLog TNo,RoomNo,NewWeekNo,NewWeekday, NewSectionNo, NewRoomNo 調(diào)課記錄 DS10 RentRecord RentDate,Leadername, RoomNo,WeekNo,Weekday,SectionNo 借用記錄 DS11 DamageReport Sno,RoomNo， Supplyname, DamageInfo， DamageTime 設(shè)備損壞報(bào)告 概念設(shè)計(jì)階段 引言 概念設(shè)計(jì)是數(shù)據(jù)庫(kù)設(shè)計(jì)的關(guān)鍵。另一方面，在事務(wù)處理中，修改了一個(gè)實(shí)體的屬性，可能要修改其它實(shí)體，這種事務(wù)的完整性約束采用觸發(fā)器來(lái)實(shí)現(xiàn)。同時(shí)為師生提供方便可靠的查詢(xún)。 關(guān)鍵字 ：教室管理，空教室查詢(xún)，數(shù)據(jù)庫(kù)設(shè)計(jì) 目錄 .............................................................................................................................. 1 本系 統(tǒng)研究的意義 ............................................................................................... 1 本系統(tǒng)的目的 ...................................................................................................... 1 本系統(tǒng)的任務(wù) ...................................................................................................... 1 ................................................................................................................... 1 需求分析階段 ...................................................................................................... 1 引言 ........................................................................................................... 1 需求分析的目的和任務(wù) ............................................................................... 2 體會(huì)與收獲 ....................................................................................... 2 教室管理系統(tǒng)的業(yè)務(wù)流程圖 ............................................................. 2 教室管理系統(tǒng)的數(shù)據(jù)流圖 ................................................................. 3 教室管理系統(tǒng)的數(shù)據(jù)字典 ................................................................. 6 概念設(shè)計(jì)階段 ...................................................................................................... 8 引言 .......................................................................................................... 8 概念設(shè)計(jì)的目標(biāo)與任務(wù) .............................................................................. 8 概念設(shè)計(jì)的目標(biāo) ................................................................................ 8 概念設(shè)計(jì)的具體任務(wù) ......................................................................... 8 概念設(shè)計(jì)的階段成果 ................................................................................. 9 邏輯結(jié)構(gòu)設(shè)計(jì) .................................................................................................... 12 引言 ......................................................................................................... 12 邏輯結(jié)構(gòu)設(shè)計(jì)階段的目標(biāo)和任務(wù) ............................................................... 12 數(shù)據(jù)組織 .................................................................................................. 13 將 ER 圖轉(zhuǎn)換為關(guān)系模型 ............................................................... 13 數(shù)據(jù)處理 .................................................................................................. 14 物理結(jié)構(gòu)設(shè)計(jì) .................................................................................................... 15 物理設(shè)計(jì)的目標(biāo) ....................................................................................... 15 物理設(shè)計(jì)的任務(wù) ....................................................................................... 15 索引的建立 .............................................................................................. 15 數(shù)據(jù)庫(kù)實(shí)施 ........................................................................................................ 15 數(shù)據(jù)庫(kù)實(shí)施階段的目標(biāo)和任務(wù) .................................................................. 15 建立基本表與視圖、建立觸發(fā)器和存儲(chǔ)過(guò)程、數(shù)據(jù)入庫(kù) ............................ 16 實(shí)施結(jié)果 .................................................................................................. 16 數(shù)據(jù)庫(kù)調(diào)試與試運(yùn)行 .......................................................................................... 16 測(cè)試方法 .................................................................................................. 16 測(cè)試內(nèi)容 .................................................................................................. 16 測(cè)試結(jié)果 .................................................................................................. 16 ................................................................................................................. 16 ....................................................................................................... 17 致謝 ............................................................................................................................... 17 參考文獻(xiàn) ........................................................................................................................ 17 附錄 1 數(shù)據(jù)庫(kù)模式定義的詳細(xì)說(shuō)明 ....................................................