【正文】 損壞設(shè)備名 char 12 I37 Ischange 是否需更換 char 6 I38 Supplyname 耗材名稱 char 10 I39 RentNo 借用編號 char 6 I40 RentReason 借用目的 char 40 I41 RepaireRecordNo 維修記錄編號 char 6 I42 RepairTime 維修時間 samlldatetime I43 DamageInfo 損壞信息 char 50 設(shè)備損壞信息描述 I44 DamageTime 報告時間 samlldatetime 數(shù)據(jù)結(jié)構(gòu)的描述如下 表所示： 數(shù)據(jù)結(jié)構(gòu)編號 數(shù)據(jù)結(jié)構(gòu)名 組成 含義說明 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 信管專業(yè) 072 班數(shù)據(jù)庫系統(tǒng)概論課程設(shè)計論文 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è)備損壞報告 概念設(shè)計階段 引言 概念設(shè)計是數(shù)據(jù)庫設(shè)計的關(guān)鍵。另一方面，在事務(wù)處理中，修改了一個實體的屬性，可能要修改其它實體，這種事務(wù)的完整性約束采用觸發(fā)器來實現(xiàn)。同時為師生提供方便可靠的查詢。 關(guān)鍵字 ：教室管理，空教室查詢，數(shù)據(jù)庫設(shè)計 目錄 .............................................................................................................................. 1 本系 統(tǒng)研究的意義 ............................................................................................... 1 本系統(tǒng)的目的 ...................................................................................................... 1 本系統(tǒng)的任務(wù) ...................................................................................................... 1 ................................................................................................................... 1 需求分析階段 ...................................................................................................... 1 引言 ........................................................................................................... 1 需求分析的目的和任務(wù) ............................................................................... 2 體會與收獲 ....................................................................................... 2 教室管理系統(tǒng)的業(yè)務(wù)流程圖 ............................................................. 2 教室管理系統(tǒng)的數(shù)據(jù)流圖 ................................................................. 3 教室管理系統(tǒng)的數(shù)據(jù)字典 ................................................................. 6 概念設(shè)計階段 ...................................................................................................... 8 引言 .......................................................................................................... 8 概念設(shè)計的目標(biāo)與任務(wù) .............................................................................. 8 概念設(shè)計的目標(biāo) ................................................................................ 8 概念設(shè)計的具體任務(wù) ......................................................................... 8 概念設(shè)計的階段成果 ................................................................................. 9 邏輯結(jié)構(gòu)設(shè)計 .................................................................................................... 12 引言 ......................................................................................................... 12 邏輯結(jié)構(gòu)設(shè)計階段的目標(biāo)和任務(wù) ............................................................... 12 數(shù)據(jù)組織 .................................................................................................. 13 將 ER 圖轉(zhuǎn)換為關(guān)系模型 ............................................................... 13 數(shù)據(jù)處理 .................................................................................................. 14 物理結(jié)構(gòu)設(shè)計 .................................................................................................... 15 物理設(shè)計的目標(biāo) ....................................................................................... 15 物理設(shè)計的任務(wù) ....................................................................................... 15 索引的建立 .............................................................................................. 15 數(shù)據(jù)庫實施 ........................................................................................................ 15 數(shù)據(jù)庫實施階段的目標(biāo)和任務(wù) .................................................................. 15 建立基本表與視圖、建立觸發(fā)器和存儲過程、數(shù)據(jù)入庫 ............................ 16 實施結(jié)果 .................................................................................................. 16 數(shù)據(jù)庫調(diào)試與試運行 .......................................................................................... 16 測試方法 .................................................................................................. 16 測試內(nèi)容 .................................................................................................. 16 測試結(jié)果 .................................................................................................. 16 ................................................................................................................. 16 ....................................................................................................... 17 致謝 ............................................................................................................................... 17 參考文獻 ........................................................................................................................ 17 附錄 1 數(shù)據(jù)庫模式定義的詳細(xì)說明 ....................................................