【正文】 rry管理部Bart人事科★Eden管理部★Beau管理部★Carl會計科★Ed會計科★Cliff會計科★Dan業(yè)務部★Frank業(yè)務部★Hermes生管科★★★★★Des生管科★★★★★Gale生管科★★★★★Beck生管科★★Gary生管科★Danny生管科★★★★★Ford生管科★★★★★Cash品?？啤顴ddy 品?？啤顱arton 品?？啤颕an制造部★Hank制造部★Ira壓合科★Abner壓合科★Jack內(nèi)務科★Ade內(nèi)務科★4．創(chuàng)建表，序列Depart:create table depart(DeptNo number(2) constraint pk_depart primary key,DeptName varchar2(10),LOC varchar2(13))。/Emp：create table emp(EmpId varchar2(10) constraint pk_emp primary key,EmpName varchar2(10) NOT NULL,EmpAdd varchar2(20),EmpPhone varchar(12),Email varchar2(20),MGR varchar2(10),HireDate date,COMM number(7,2),DeptNo number(2) not null,Pro varchar2(12),Sal number(6),Educa varchar2(12),Exper varchar2(20),CONSTRAINT fk_emp_DeptNoFOREIGN KEY (DeptNo) REFERENCES depart(DeptNo))。Customer:create table customer(custid varchar2(10) constraint pk_customer primary key,custname varchar2(22),custadd varchar2(20),custphone varchar2(12),custfax varchar2(12))。Prostock:create table prostock(Proid varchar2(10) constraint pk_prostock primary key,ProName varchar(20),Val number(10),Stiqty number(10),Insqty number(10))。Ord:create table ord(ordid varchar2(10) constraint pk_ord primary key,proid varchar2(10) not null,custid varchar2(10) not null,o_qty number(20),orddate date,d_date date,money number(10),is_invoice number(1),is_delivery number(1),constraint fk_ord_proidforeign key(proid) REFERENCES prostock(proid),constraint fk_ord_custidforeign key(custid) REFERENCES customer(custid))。Wip:create table wip(wipid varchar2(10) constraint pk_wip primary key,proid varchar2(10) not null,w_qty number(20),is_finish number(1),constraint fk_wip_proidforeign key(proid) REFERENCES prostock(proid))。Delivery:create table delivery(delino varchar(10) constraint pk_delivery primary key,proid varchar(10) not null,ordid varchar(10) not null,carno varchar(10),is_invoice number(1),constraint fk_delivery_proidforeign key(proid) REFERENCES prostock(proid),constraint fk_delivery_ordidforeign key(ordid) REFERENCES ord(ordid))。Invoice:create table invoice(invid varchar2(10) constraint pk_invoice primary key,ordid varchar2(10),proid varchar2(10),allmoney number(10),in_date date,constraint fk_invoice_proidforeign key(proid) REFERENCES prostock(proid),constraint fk_invoice_ordidforeign key(ordid) REFERENCES ord(ordid))。實現(xiàn)表主鍵自動增長的對應表的序列Customer_seq:create sequence customer_seq start with 1increment by 1nomaxvaluenocyclenocache。delivery_seq:create sequence delivery_seq start with 1increment by 1nomaxvaluenocyclenocache。invoice；create sequence invoice_seq start with 1increment by 1nomaxvaluenocyclenocache。prostock_seq:create sequence prostock_seq start with 1increment by 1nomaxvaluenocyclenocache。wip_seq；create sequence wip_seq start with 1increment by 1nomaxvaluenocyclenocache。5．插入數(shù)據(jù)Depart:insert into Depart(DeptNo,DeptName,LOC) values (39。1139。,39?？偨?jīng)理室39。,39。北京39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。1239。,39。監(jiān)督室39。,39。北京39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。2139。,39。管理部39。,39。鄭州39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。3139。,39。會計科39。,39。北京39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。2239。,39。業(yè)務部39。,39。北京39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。3239。,39。生管科39。,39。鄭州39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。3339。,39。品?？?9。,39。鄭州39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。2339。,39。制造部39。,39。鄭州39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。3439。,39。壓合科39。,39。鄭州39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。3539。,39。內(nèi)務科39。,39。鄭州39。)。emp:Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values (39。0010139。,39。Abel39。,39。北京市海淀區(qū)39。,39。(010)11111139。,39。xxx@39。,null,to_date(39。06/05/9039。,39。dd/mm/yy39。),null,39。1139。,39。總經(jīng)理39。,39。18000039。,39。研究所39。,39。五年39。)。 Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。0010239。,39。Ivan39。,39。上海市四川路39。,39。(021)11111139。,39。xxx@39。,39。Abel39。,to_date(39。13/01/9239。,39。dd/mm/yy39。),39。20039。,39。1139。,39。特助39。,39。12000039。,39。研究所39。,39。二年39。)。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。0020139。,39。Alan39。,39。鄭州市人民路39。,39。(037)11111139。,39。xxx@39。,39。Abel39。,to_date(39。23/06/9139。,39。dd/mm/yy39。),null,39。1239。,39。經(jīng)理39。,39。12000039。,39。研究所39。,39。三年39。)。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。0020239。,39。Henry39。,39。鄭州市中山路39。,39。(037)11111239。,39。xxx@39。,39。Alan39。,to_date(39。05/02/9239。,39。dd/mm/yy39。),39。60039。,39。1239。,39。監(jiān)督員39。,39。4000039。,39。大學39。,39。三年39。)。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。0030139。,39。Bard39。,39。上海市南京路39。,39。(021)1111239。,39。xxx@39。,39。Abel39。,to_date(39。26/03/9139。,39。dd/mm/yy39。),null,39。2139。,39。經(jīng)理39。,39。7000039。,39。大學39。,39。三年39。)。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。0030239。,39。Harry39。,39。南京市六合區(qū)39。,39。(021)11111239。,39。xxx@39。,39。Bard39。,to_date(39。15/06/9139。,39。dd/mm/yy39。),null,39。2139。,39。科長39。,39。5000039。,39。大學39。,39。二年39。)。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。0030339。,39。Bart39。,39。廣州市人民路39。,39。(020)11111139。,39。xxx@39。,39。Harry39。,to_date(39。15/12/9139。,39。dd/mm/yy39。),39。40039。,39。2139。,39。人事39。,39。3000039。,39。專科39。,39。二年39。)。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。0030439。,39。Eden39。,39。廣州市中山路39。,39。(020)11111239。,39。xxx@39。,39。Harry39。,to_date(39。08/01/9239。,39。dd/mm/yy39。),39。50039。,39。2139。,39?？倓?9。,39。3000039。,39。大學39。,39。二年39。)。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。0030539。,39。Beau39。,39。北京市海淀區(qū)39。,39。(010)11111139。,39。xxx@39。,39。Harry39。,to_date(39。16/01/9239。,39。dd/mm/yy39。),39。30039。,39。2139。,39。采購39。,39。