电脑销售数据库设计
FOREIGN KEY (gID) REFERENCES goods(gID) )
4.3视图
建立商品类别为显示器的视图,并标出价格
CREATE VIEW xianshiqi
AS
SELECT gID,gPRICE FROM goods
where gID='xianshiqi'
建立营业员业绩小于1000的营业员信息 CREATE VIEW yeji AS
SELECT *
FROM assistant where aFEAT<=1000
建立采购单商品金额大于10000的采购单信息: CREATE VIEW caigoudan(cID,cMONEY) AS
SELECT bID,gUNIT*gPRICE FROM buy,goods
where goods.gID=buy.gID and gUNIT*gPRICE>=10000
4.4索引
为商品goods建立索引
Create unique index goods_name on goods(gNAME) 为采购buy按照商品名称升序,数量降序建立唯一索引 Create unique index storageQUA on storage(storageQUA desc) 为存储storage按库存量降序建立唯一索引 Create unique index buyQUA on buy(buyQUA desc)