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