小型餐飲管理系統(tǒng)數(shù)據(jù)庫設計報告需要的下載積分更低樣本

設計任務與規(guī)定目及意義：此小型餐飲業(yè)管理系統(tǒng)設計重要是為了以便管理，對于各個進出賬目，支出和收入管理便于系統(tǒng)化，在每月匯總計算中分析運營趨勢和餐館發(fā)展方向進行一定規(guī)劃。通過各個月賺錢進行對比，分析那種方式更適合餐館有利運營和更好地服務顧客。實現(xiàn)對餐館內(nèi)部各種管理電子化、自動化，提高各個模塊之間辦公效率，為高質(zhì)量餐館服務提供保證。任務：1.可以實現(xiàn)對該系統(tǒng)進行管理人員權(quán)限限制；2.使餐館可以及時并靈活對菜品品種其價位等進行管理；3.為餐館提供從客戶點餐到結(jié)算等一系列操作服務，使之能簡樸易行、以便、清晰地進行管理系統(tǒng)功能分析一．功能需求：餐飲管理系統(tǒng)中重要涉及對如下幾種管理：賬單管理，財務管理，訂餐管理，菜品管理，系統(tǒng)管理。（1）系統(tǒng)管理：系統(tǒng)管理涉及顧客名和密碼，重要用于顧客登陸界面登陸和查詢。（2）賬單管理：賬單管理涉及賬單號和餐臺，每一種餐臺相應一種一種賬單號，通過餐臺號記錄來對相應餐臺進行記賬管理，即就是記錄每一種餐臺消費金額。賬單管理是財務管理一種小分支，是服務于財務管理。（3）財務管理：涉及賬單號，時間和賬目。賬目用于記錄賬單號消費金額及時間，以便用于結(jié)算和匯總。每日結(jié)算要通過對每個餐臺號消費金額匯總來記錄，然后由每日結(jié)算匯總得出每月結(jié)算。帳務系統(tǒng)功能完整性。一旦該系統(tǒng)正式運營，餐廳每日營業(yè)帳和所有往來客戶帳務操作結(jié)算都將依托計算機，該系統(tǒng)面對當前餐飲業(yè)各種復雜結(jié)算規(guī)定應具備很強應變能力。（4）訂餐管理：訂餐管理僅涉及單價。訂餐管理是便于顧客訂餐和賬單管理時對各個菜品消費金額記錄，這樣便于賬單管理和財務匯總。（5）菜品管理：菜品管理涉及菜名，菜品類別和菜品品種。菜品管理便于顧客點菜和記錄各個餐臺消費記賬，菜品品種也便于餐館食材采購。二.數(shù)據(jù)需求：賬單管理中賬單號是主鍵，每一種餐臺相應一種賬單號。財務管理中賬單號是主鍵，每一種賬單號均有相應時間和賬目記錄。訂餐管理中單價就是主鍵。菜品管理中菜名是主鍵。系統(tǒng)管理中顧客名是主鍵。三.性能需求：該餐飲系統(tǒng)操作簡樸以便可適應各類中小型餐館。系統(tǒng)功能模塊設計一.在該系統(tǒng)功能分析基本上，考慮PowerBuilder程序編制特點，得到如下功能模塊圖。小型餐飲業(yè)管理系統(tǒng)小型餐飲業(yè)管理系統(tǒng)系統(tǒng)管理賬單管理訂餐管理財務管理菜品管理顧客管理密碼管理賬單號管理餐臺管理訂單查詢餐臺點餐管理每日賬目管理賬目時間管理菜名管理菜品管理菜價管理類別管理圖1系統(tǒng)功能模塊圖二.數(shù)據(jù)庫設計1.概念構(gòu)造設計2.邏輯構(gòu)造設計3.數(shù)據(jù)庫實行1)數(shù)據(jù)庫及表構(gòu)造創(chuàng)立設本系統(tǒng)使用數(shù)據(jù)庫名為小型餐飲業(yè)管理系統(tǒng),依照已設計關(guān)系模式及各模式完整性規(guī)定，當前就可以在SQLServer6.x數(shù)據(jù)庫系統(tǒng)中實現(xiàn)這些邏輯構(gòu)造。下面是創(chuàng)立基本表SQL語句：/*============================================================*//*Table：CAIPINGL*//*============================================================*/createtableCAIPINGL(CPGL_NAMEchar(20)notnull,CPGL_DANJIAintegernotnull,CPGL_LEIBIEchar(8)null,CPGL_PINGZHONGchar(8)null,CPGL_DIANCAIintegernull,constraintPK_CAIPINGLprimarykey(CPGL_NAME，CPGL_DANJIA))go/*============================================================*//*Table：XTGL*//*============================================================*/createtableXTGL(USERNAMEchar(20)notnull,PASSWORDchar(8)notnull,constraintPK_XTGLprimarykey(USERNAME，PASSWORD))go/*============================================================*//*Table：ZHANGDAGL*//*============================================================*/createtableZHANGDAGL(ZHANGDAN_NUMBERnumericnotnull,ZHANGDAN_CANTAInumericnull,CAI_ZHANGDAN_NUMBERnumericnull,constraintPK_ZHANGDAGLprimarykey(ZHANGDAN_NUMBER))go/*============================================================*//*Index：RELATION_383_FK*//*============================================================*/createindexRELATION_383_FKonZHANGDAGL(CAI_ZHANGDAN_NUMBER)go/*============================================================*//*Table：CAIWUGL*//*============================================================*/createtableCAIWUGL(ZHANGDAN_NUMBERnumericnotnull,CAIWU_TIMEtimestampnull,CAIWU_AMOUNTchar(10)null,constraintPK_CAIWUGLprimarykey(ZHANGDAN_NUMBER))go/*============================================================*//*Table：DINGCANGL*//*============================================================*/createtableDINGCANGL(ZHANGDAN_NUMBERnumericnotnull,DCGL_NAMEchar(20)notnull,DCGL_DANJIAintnotnull,constraintPK_DINGCANGLprimarykey(ZHANGDAN_NUMBER，DCGL_NAME，DCGL_DANJIA))go/*============================================================*//*Index：RELATION_451_FK*//*============================================================*/createindexRELATION_451_FKonDINGCANGL(ZHANGDAN_NUMBER)go建立有關(guān)觸發(fā)器，執(zhí)行級聯(lián)刪除*============================================================*//*Databasename：MODEL_1*//*DBMSname：MicrosoftSQLServer6.x*//*Createdon：-1-2118:15*//*============================================================*//*Inserttrigger"ti_caiwugl"fortable"CAIWUGL"*/createtriggerti_caiwuglonCAIWUGLforinsertasbegindeclare@numrowsint,@numnullint,@errnoint,@errmsgvarchar(255)select@numrows=@@rowcountif@numrows=0return/*Parent"ZHANGDAGL"mustexistwheninsertingachildin"CAIWUGL"*/ifupdate(ZHANGDAN_NUMBER)beginif(selectcount(*)fromZHANGDAGLt1，insertedt2wheret1.ZHANGDAN_NUMBER=t2.ZHANGDAN_NUMBER)!=@numrowsbeginselect@errno=30002,@errmsg='Parentdoesnotexistin"ZHANGDAGL".Cannotcreatechildin"CAIWUGL".'gotoerrorendendreturn/*Errorshandling*/error:raiserror@errno@errmsgrollbacktransactionendgo/*Updatetrigger"tu_caiwugl"fortable"CAIWUGL"*/createtriggertu_caiwuglonCAIWUGLforupdateasbegindeclare@numrowsint,@numnullint,@errnoint,@errmsgvarchar(255)select@numrows=@@rowcountif@numrows=0return/*Parent"ZHANGDAGL"mustexistwhenupdatingachildin"CAIWUGL"*/ifupdate(ZHANGDAN_NUMBER)beginif(selectcount(*)fromZHANGDAGLt1，insertedt2wheret1.ZHANGDAN_NUMBER=t2.ZHANGDAN_NUMBER)!=@numrowsbeginselect@errno=30003,@errmsg='"ZHANGDAGL"doesnotexist.Cannotmodifychildin"CAIWUGL".'gotoerrorendend/*Modifyparentcodeof"CAIWUGL"forallchildrenin"ZHANGDAGL"*/ifupdate(ZHANGDAN_NUMBER)beginupdateZHANGDAGLsetCAI_ZHANGDAN_NUMBER=i1.ZHANGDAN_NUMBERfromZHANGDAGLt2，insertedi1，deletedd1wheret2.CAI_ZHANGDAN_NUMBER=d1.ZHANGDAN_NUMBERand(i1.ZHANGDAN_NUMBER!=d1.ZHANGDAN_NUMBER)endreturn/*Errorshandling*/error:raiserror@errno@errmsgrollbacktransactionendgo/*Deletetrigger"td_caiwugl"fortable"CAIWUGL"*/createtriggertd_caiwuglonCAIWUGLfordeleteasbegindeclare@numrowsint,@errnoint,@errmsgvarchar(255)select@numrows=@@rowcountif@numrows=0return/*Deleteallchildrenin"ZHANGDAGL"*/deleteZHANGDAGLfromZHANGDAGLt2，deletedt1wheret2.CAI_ZHANGDAN_NUMBER=t1.ZHANGDAN_NUMBERreturn/*Errorshandling*/error:raiserror@errno@errmsgrollbacktransactionendgo/*Inserttrigger"ti_dingcangl"fortable"DINGCANGL"*/createtriggerti_dingcanglonDINGCANGLforinsertasbegindeclare@numrowsint,@numnullint,@errnoint,@errmsgvarchar(255)select@numrows=@@rowcountif@numrows=0return/*Parent"ZHANGDAGL"mustexistwheninsertingachildin"DINGCANGL"*/ifupdate(ZHANGDAN_NUMBER)beginif(selectcount(*)fromZHANGDAGLt1，insertedt2wheret1.ZHANGDAN_NUMBER=t2.ZHANGDAN_NUMBER)!=@numrowsbeginselect@errno=30002,@errmsg='Parentdoesnotexistin"ZHANGDAGL".Cannotcreatechildin"DINGCANGL".'gotoerrorendendreturn/*Errorshandling*/error:raiserror@errno@errmsgrollbacktransactionendgo/*Updatetrigger"tu_dingcangl"fortable"DINGCANGL"*/createtriggertu_dingcanglonDINGCANGLforupdateasbegindeclare@numrowsint,@numnullint,@errnoint,@errmsgvarchar(255)select@numrows=@@rowcountif@numrows=0return/*Parent"ZHANGDAGL"mustexistwhenupdatingachildin"DINGCANGL"*/ifupdate(ZHANGDAN_NUMBER)beginif(selectcount(*)fromZHANGDAGLt1，insertedt2wheret1.ZHANGDAN_NUMBER=t2.ZHANGDAN_NUMBER)!=@numrowsbeginselect@errno=30003,@errmsg='"ZHANGDAGL"doesnotexist.Cannotmodifychildin"DINGCANGL".'gotoerrorendendreturn/*Errorshandling*/error:raiserror@errno@errmsgrollbacktransactionendgo/*Inserttrigger"ti_zhangdagl"fortable"ZHANGDAGL"*/createtriggerti_zhangdaglonZHANGDAGLforinsertasbegindeclare@numrowsint,@numnullint,@errnoint,@errmsgvarchar(255)select@numrows=@@rowcountif@numrows=0return/*Parent"CAIWUGL"mustexistwheninsertingachildin"ZHANGDAGL"*/ifupdate(CAI_ZHANGDAN_NUMBER)beginselect@numnull=(selectcount(*)frominsertedwhereCAI_ZHANGDAN_NUMBERisnull)if@numnull!=@numrowsif(selectcount(*)fromCAIWUGLt1，insertedt2wheret1.ZHANGDAN_NUMBER=t2.CAI_ZHANGDAN_NUMBER)!=@numrows-@numnullbeginselect@errno=30002,@errmsg='Parentdoesnotexistin"CAIWUGL".Cannotcreatechildin"ZHANGDAGL".'gotoerrorendendreturn/*Errorshandling*/error:raiserror@errno@errmsgrollbacktransactionendgo/*Updatetrigger"tu_zhangdagl"fortable"ZHANGDAGL"*/createtriggertu_zhangdaglonZHANGDAGLforupdateasbegindeclare@numrowsint,@numnullint,@errnoint,@errmsgvarchar(255)select@numrows=@@rowcountif@numrows=0return/*Parent"CAIWUGL"mustexistwhenupdatingachildin"ZHANGDAGL"*/ifupdate(CAI_ZHANGDAN_NUMBER)beginselect@numnull=(selectcount(*)frominsertedwhereCAI_ZHANGDAN_NUMBERisnull)if@numnull!=@numrowsif(selectcount(*)fromCAIWUGLt1，insertedt2wheret1.ZHANGDAN_NUMBER=t2.CAI_ZHANGDAN_NUMBER)!=@numrows-@numnullbeginselect@errno=30003,@errmsg='"CAIWUGL"doesnotexist.Cannotmodifychildin"ZHANGDAGL".'gotoerrorendend/*Modifyparentcodeof"ZHANGDAGL"forallchildrenin"CAIWUGL"*/ifupdate(ZHANGDAN_NUMBER)beginupdateCAIWUGLsetZHANGDAN_NUMBER=i1.ZHANGDAN_NUMBERfromCAIWUGLt2，insertedi1，deletedd1wheret2.ZHANGDAN_NUMBER=d1.ZHANGDAN_NUMBERand(i1.ZHANGDAN_NUMBER!=d1.ZHANGDAN_NUMBER)end/*Modifyparentcodeof"ZHANGDAGL"forallchildrenin"DINGCANGL"*/ifupdate(ZHANGDAN_NUMBER)beginupdateDINGCANGLsetZHANGDAN_NUMBER=i1.ZHANGDAN_NUMBERfromDINGCANGLt2，insertedi1，deletedd1wheret2.ZHANGDAN_NUMBER=d1.ZHANGDAN_NUMBERand(i1.ZHANGDAN_NUMBER!=d1.ZHANGDAN_NUMBER)endreturn/*Errorshandling*/error:raiserror@errno@errmsgrollbacktransactionendgo/*Deletetrigger"td_zhangdagl