数据库设计人员招聘系统1目录1.系统需求分析阶段给..............................................................................................................................................21.1需求分析阶段给的任务................................................................................................................................21.2需求分析阶段成果........................................................................................................................................22.概念设计阶段..........................................................................................................................................................92.1概念模型设计................................................................................................................................................93.逻辑设计阶段..........................................................................................................................................................113.1将E-R图转换为关系模型..........................................................................................................................113.2用户子模式设计..........................................................................................................................................123.4数据处理......................................................................................................................................................134.物理设计阶段..........................................................................................................................................................144.1数据库存储结构..........................................................................................................................................145.数据库实施阶段......................................................................................................................................................155.1建立数据库..................................................................................................................................................155.2建立数据表..................................................................................................................................................155.2数据入库......................................................................................................................................................175.3创建视图......................................................................................................................................................205.4创建字段约束..............................................................................................................................................226.系统调试和测试....................................................................................................................................................226.1查看各个表的数据......................................................................................................................................226.2查看各个视图..............................................................................................................................................256.3测试约束条件.......................................................................
