【正文】 致謝 感謝四位老師這兩周來對我們的悉心指導(dǎo)，在我設(shè)計過程中，我的老師傾注了大量的汗水和心血，無論是在構(gòu)思和資料收集方面，還是在報告的研究方法一級成文定稿方面，我都得到了老師的悉心細(xì)致的教誨和無私的幫助，在此我表示真誠的感謝和深深地謝意，在系統(tǒng)的維護(hù)過程中，也得到了許多同學(xué)的寶貴意見，感謝許多幫助過我的良師益友。李四39。(1) 應(yīng)對不易理解的分支條件表達(dá)式加注釋；注釋一律使用（）類型 (2) 對重要的計算應(yīng)說明其功能；(3) 過長的函數(shù)實現(xiàn)，應(yīng)將其語句按實現(xiàn)的功能分段加以概括性說明； (4) 常量及變量注釋時，應(yīng)注釋被保存值的含義(必須)，合法取值的范圍。課程設(shè)計才是能把學(xué)到的東西真正融會貫通的捷徑，而設(shè)計報告更是讓我們提早的熟悉了畢業(yè)論文的格式。在需求設(shè)計階段，把系統(tǒng)的功能勾畫出來，分析系統(tǒng)的數(shù)據(jù)字典、數(shù)據(jù)流向，畫出ER圖，根據(jù)ER圖數(shù)據(jù)庫設(shè)計關(guān)系模型，這樣一步步下來，自己對餐廳管理系統(tǒng)有更多的了解，對后面的程序編寫也明朗了。order by CD_price GO 多表查詢內(nèi)連接2 select YG_id as 工號,YG_Name as 姓名from YG_tablewhere YG_id in(select YG_id from CanZhuo_table where CZ_id in(select CZ_id from KeRen_table where KR_zhifu=39。 單表查詢 多表連接查詢/*=======多表查詢=========*/ （多表查詢內(nèi)連接） select DISTINCT(YG_Name) as 姓名,總價格 as 銷售額from YG_table inner join DingDan_table on = inner join View_ZhangDan on DD_id=賬單號where YG_Name=39。 select SB_id as 設(shè)備號,SB_name as 名稱 from SheBei_table where CZ_id=39。SELECT * FROM YG_table 執(zhí)行后 第五章 查詢 單表查詢 select * from YG_table where YG_Sex=39。GOSELECT *FROM YG_tableWHERE YG_Name=39。)GOSELECT *FROM YG_tableWHERE YG_Name=39。,39。,39。,39。,300,300),(39。,39。,39。,120,240),(39。,39。,39。,600,7000),(39。,39。,39。,300,9000),(39。,39。,39。,500,500),(39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,14,39。,8,39。,9,39。,10,39。,8,39。,11,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,15,39。),(39。,39。,48,39。),(39。,39。,20,39。),(39。,39。,8,39。),(39。,39。,5,39。),(39。,39。,10,39。),(39。,39。,39。,39。),(39。,15,39。,39。,39。,39。),(39。,8,39。,39。,39。,39。),(39。,8,39。,39。,39。,39。),(39。,8,39。,39。,39。,39。),(39。,12,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,20000,39。,29,39。),(39。,39。,39。,2500,39。,25,39。),(39。,39。,39。,3000,39。,29,39。),(39。,39。,39。,2000,39。,24,39。),(39。,39。,39。,2000,39。,24,39。),(39。,39。,39。)goALTER TABLE YG_tableADD CHECK (YG_phone like 39。) goALTER TABLE YG_tableADD CHECK (YG_Sex=39。)goALTER TABLE SheBei_tableADD CHECK (SB_id like 39。)goALTER TABLE KeRen_tableADD CHECK (KR_zhifu=39。 or DD_zhuangtai=39。)goALTER TABLE CanJu_tableADD CHECK (CJ_id like 39。GO 局部變量name為要查詢的員工姓名USE 餐飲管理GOCREATE PROCEDURE XiaoShouE name char(10) ASSELECT DISTINCT(YG_Name),總價格from YG_table inner join DingDan_table on = inner join View_ZhangDan on DD_id=賬單號where YG_Name=nameGO例：EXEC XiaoShouE 李四 銷售額存儲過程結(jié)果alter table DingDan_table add constraint FK_DINGDAN__DIANCAI_CANZHUO_ foreign key (CZ_id) references CanZhuo_table (CZ_id)goalter table DingDan_table add constraint FK_DINGDAN__FUZE_YG_TABLE foreign key (YG_id) references YG_table (YG_id)goalter table JinHuo_table add constraint FK_JINHUO_T_FUZE_YG_TABLE foreign key (YG_id) references YG_table (YG_id)goalter table KeRen_table add constraint FK_KEREN_TA_CHIFAN_CANZHUO_ foreign key (CZ_id) references CanZhuo_table (CZ_id)Goalter table SheBei_table add constraint FK_SHEBEI_T_WEIZHI_CANZHUO_ foreign key (CZ_id) references CanZhuo_table (CZ_id)Goalter table CanJ