点歌系统课程设计.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数据添加5.4自动编号 3.5.5 建立触发器 3.5.6 建立索引 3.5.7 实现查询 3.5.8 子查询自动追加表 3.5.9 建立视图 3.5.12功能模块设计·····················································20 4实施与设计的异同本系统设计特色 1、课程设计题目 学习使用SQL Server2000，利用c++ builder为点歌系统设计和开发一个数据库应用系统。 2、课程设计内容 完成点歌系统的设计全过程：需求分析、数据库设计、数据库建立、数据输入、应用系统的设计和开发、用户界面的设计和实现等。 3、课程设计步骤　 3.1需求分析 3.1.1功能需求 问卷调查显示：方便快捷的检索功能、海量广泛的乐曲储备、更具个性化的功能设计是最常见的需求。 而其中提到的人性化设计主要包括： 1按照歌词检索 据反映，很多时候我们只是记得某首歌的几句歌词但并不能明确歌名以及演唱者，这个时候寻找一首歌就很有难度，如果能增添用歌词检索的功能将大大方便。 2对于点唱的记忆 希望自己已点唱的能再次方便的被找到，于是记忆是很必要的一项功能。 3根据自身喜好对于进行收藏 针对想要对自己喜爱的进行收藏的需求，本小组设计不同使用不同账号登陆系统，此时系统将自动根据不同反映其收藏的。