点歌系统课程设计.doc

课 程 设 计 课程名称__数据库系统概论______ 题目名称__点歌系统_____ 学生学院__计算机______________ 专业班级__ ___________ 学 号___________ 学生姓名___ _____________ 指导教师___左亚尧_____________ 2013年 1月 12 日 目录 1课程设计题目···································································3 2课程设计内容···································································3 3课程设计步骤···································································3 3.1需求分析·································································3 3.1.1功能需求···························································3 3.1.2数据字典···························································3 3.1.3业务流程···························································5 3.2概念结构设计 ····························································6 3.3逻辑结构设计 ····························································7 3.3.1关系模式···························································7 3.3.2安全性设计·························································7 3.3.3一致性设计·························································7 3.4物理结构设计 ····························································7 3.5数据库实施································································7 3.5.1建数据库····························································7 3.5.2数据表·····························································7 3.5.3数据添加···························································9 3.5.4自动编号···························································13 3.5.5 建立触发器························································13 3.5.6 建立索引··························································14 3.5.7 实现查询··························································14 3.5.8 子查询自动追加表··················································14 3.5.9 建立视图··························································15 3.5.10数据库的权限管理·················································15 3.5.11数据库备份和恢复方案··············································18 3.5.12功能