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

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