数据库原理及应用课程设计<<医药销售管理系统>>学生姓名：+++++++学生班级：++++学生学号：++++++指导老师：+++++++目录一.系统需求分析......................................................................................................................................11.1开发目的.......................................................................................................................................11.2开发背景.........................................................................................................................................11．1.1系统功能基本要求....................................................................................................................11.1.2具体要求如下.............................................................................................................................11.2.系统功能分析图...........................................................................................................................21.3数据流图和数据字典.....................................................................................................................31.3.1数据流图（DFD）.......................................................................................................................31.3.2数据字典（DD）........................................................................................................................5二.概念结构设计......................................................................................................................................62.1局部E-R图设计............................................................................................................................62.3系统总E-R图.................................................................................................................................9三.逻辑结构设计..................................................................................................................................113.1.逻辑结构实体转换成关系.........................................................................................................11四.物理结构设计....................................................................................................................................134.1分类存储.....................................................................................................................................134.2存取路径.....................................................................................................................................134.3备份和还原.................................................................................................................................134.4索引...............................................................................................................................................144.5视图的建立...................................................................................................................................14五.数据库实施........................................................................................................................................155.1建立数据库...................................................................................................................................155.2表和截图..........................
