数据库应用技术作业

《数据库应用技术作业》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、教学管理系统数据库设计1.系统所需要的表系表结构字段名数据类型字段大小可否为空说明Department1dChar10N(KEY)院系号DepartmentNameChar10N院系名字DepartmentManagerChar10N(KEY)班级人数班级表字段名数据类型字段大小可否为空说明ClassIDChar10N(KEY)班级编号ClassRoomChar10N教室DepartmentIdChar10N院系号CIassMasterChar10N班主任学生表字段名数据类型字段大小可否为空说明StudentIDChar10N(KEY)学号

2、StudentNameChar10N姓名StudentSexChar2N性别StudentAgeint固定长度N出生年月Classic!Char10N班级号StudentAddressChar20Y家庭地址教师表字段名数据类型字段大小可否为空说明ProfesserIDChar10N(KEY)教授编号ProfesstNameChar10N姓名ProfesserSexChar2N性别ProfesserAgeint固定长度N年龄ProfesserDepartmentChar10N院系ProfesserPositionChar20N职称课程表字段名

3、数据类型字段大小可否为空说明CourseIDChar5N(KEY)班级编号CourseNameChar20N教室CorseScoreint固定长度N班级人数ProfesserIdchar10N教师编号选课表字段名数据类型字段大小可否为空说明studentIdChar10N(KEY)学生编号CourseldChar10N课程编号Scoreint固定长度N成绩教室表字段名数据类型字段大小可否为空说明ClassroomIDChar10N(KEY)教室编号C1assRoomNameChar10N教室名字ClassPositionchar10N教室位

4、置使用情况表字段名数据类型字段大小可否为空说明C1ass1DChar5N(KEY)班级编号ClassRoomldChar20N教室ClassDateDateTime10N上课时间UseTimechar10N占用学时二.ER图如下Department參Departmentld(PK)VDepartmentNmaeVDepartmentlilanger—>Classld(PK)>ClassName>>ClassMaster^iDepartmentld(FK)Studentyse>Classroomld(PK)Classld(FK)>>Class

5、Date>UseTime>O--丄丄II.JgXTeachingIProfessld(FK)%Classld(FK)>>Courseld>>TeachTime9Studentld(PK)VStudentName>StudentAge♦Classld(FK)QStudentSex、Courseld(FK)专Studentld(FK)dScoreSelectcourse厂…ClassRoomClassld(FK)QClassroomNameJClassroompositionProfesserT事Professld(PK)〉ProfessNa

6、me0ProfessPositionQProfessSex0ProfessAgeQProfessDepartmentCourse呂Courseld(PK)>CourseName>CourseScore>Teacher1dSProfessld(FK)