建立仓库表 Create table warehouse( wno varchar2(10) primary key wname varc guard varchar2(20) square number(10, 2 cou int 建立零件表 Create table material( ino varchar2(10) primary key mname varchar2(20) type varchar2 (10) unit varchar2(10) cusum varchar2 (10) price number (10, 2)) 建立库存表 Create table storage( wno varchar2(10) references warehouse(wno) nno varchar2(10) references material(mno) store number(10, 2) primary key(wno, mno)) 2. insert into employee values(“k10001’,’计划科’,‘张明’,2003-11-14) insert into warehouse values(‘w001’,‘仓库1’,’刘成’,1000,100); nsert into material values(‘030001'’,‘螺母’,‘中号’,‘只’,‘c1001’,5); insert into storage values(‘w001’,“030001’,2000) select eno,dno, edate from employee where ename=’张明亮’ select mno,type, unit from material where mname=’螺丝II 用关系代数表示 丌cmo. dno.edate( Bename=张明亮( employee 丌mpmn(mnam=螺丝n( material) 用元组演算表示 GETW( employee.eno, employee.dno, employee. edate): employee. ename=’张明亮 GET W(material mno, material type, material unit): material mname=,t s II 4.1)找出“张明亮”所管理仓库的总面积与总货位数 Select sum(size), sum(num) from warehouse, store, emp where warehouse wno=store wno and emp emo=store emo 张明 ename5 四、 1. 建立仓库表 Create table warehouse( wno varchar2(10) primary key, wname varchar2(20), guard varchar2(20), square number(10,2), cou int); 建立零件表 Create table material( mno varchar2(10) primary key, mname varchar2(20), type varchar2(10), unit varchar2(10), cusnum varchar2(10), price number(10,2)); 建立库存表 Create table storage( wno varchar2(10) references warehouse(wno), mno varchar2(10) references material(mno), store number(10,2), primary key(wno,mno)); 2. insert into employee values(‘k10001' ,’计划科’,‘张明',2003-11-14); insert into warehouse values(‘w001',‘仓库 1',’刘成’,1000,100); insert into material values(‘030001',‘螺母',‘中号’，‘只’，‘c1001’，5); insert into storage values(‘w001',‘030001',2000); 3. 用 SQL 表示 select eno, dno, edate from employee where ename=’张明亮’; select mno, type, unit from material where mname=’螺丝 II’; 用关系代数表示 ( ( )) , , ' ' employee  eno dno edate  ename= 张明亮 ( ( )) , , ' ' material mno type unit mname= 螺丝II   用元组演算表示 GET W (employee.eno,employee.dno,employee.edate):employee.ename=’张明亮’; GET W (material.mno,material.type,material.unit):material.mname=’螺丝 II’; 4. 1）找出“张明亮”所管理仓库的总面积与总货位数。 Select sum(size), sum(num) from warehouse, store, emp where warehouse.wno=store.wno and emp.emo=store.emo and ename=‘张明’ group by ename