数据库作业(酒店管理).doc

酒店管理系统需求分析：随着餐饮业的发展，人工的管理方式已不能满足管理者的要求，于是引入计算机应用管理系统。点菜功能菜单，是最常用的功能。例如在确定添加菜品是，既可以通过菜品编号确定，又可以通过菜品名称确定。自动结账功能是系统的主要功能之一，只需用户选中结账的台号，系统就会自动选中的台号计算消费金额。 报表功能是酒店管理系统必不可少的部分，由于系统是记账软件，报表功能是必不可少的。再者就是系统维护功能，用来保障软件的安全运行。ER图餐台座位数台号菜系名称序号菜品单价菜系名称编号消费单操作员金额消费餐台编号逻辑结构设计：SQL语句：GOEXEC dbo.sp_dbcmptlevel dbname=Ndb_DrinkeryManage, new_cmptlevel=80GOIF (1 = FULLTEXTSERVICEPROPERTY(IsFullTextInstalled)beginEXEC db_DrinkeryManage.dbo.sp_fulltext_database action = disableendGOALTER DATABASE db_DrinkeryManage SET ANSI_NULL_DEFAULT OFF GOALTER DATABASE db_DrinkeryManage 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_STATISTICS 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_NULL_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_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_Drin