数据库作业(酒店管理)

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

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

2、额操作员逻辑结构设计：tb_order_itemtb_menu*tb_sort*idnumidorder_form_numsort_idnamemenu_numnameamountcodetotalunitunit_pricestatetb_order_formtb_useridnumnamedesk_numsexdatetimebirthdaymoneyid_carduser_idpasswordfreezetb_desknumSQL语句：GOEXECdbo.sp_dbcmptlevel@dbname

3、=N'db_DrinkeryManage',@new_cmptlevel=80GOIF(1=FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))--beginEXEC[db_DrinkeryManage].[dbo].[sp_fulltext_database]@action='disable'endGOALTERDATABASE[db_DrinkeryManage]SETANSI_NULL_DEFAULTOFFGOALTERDATABASE[db_Drinke

4、ryManage]SETANSI_NULLSOFFGOALTERDATABASE[db_DrinkeryManage]SETANSI_PADDINGOFFGOALTERDATABASE[db_DrinkeryManage]SETANSI_WARNINGSOFFGOALTERDATABASE[db_DrinkeryManage]SETARITHABORTOFFGOALTERDATABASE[db_DrinkeryManage]SETAUTO_CLOSEONGOALTERDATABASE[db_Drinke

5、ryManage]SETAUTO_CREATE_STATISTICSONGOALTERDATABASE[db_DrinkeryManage]SETAUTO_SHRINKONGOALTERDATABASE[db_DrinkeryManage]SETAUTO_UPDATE_STATISTICSONGOALTERDATABASE[db_DrinkeryManage]SETCURSOR_CLOSE_ON_COMMITOFFGOALTERDATABASE[db_DrinkeryManage]SETCURSOR_D

6、EFAULTGLOBALGOALTERDATABASE[db_DrinkeryManage]SETCONCAT_NULL_YIELDS_NULLOFFGOALTERDATABASE[db_DrinkeryManage]SETNUMERIC_ROUNDABORTOFFGOALTERDATABASE[db_DrinkeryManage]SETQUOTED_IDENTIFIEROFFGOALTERDATABASE[db_DrinkeryManage]SETRECURSIVE_TRIGGERSOFFGOALTE

7、RDATABASE[db_DrinkeryManage]SETDISABLE_BROKERGOALTERDATABASE[db_DrinkeryManage]SETAUTO_UPDATE_STATISTICS_ASYNCOFFGOALTERDATABASE[db_DrinkeryManage]SETDATE_CORRELATION_OPTIMIZATIONOFFGOALTERDATABASE[db_DrinkeryManage]SETTRUSTWORTHYOFFGOALTERDATABASE[db_Dr

8、inkeryManage]SETALLOW_SNAPSHOT_ISOLATIONOFF--GOALTERDATABASE[db_DrinkeryManage]SETPARAMETERIZATIONSIMPLEGOALTERDATABASE[db_DrinkeryManage]SETREAD_WRITEGOALTERDATABASE[db_DrinkeryManage]SETRECOVERYSIMPLEGOALTERDATABASE[db_D