数据库作业(酒店管理).doc

《数据库作业(酒店管理).doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、酒店管理系统需求分析：随着餐饮业的发展，人工的管理方式已不能满足管理者的要求，于是引入计算机应用管理系统。点菜功能菜单，是最常用的功能。例如在确定添加菜品是，既可以通过菜品编号确定，又可以通过菜品名称确定。自动结账功能是系统的主要功能之一，只需用户选中结账的台号，系统就会自动选中的台号计算消费金额。报表功能是酒店管理系统必不可少的部分，由于系统是记账软件，报表功能是必不可少的。再者就是系统维护功能，用来保障软件的安全运行。ER图餐台座位数台号菜系名称序号菜品单价菜系名称编号消费单操作员金额消费餐台

2、编号逻辑结构设计：SQL语句：GOEXECdbo.sp_dbcmptlevel@dbname=N'db_DrinkeryManage',@new_cmptlevel=80GOIF(1=FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))beginEXEC[db_DrinkeryManage].[dbo].[sp_fulltext_database]@action='disable'endGOALTERDATABASE[db_DrinkeryManage]S

3、ETANSI_NULL_DEFAULTOFFGOALTERDATABASE[db_DrinkeryManage]SETANSI_NULLSOFFGOALTERDATABASE[db_DrinkeryManage]SETANSI_PADDINGOFFGOALTERDATABASE[db_DrinkeryManage]SETANSI_WARNINGSOFFGOALTERDATABASE[db_DrinkeryManage]SETARITHABORTOFFGOALTERDATABASE[db_Drink

4、eryManage]SETAUTO_CLOSEONGOALTERDATABASE[db_DrinkeryManage]SETAUTO_CREATE_STATISTICSONGOALTERDATABASE[db_DrinkeryManage]SETAUTO_SHRINKONGOALTERDATABASE[db_DrinkeryManage]SETAUTO_UPDATE_STATISTICSONGOALTERDATABASE[db_DrinkeryManage]SETCURSOR_CLOSE_ON_C

5、OMMITOFFGOALTERDATABASE[db_DrinkeryManage]SETCURSOR_DEFAULTGLOBALGOALTERDATABASE[db_DrinkeryManage]SETCONCAT_NULL_YIELDS_NULLOFFGOALTERDATABASE[db_DrinkeryManage]SETNUMERIC_ROUNDABORTOFFGOALTERDATABASE[db_DrinkeryManage]SETQUOTED_IDENTIFIEROFFGOALTERD

6、ATABASE[db_DrinkeryManage]SETRECURSIVE_TRIGGERSOFFGOALTERDATABASE[db_DrinkeryManage]SETDISABLE_BROKERGOALTERDATABASE[db_DrinkeryManage]SETAUTO_UPDATE_STATISTICS_ASYNCOFFGOALTERDATABASE[db_DrinkeryManage]SETDATE_CORRELATION_OPTIMIZATIONOFFGOALTERDATABA

7、SE[db_DrinkeryManage]SETTRUSTWORTHYOFFGOALTERDATABASE[db_DrinkeryManage]SETALLOW_SNAPSHOT_ISOLATIONOFFGOALTERDATABASE[db_DrinkeryManage]SETPARAMETERIZATIONSIMPLEGOALTERDATABASE[db_DrinkeryManage]SETREAD_WRITEGOALTERDATABASE[db_DrinkeryManage]SETRECOVE

8、RYSIMPLEGOALTERDATABASE[db_DrinkeryManage]SETMULTI_USERGOALTERDATABASE[db_DrinkeryManage]SETPAGE_VERIFYTORN_PAGE_DETECTIONGOALTERDATABASE[db_DrinkeryManage]SETDB_CHAININGOFF