数据库作业分析和总结.docx

酒店管理系统需求分析：随着餐饮业的发展，人工的管理方式已不能满足管理者的要求，于是引入计算机应用管理系统。点菜功能菜单，是最常用的功能。例如在确定添加菜品是，既可以通过菜品编号确定， 又可以通过菜品名称确定。自动结账功能是系统的主要功能之一，只需用户选中结账的台号，系统就会自动选中的台 号计算消费金额。报表功能是酒店管理系统必不可少的部分，由于系统是记账软件，报表功能是必不可少 的。再者就是系统维护功能，用来保障软件的安全运行。ER图逻辑结构设计:SQL语句：GOEXEC dbo.sp_dbcmptlevel dbname=N'db_DrinkeryManage', new_cmptlevel=80 GOIF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled,)beginEXEC db_DrinkeryManage. dbo. sp_fulltext_database action = 'disable' endGOALTER DATABASE db.DrinkeryManage SET ANSI_NULL_DEFAULT OFFGOALTER DATABASE db_DrinkeryManage SETANSI_NULLS OFFGOALTER DATABASE db.DrinkeryManage SET ANSI.PADDING OFFGOALTER DATABASE db_DrinkeryManage SETANSI_WARNINGS OFFGOALTER DATABASE db.DrinkeryManage SETARITHABORT OFFGOALTER DATABASE db_DrinkeryManage SETAUTO_CLOSE ONGOALTER DATABASE db_DrinkeryManage SET AUTO_CREATE_STATISTICS ONGOALTER DATABASE db.DrinkeryManage SET AUTO.SHRINK ONGOALTER DATABASE db.DrinkeryManage SET AUTO_UPDATE_STATISTICS ONGOALTER DATABASE db_DrinkeryManage SETCURSOR_CLOSE_ON_COMMITOFFGOALTER DATABASE db.DrinkeryManage SET CURSOR_DEFAULT GLOBALGOALTER DATABASE db_DrinkeryManage SET CONCAT_NULL_YIELDS_NULL OFFGOALTER DATABASE db_DrinkeryManage SET NUMERIC_ROUNDABORT OFFGOALTER DATABASE db_DrinkeryManage SET QUOTEDJDENTIFIER OFFGOALTER DATABASE db_DrinkeryManage SET RECURSIVE_TRIGGERS OFFGOALTER DATABASE db_DrinkeryManage SET DISABLE_BROKERGOALTER DATABASE db_DrinkeryManage SET AUTO_UPDATE_STATISTICS_ASYNC OFF GOALTER DATABASE db_DrinkeryManage SET DATE_CORRELATION_OPTIMIZATIONOFFGOALTER DATABASE db_DrinkeryManage SETTRUSTWORTHYOFFGOALTER DATABASE db_DrinkeryManage SET ALLO W_SNAPSHOT_ISOLATION OFFGOALTER DATABASE db_DrinkeryManage SET PARAMETERIZATION SIMPLEGOALTER DATABASE db_DrinkeryManage SET READ_WRITEGOALTER DATABASE db_DrinkeryManage SET RECOVERYSIMPLEGOALTER DATABASE db_DrinkeryManage SET MULTI_USERGOALTER DATABASE db.DrinkeryManage SET PAGE_VERIFYTORN_PAGE_DETECTION GOALTER DATABASE db.DrinkeryManage SET DB_CHAINING OFF