资源描述:
《教务管理系统-sql》由会员上传分享,免费在线阅读,更多相关内容在应用文档-天天文库。
1、教务管理系统苏伟2012012567officiallyestablishedonJuly1,2013,Yibincity,formerlyknownasthebus,integratedoriginalrongzhoubuscompanyinYibincityandMetrobuscompany,formedonlyinYibincityofaState-ownedpublictransportenterprises,thecompanyconsistsofoneortwo,thirdDivision.Integrationofpublictransportservice
2、sisnotyetestablished目录第一章数据库设计1.1实体属性图设计1.2实体关系图设计1.2关系模式1.3数据表结构1.4数据库关系图第二章创建数据库2.1建立数据库2.2建立数据表第三章插入数据3.1insert语句插入数据3.2excel导入数据officiallyestablishedonJuly1,2013,Yibincity,formerlyknownasthebus,integratedoriginalrongzhoubuscompanyinYibincityandMetrobuscompany,formedonlyinYibincityofaSt
3、ate-ownedpublictransportenterprises,thecompanyconsistsofoneortwo,thirdDivision.Integrationofpublictransportservicesisnotyetestablished第一章数据库设计1.1ER图设计如图1-1教师实体属性图图1-1如图1-2教室实体属性图图1-2如图1-3课程实体属性图officiallyestablishedonJuly1,2013,Yibincity,formerlyknownasthebus,integratedoriginalrongzhoubusc
4、ompanyinYibincityandMetrobuscompany,formedonlyinYibincityofaState-ownedpublictransportenterprises,thecompanyconsistsofoneortwo,thirdDivision.Integrationofpublictransportservicesisnotyetestablished图1-3如图1-4课程班实体属性图图1-4如图1-5学生实体关系图图1-5如图1-6成绩实体关系图officiallyestablishedonJuly1,2013,Yibincity,f
5、ormerlyknownasthebus,integratedoriginalrongzhoubuscompanyinYibincityandMetrobuscompany,formedonlyinYibincityofaState-ownedpublictransportenterprises,thecompanyconsistsofoneortwo,thirdDivision.Integrationofpublictransportservicesisnotyetestablished图1-6如图1-7班级实体关系图图1-7如图1-8教研室实体关系图图1-8如图1-9专
6、业实体关系图officiallyestablishedonJuly1,2013,Yibincity,formerlyknownasthebus,integratedoriginalrongzhoubuscompanyinYibincityandMetrobuscompany,formedonlyinYibincityofaState-ownedpublictransportenterprises,thecompanyconsistsofoneortwo,thirdDivision.Integrationofpublictransportservicesisnotyetest
7、ablished图1-9如图1-10学院实体关系图图1-10如图1-11教学楼实体关系图图1-11如图1-12校区实体属性图图1-12officiallyestablishedonJuly1,2013,Yibincity,formerlyknownasthebus,integratedoriginalrongzhoubuscompanyinYibincityandMetrobuscompany,formedonlyinYibincityofaState-ownedpublictransportenterprises