《数据库作业分析和总结.docx》由会员分享,可在线阅读,更多相关《数据库作业分析和总结.docx(3页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、酒店管理系统需求分析:随着餐饮业的发展,人工的管理方式已不能满足管理者的要求,于是引入计算机应用管理系统。点菜功能菜单,是最常用的功能。例如在确定添加菜品是,既可以通过菜品编号确定, 又可以通过菜品名称确定。自动结账功能是系统的主要功能之一,只需用户选中结账的台号,系统就会自动选中的台 号计算消费金额。报表功能是酒店管理系统必不可少的部分,由于系统是记账软件,报表功能是必不可少 的。再者就是系统维护功能,用来保障软件的安全运行。ER图逻辑结构设计:SQL语句:GOEXEC dbo.sp_dbcmptlevel dbname=Ndb_DrinkeryManage, new_cmptlevel=8
2、0 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 OFFG
3、OALTER 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.Drinke
4、ryManage 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 DATA
5、BASE 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_OPTIMIZATIO
6、NOFFGOALTER 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