學(xué)生信息管理系統(tǒng)-吳燕燕(編輯修改稿)
2025-05-04 23:06 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 做的工作就是應(yīng)該進(jìn)行數(shù)據(jù)庫(kù)的設(shè)計(jì)及系統(tǒng)設(shè)計(jì)。5. 數(shù)據(jù)庫(kù)設(shè)計(jì) 學(xué)生信息管理系統(tǒng)采用了Microsoft推出的SQL Server2000作為后臺(tái)數(shù)據(jù)庫(kù) 數(shù)據(jù)庫(kù)需求分析 在設(shè)計(jì)數(shù)據(jù)庫(kù)結(jié)構(gòu)時(shí)，以及可能地滿足用戶所提出的各項(xiàng)要求，同時(shí)又避免同時(shí)又要避免冗余數(shù)據(jù)產(chǎn)生。由于在學(xué)生信息管理系統(tǒng)中，需要采集大量的信息，包括學(xué)生信息，班級(jí)信息，課程信息，成績(jī)信息，專(zhuān)業(yè)信息等，如果不能夠合理有效地組織數(shù)據(jù)表的結(jié)構(gòu)，以及合理設(shè)置每張表所包含的字段，那么后期進(jìn)行的數(shù)據(jù)的整理以及匯總時(shí)，就會(huì)增加編程人員的開(kāi)發(fā)難度，并造成成績(jī)效益的大幅度下降。根據(jù)學(xué)生基本信息以及其他相關(guān)信息的特點(diǎn)，歸納出以下規(guī)律：；；；；；；；；；；BuZhuInfo{ SpecialtyName,ClassName,Semester,Name,StudentNumbe,Enrolmentyear,Sex,BuZhuDate,BuZhuJinE,JiaTingInfo,Remark}ChufaInfo{SpecialtyName,ClassName,Semester,Name,StudentNumber, Enrolmentyear, Sex, ChufaDate, ChufaType, ChufaReason}ClassInfo {ClassID,ClassName,SpecialtyName,ClassNumber,Length,Teacher,EnrolmentTime, Remark}CourseInfo{ CourseID，ClassID，Course，Semester}DaiKuanInfo{SpecialtyName,ClassName,Semester,Name,StudentNumbe,Enrolmentyear,Sex, DaiKuanDate, Xuefei, Zhusufei, Shufei, Shenghuofei, Remark}FeiyongInfo{SpecialtyName,ClassName,Semester,Name,StudentNumber, Enrolmentyear, Sex, JiaofeiDate, Xuefei, Zhusufei, Shufei, Remark}JiangliInfo {SpecialtyName,ClassName,Semester,Name,StudentNumber,Enrolmentyear,Sex,AwardDate,AwardType,AwardReason}JiangXuejinInfo{SpecialtyName,Name,ClassName,StudentNumber,Enrolmentyear,Semester,JiangXiang,JinE,Remark}KaoQinInfo {SpecialtyName,Name,ClassName,StudentNumber,Enrolmentyear,Semester,JiangXiang,JinE,Remark}Roles{RoleName,SystemManage,SpecialtyManage,ClassManage,CourseManage,ScoreManage,StudentManage,DaikuanManage,JiangchengManage,JiangxuejinManage}ScoreInfo{ScoreID,Semester,StudentNumber,Course,Score}SpecialtyInfo{SpecialtyID,SpecialtyName,Remark}StudentInfo{SpecialtyID,SpecialtyName,Remark}UserInfo {Name,Passwd,RoleName}BuZhuInfo表 字段名稱(chēng) 數(shù)據(jù)類(lèi)型 長(zhǎng)度 允許空SpecialtyNamenvarchar50否ClassNamenvarchar50否Semesternvarchar50否Namenvarchar50否StudentNumbernvarchar50否Enrolmentyearnvarchar50否Sexnvarchar50否BuZhuDatesmalldatetime4否BuZhuJinEint4否JiaTingInfontext16否Remarkntext16否 ChufaInfo表 字段名稱(chēng) 數(shù)據(jù)類(lèi)型 長(zhǎng)度 允許空SpecialtyNamenvarchar50否ClassNamenvarchar50否Semesternvarchar50否Namenvarchar50否StudentNumbernvarchar50否Enrolmentyearnvarchar50否Sexnvarchar50否ChufaDatesmalldatetime4否ChufaTypeint4否ChufaReasonntext16否 ClassInfo 表 字段名稱(chēng) 數(shù)據(jù)類(lèi)型 長(zhǎng)度 允許空ClassIDint4否ClassNamenvarchar50是SpecialtyNamenvarchar50是ClassNumbernvarchar50是Lengthint4是Teachernvarchar50是EnrolmentTimesmalldatetime4是Remarkntext16是CourseInfo表 字段名稱(chēng) 數(shù)據(jù)類(lèi)型 長(zhǎng)度 允許空CourseIDint4否ClassIDint4是Coursenvarchar50是Semesternvarchar50是DaiKuanInfo表 字段名稱(chēng) 數(shù)據(jù)類(lèi)型 長(zhǎng)度 允許空SpecialtyNamenvarchar50否ClassNamenvarchar50否Semesternvarchar50否Namenvarchar50否StudentNumbernvarchar50否Enrolmentyearnva
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1