數(shù)據(jù)庫原理及應(yīng)用——崔巍書后上機實驗-全文預覽
【正文】 產(chǎn)品號 in(select 產(chǎn)品號from 產(chǎn)品where 產(chǎn)品名稱=39。11)、基于單個表按投影操作定義視圖create view v_cus asselect 客戶號,客戶名稱from 客戶使用select * from v_cus2)、基于單個表按選擇操作定義視圖create view v_order asselect *from 訂購單where 客戶號=39。25select *from 產(chǎn)品 outawhere 單價=(select MAX(單價)from 產(chǎn)品 innerawhere =)26select 客戶號from 客戶where not exists(select *from 訂購單where =)27select *from 客戶where exists(select *from 訂購單where =)28select 產(chǎn)品名稱from 產(chǎn)品where 單價= any(select 單價/219select COUNT(distinct 訂單號)as 訂購單個數(shù),AVG(數(shù)量*單價)as 平均金額from 產(chǎn)品,訂單名細where =20select 訂單號,COUNT(訂單號) 項目數(shù),SUM(*) 總金額from 產(chǎn)品 g,訂單名細 owhere =group by 訂單號21select ,MAX(數(shù)量*單價) 最高金額,MIN(數(shù)量*單價) 最低金額from 訂購單 o,產(chǎn)品 g,訂單名細 iwhere =and =and 產(chǎn)品名稱=39。14select * from 產(chǎn)品 order by 單價15select *from 產(chǎn)品order by 產(chǎn)品名稱,單價16select COUNT(產(chǎn)品號)from 產(chǎn)品17select SUM(數(shù)量)from 訂單名細where 產(chǎn)品號=(select 產(chǎn)品號from 產(chǎn)品where 產(chǎn)品名稱=39。)11select * from 產(chǎn)品 where 單價 between 1000 and 500012select * from 客戶 where 客戶名稱 like 39。and =and =and =8select * from 訂單名細where 產(chǎn)品號 in(select 產(chǎn)品號from 產(chǎn)品where 產(chǎn)品名稱=39。201112139。ipad39。Macbook39。第二個更新根據(jù)參照完整性約束，訂購單表參照客戶表，而客戶表中沒有客戶號為“C011”的客戶。C00239。訂購單whereC00239。訂購單where受用戶定義完整性約束4update數(shù)量=0 whereset訂單號=39?？蛻籼?39。where受參照完整性約束3update訂單號=39?？蛻?39。values(39。639。339。訂單名細 ,39。,39。intoGD00139。or0139。insert訂購單(訂單號),39。intoC00139。insertGD01039。)insert,39。values(39。500039。iphone39。產(chǎn)品J商場39。客戶(客戶號,客戶名稱),39。,39。,39。into12345639。小明39。C00139。部分記錄insert訂單名細(訂單號,序號,數(shù)量 訂購單(訂單號) index 創(chuàng)建表時，primary keygdn_nui 客戶(客戶名稱)2create數(shù)量1000)建立索引1create add constraint null3alter (規(guī)格說明)2alter 產(chǎn)品add columnconstraint check(數(shù)量0),primarykey(訂單號,序號))產(chǎn)品,數(shù)量 null 訂購單,
外語相關(guān)推薦
鄂ICP備17016276號-1