數(shù)據(jù)庫作業(yè)(酒店管理)(共4頁)

1、精選優(yōu)質(zhì)文檔-傾情為你奉上酒店管理系統(tǒng)需求分析：隨著餐飲業(yè)的發(fā)展，人工的管理方式已不能滿足管理者的要求，于是引入計算機應(yīng)用管理系統(tǒng)。點菜功能菜單，是最常用的功能。例如在確定添加菜品是，既可以通過菜品編號確定，又可以通過菜品名稱確定。自動結(jié)賬功能是系統(tǒng)的主要功能之一，只需用戶選中結(jié)賬的臺號，系統(tǒng)就會自動選中的臺號計算消費金額。 報表功能是酒店管理系統(tǒng)必不可少的部分，由于系統(tǒng)是記賬軟件，報表功能是必不可少的。再者就是系統(tǒng)維護功能，用來保障軟件的安全運行。ER圖餐臺座位數(shù)臺號菜系名稱序號菜品單價菜系名稱編號消費單操作員金額消費餐臺編號邏輯結(jié)構(gòu)設(shè)計：SQL語句：GOEXEC dbo.sp_dbcmpt

2、level dbname=N'db_DrinkeryManage', new_cmptlevel=80GOIF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')beginEXEC db_DrinkeryManage.dbo.sp_fulltext_database action = 'disable'endGOALTER DATABASE db_DrinkeryManage SET ANSI_NULL_DEFAULT OFF GOALTER DATABASE db_DrinkeryManage

3、 SET ANSI_NULLS OFF GOALTER DATABASE db_DrinkeryManage SET ANSI_PADDING OFF GOALTER DATABASE db_DrinkeryManage SET ANSI_WARNINGS OFF GOALTER DATABASE db_DrinkeryManage SET ARITHABORT OFF GOALTER DATABASE db_DrinkeryManage SET AUTO_CLOSE ON GOALTER DATABASE db_DrinkeryManage SET AUTO_CREATE_STATISTIC

4、S ON GOALTER DATABASE db_DrinkeryManage SET AUTO_SHRINK ON GOALTER DATABASE db_DrinkeryManage SET AUTO_UPDATE_STATISTICS ON GOALTER DATABASE db_DrinkeryManage SET CURSOR_CLOSE_ON_COMMIT OFF GOALTER DATABASE db_DrinkeryManage SET CURSOR_DEFAULT GLOBAL GOALTER DATABASE db_DrinkeryManage SET CONCAT_NUL

5、L_YIELDS_NULL OFF GOALTER DATABASE db_DrinkeryManage SET NUMERIC_ROUNDABORT OFF GOALTER DATABASE db_DrinkeryManage SET QUOTED_IDENTIFIER OFF GOALTER DATABASE db_DrinkeryManage SET RECURSIVE_TRIGGERS OFF GOALTER DATABASE db_DrinkeryManage SET DISABLE_BROKER GOALTER DATABASE db_DrinkeryManage SET AUTO

6、_UPDATE_STATISTICS_ASYNC OFF GOALTER DATABASE db_DrinkeryManage SET DATE_CORRELATION_OPTIMIZATION OFF GOALTER DATABASE db_DrinkeryManage SET TRUSTWORTHY OFF GOALTER DATABASE db_DrinkeryManage SET ALLOW_SNAPSHOT_ISOLATION OFF GOALTER DATABASE db_DrinkeryManage SET PARAMETERIZATION SIMPLE GOALTER DATABASE db_DrinkeryManage SET READ_WRITE GOALTER DATABASE db_DrinkeryManage SET RECOVERY SIMPLE GOALTER DATABASE db_DrinkeryManage SET MULTI_USER GOALTER DATABASE db_DrinkeryMa