數(shù)據(jù)庫原理實(shí)驗(yàn)報(bào)告-全文預(yù)覽
【正文】 說至關(guān)重要，否則后續(xù)的設(shè)計(jì)和實(shí)施都會(huì)有想象不到的麻煩。delete from Toys where cBrandId in (select cBrandIdfrom ToyBrandwhere cBrandName=39。select into PremiumToys from Toys,Wrapper,OrderDetail where 20 and = and =。（要求用子查詢實(shí)現(xiàn)）select vToyNamefrom toyswhere cToyId IN (select cToyId from OrderDetail where cWrapperId is null)（14）顯示已收貨定單的定單號(hào)碼以及下定單的時(shí)間。.39。select cOrderNo,mToyCostFrom Where mToyCost50。select top 5 cToyId,SUM(iTotalSold) as total from PickOfMonth where iYear=39。年份39。玩具ID39。select *From Where vToyName LIKE 39。select cOrderNo,cShopperId,mTotalCostfrom ORDER BY mTotalCost ASC。,39。（5）對(duì)表Toys實(shí)施下面數(shù)據(jù)完整性規(guī)則：（1）玩具的現(xiàn)有數(shù)量應(yīng)在0到200之間；（2）玩具適宜的最低年齡缺
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1