电商09数据库系统实习报告(学号+姓名)浙江树人大学信息科技学院《数据库系统实习》实习报告课题:进销存管理系统班级:电商091学号:200905017122姓名:何锴翔2012.3目录1电商09数据库系统实习报告(学号+姓名)第一章需求分析.........................................................................................................................31.1功能介绍.................................................................................................................31.2系统目标..............................................................................................................................31.3系统功能划分......................................................................................................................31.4功能描述..............................................................................................................................3第二章概念结构设计............................................................................................................................52.1目的......................................................................................................................................52.2各个分E-R图.......................................................................................................................52.3全局E-R图...........................................................................................................................8第三章逻辑结构设计..........................................................................................................................103.1目的....................................................................................................................................103.2建立关系模式....................................................................................................................103.3关系模式规范化................................................................................................................10第四章物理结构设计..........................................................................................................................124.1目的....................................................................................................................................124.2表的构建............................................................................................................................124.3索引的作用........................................................................................................................154.4索引代码............................................................................................................................15第五章数据库完整性、安全性设计..................................................................................................165.1目的....................................................................................................................................165.2数据库完整性设计.............................................................................................................165.3数据库安全性设计.............................................................................................................18第六章实训总结.................................................................................................................................