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

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

2、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 SET ANSI_NUL

3、LS 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_STATISTICS ON GOALTER

4、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_NULL_YIELDS_NULL

5、 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_UPDATE_STATI

6、STICS_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_Dri