【正文】 ,custadd,custphone,custfax) values(39。顯卡39。,500,30,0)。insert into prostock(ProName,Val,Stiqty,Insqty) values (39。內(nèi)存39。,1000,10,0)。insert into prostock(ProName,Val,Stiqty,Insqty) values (39。主板39。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。六年39。?？?9。3900039。科長(zhǎng)39。3539。dd/mm/yy39。16/10/9339。Ian39。xxx39。(037)11111239。鄭州市中山路39。Jack39。0080539。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。八年39。高中39。3800039?？崎L(zhǎng)39。3439。dd/mm/yy39。26/08/9439。Ian39。xxx39。(021)11111139。上海市四川路39。Ira39。0080339。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。五年39。?？?9。6000039。副理39。2339。dd/mm/yy39。10/12/9239。Abel39。xxx39。(010)11111139。北京市海淀區(qū)39。Ian39。0080139。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。二年39。高中39。2500039。QA39。3339。30039。dd/mm/yy39。09/07/9439。CASH39。xxx39。(021)1111239。上海市南京路39。Eddy39。0070239。)。,39。,39。,39。,39。),null,39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。二年39。高中39。2500039。外務(wù)39。3239。60039。dd/mm/yy39。23/02/9439。Hermes39。xxx39。(021)11111139。上海市四川路39。Ford39。0060739。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。二年39。?？?9。2500039。倉(cāng)管39。3239。80039。dd/mm/yy39。03/09/9439。Hermes39。xxx39。(021)11111139。上海市四川路39。Gary39。0060539。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。二年39。?？?9。4000039。生管39。3239。70039。dd/mm/yy39。02/12/9339。Hermes39。xxx39。(037)11111239。鄭州市中山路39。Gale39。0060339。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。二年39。?？?9。4000039。科長(zhǎng)39。3239。dd/mm/yy39。29/04/9239。Abel39。xxx39。(021)11111139。上海市四川路39。Hermes39。0060139。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。三年39。大學(xué)39。8000039。經(jīng)理39。2239。dd/mm/yy39。24/07/9139。Abel39。xxx39。(020)11111139。廣州市人民路39。Dan39。0050139。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。二年39。大學(xué)39。4000039。成會(huì)39。3139。50039。dd/mm/yy39。28/09/9139。Carl39。xxx39。(031)1111139。石家莊市人民路39。Ed39。0040239。)。,39。,39。,39。,39。),null,39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。二年39。大學(xué)39。3000039。采購(gòu)39。2139。30039。dd/mm/yy39。16/01/9239。Harry39。xxx39。(010)11111139。北京市海淀區(qū)39。Beau39。0030539。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。二年39。?？?9。3000039。人事39。2139。40039。dd/mm/yy39。15/12/9139。Harry39。xxx39。(020)11111139。廣州市人民路39。Bart39。0030339。)。,39。,39。,39。,39。),null,39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。三年39。大學(xué)39。7000039。經(jīng)理39。2139。dd/mm/yy39。26/03/9139。Abel39。xxx39。(021)1111239。上海市南京路39。Bard39。0030139。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。三年39。研究所39。12000039。經(jīng)理39。1239。dd/mm/yy39。23/06/9139。Abel39。xxx39。(037)11111139。鄭州市人民路39。Alan39。0020139。)。,39。,39。,39。,39。,39。),39。,39。,to_date(39。,39。,39。,39。,39。,39。 Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。五年39。研究所39。18000039。總經(jīng)理39。1139。dd/mm/yy39。06/05/9039。xxx39。(010)11111139。北京市海淀區(qū)39。Abel39。0010139。)。,39。,39。insert into Depart(DeptNo,DeptName,LOC) values (39。鄭州39。壓合科39。3439。)。,39。,39。insert into Depart(DeptNo,DeptName,LOC) values (39。鄭州39。品保科39。3339。)。,39。,39。insert into Depart(DeptNo,DeptName,LOC) values (39。北京39。業(yè)務(wù)部39。2239。)。,39。,39。insert into Depart(DeptNo,DeptName,LOC) values (39。鄭州39。管理部39。2139。)。,39。,39。insert into Depart(DeptNo,DeptName,LOC) values (39。北京39。總經(jīng)理室39。1139。wip_seq；create sequence wip_seq start with 1increment by 1nomaxvaluenocyclenocache。invoice；create sequence invoice_seq start with 1increment by 1nomaxvaluenocyclenocache。實(shí)現(xiàn)表主鍵自動(dòng)增長(zhǎng)的對(duì)應(yīng)表的序列Customer_seq:create sequence customer_seq start with 1increment by 1nomaxvaluenocyclenocache。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))。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))。Customer:create table customer(custid varchar2(10) constraint pk_customer primary key,custname varchar2(22),custadd varchar2(20),custphone varchar2(12),custfax varchar2(12))。生產(chǎn)管理系統(tǒng)1． ER圖2．?dāng)?shù)據(jù)字典 Table：字段名稱數(shù)據(jù)元素名稱字段類型字段長(zhǎng)度鍵值empid員工編號(hào)VARCHAR210PKempname員工姓名VARCHAR210empadd員工地址VARCHAR220empphone員工電話VARCHAR212電子郵件VARCHAR220mgr上司VARCHAR26hiredate雇用日期DATEsal薪資NUMBER10m傭金NUMBER7,2pro職稱VARCHAR212deptno部門(mén)編號(hào)NUMBER2FKeduca學(xué)歷VARCHAR212exper經(jīng)歷VARCHAR220 Table：字段名稱數(shù)據(jù)元素名稱字段類型字段長(zhǎng)度鍵值deptno部門(mén)編號(hào)NUMBER2PKdeptname部門(mén)名稱VARCHAR210loc地點(diǎn)VARCHAR2