数据库作业酒店管理Word下载.doc
《数据库作业酒店管理Word下载.doc》由会员分享,可在线阅读,更多相关《数据库作业酒店管理Word下载.doc(4页珍藏版)》请在冰豆网上搜索。
报表功能是酒店管理系统必不可少的部分,由于系统是记账软件,报表功能是必不可少的。
再者就是系统维护功能,用来保障软件的安全运行。
ER图
餐台
座位数
台号
菜系
名称
序号
菜品
单价
编号
消费单
操作员
金额
消费餐台
逻辑结构设计:
SQL语句:
GO
EXECdbo.sp_dbcmptlevel@dbname=N'
db_DrinkeryManage'
@new_cmptlevel=80
IF(1=FULLTEXTSERVICEPROPERTY('
IsFullTextInstalled'
))
begin
EXEC[db_DrinkeryManage].[dbo].[sp_fulltext_database]@action='
disable'
end
ALTERDATABASE[db_DrinkeryManage]SETANSI_NULL_DEFAULTOFF
ALTERDATABASE[db_DrinkeryManage]SETANSI_NULLSOFF
ALTERDATABASE[db_DrinkeryManage]SETANSI_PADDINGOFF
ALTERDATABASE[db_DrinkeryManage]SETANSI_WARNINGSOFF
ALTERDATABASE[db_DrinkeryManage]SETARITHABORTOFF
ALTERDATABASE[db_DrinkeryManage]SETAUTO_CLOSEON
ALTERDATABASE[db_DrinkeryManage]SETAUTO_CREATE_STATISTICSON
ALTERDATABASE[db_DrinkeryManage]SETAUTO_SHRINKON
ALTERDATABASE[db_DrinkeryManage]SETAUTO_UPDATE_STATISTICSON
ALTERDATABASE[db_DrinkeryManage]SETCURSOR_CLOSE_ON_COMMITOFF
ALTERDATABASE[db_DrinkeryManage]SETCURSOR_DEFAULTGLOBAL
ALTERDATABASE[db_DrinkeryManage]SETCONCAT_NULL_YIELDS_NULLOFF
ALTERDATABASE[db_DrinkeryManage]SETNUMERIC_ROUNDABORTOFF
ALTERDATABASE[db_DrinkeryManage]SETQUOTED_IDENTIFIEROFF
ALTERDATABASE[db_DrinkeryManage]SETRECURSIVE_TRIGGERSOFF
ALTERDATABASE[db_DrinkeryManage]SETDISABLE_BROKER
ALTERDATABASE[db_DrinkeryManage]SETAUTO_UPDATE_STATISTICS_ASYNCOFF
ALTERDATABASE[db_DrinkeryManage]SETDATE_CORRELATION_OPTIMIZATIONOFF
ALTERDATABASE[db_DrinkeryManage]SETTRUSTWORTHYOFF
ALTERDATABASE[db_DrinkeryManage]SETALLOW_SNAPSHOT_ISOLATIONOFF
ALTERDATABASE[db_DrinkeryManage]SETPARAMETERIZATIONSIMPLE
ALTERDATABASE[db_DrinkeryManage]SETREAD_WRITE
ALTERDATABASE[db_DrinkeryManage]SETRECOVERYSIMPLE
ALTERDATABASE[db_DrinkeryManage]SETMULTI_USER
ALTERDATABASE[db_DrinkeryManage]SETPAGE_VERIFYTORN_PAGE_DETECTION
ALTERDATABASE[db_DrinkeryManage]SETDB_CHAININGOFF