酒店客房管理系统数据库设计

《酒店客房管理系统数据库设计》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、任务书一、数据库原理课程设计的任务1）通过本课程设计的训练，使学生掌握数据库技术的实际应用以及数据库信息管理系统的设计方法与开发过程；初步掌握数据库需求分析方法，掌握概要设计、逻辑设计和物理设计的步骤和技巧，理解并掌握数据库系统的整个开发过程。2）通过课程设计，掌握数据库开发工具的使用以及综合编程调试的能力，结合数据库原理的基本理论，选用一种现代关系数据库系统，设计一个具体的信息管理系统，具备基本的数据库编程能力，为以后能进行数据库系统设计、开发与维护打下良好的基础。3）提升工程实践能力、团队协作精神、交流与沟通

2、能力；4）通过规范化的实验报告，培养学生良好的文档习惯以及撰写规范文档的能力。二、课程设计的基本内容课设内容结合一个具体任务（课程设计题目），完成一个基于C/S或B/S模式的数据库系统的设计，主要应包括如下内容：1．完成课题任务的需求分析、完成系统总体结构设计方案（主控功能模块、数据处理模块、统计报表模块等）；2．数据库结构的设计与实现；3．数据库安全的设计；4.数据修改的设计、数据查询的设计；5．统计与报表输出的设计；目的与要求目的：结合数据库原理的基本理论，选用一种现代关系数据库系统，设计一个具体的信息管理系

3、统。要求：受学生对于所学基础和专业知识的综合应用能力及程序设计与调试能力的不同，一周时间大体分为三个阶段：需求分析；数据库设计；应用程序设计。要求提交相关软件和规范的设计说明书电子文档。要求在设计过程中树立科学的设计思想，有全局观念，培养高度的协作精神。21课设形式1、2-3人一组2、课内10学时，课内检查，其余为课外学时。课设考核1、现场验收并对实验内容进行提问。2、根据设计方案、实验结果、附加功能、操作熟练程度、现场检查和回答情况及课程设计报告质量综合评定成绩。21目录1.数据库需求分析···········

4、····························41.1设计目的·············································41.2系统功能分析·········································41.3功能模块设计·········································52.数据库概念结构设计··································62.1概念模型······················

5、·······················62.2E-R模型·············································63.数据库逻辑结构设计··································83.1关系模型设计········································93.2数据模型的优化······································93.3子模式设计····························

6、··············94.数据库21物理结构设计··································94.1存取方式设计·········································94.2存储结构设计········································101.数据库安全性、完整性设计··························105.1主要视图设计········································105

7、.2用户权限············································102.数据库实现···········································116.1编码实现············································116.1.1主要数据表的创建···································116.1.2主要视图的创建·····································146

8、.1.3索引的创建········································146.1.4创建用户权限······································146.1.5创建存储结构·······································153.21数据录入调试及运行····················