JIANGXI AGRICULTURAL UNIVERSITY数据库课程设计报告题目: 学生成绩管理系统数据库设计 学 院: 姓 名: 学 号: 专 业: 班 级: 指导老师: 二 0 一二 年 6 月目录一、需求分析..........................................................................................................................31.1 需求概述...................................................................................................................31.2 功能简介...................................................................................................................3二、数据库设计......................................................................................................................32.1 确定联系集及 E-R 图..............................................................................................32.2 画出 E-R 图...............................................................................................................42.3 学生成绩管理系统总 E-R 图..................................................................................5三、逻辑数据库设计阶段.....................................................................................................63.1 班级信息表(Class)..................................................................................................73.2 学生信息表(Student)............................................................................................73.3 课程信息表(Course).........................................................................................83.4 成绩表(Score)....................................................................................................8四、建表..................................................................................................................................84.1 创建数据库...............................................................................................................84.2 创建数据表......................................................