【正文】 et number(10)。||||39。end loop。)。insert into WIP(ProID,w_qty,is_finish)values(39。,39。,1)。439。1539。insert into WIP(ProID,w_qty,is_finish)values(39。,39。,1)。339。30039。insert into WIP(ProID,w_qty,is_finish)values(39。,39。,1)。139。6039。wip:insert into WIP(ProID,w_qty,is_finish)values(39。,39。)。139。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,0)。A1111139。,39。2039。,39。439。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,0)。A1111139。,39。1239。,39。239。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,0)。A1111139。,39。439。,39。139。delivery:insert into Delivery (proid,ordid,carno,is_invoice)values(39。03/04/9239。),0,1)。,to_date(39。dd/mm/yy39。5039。,39。,39。20/02/9239。2139。),to_date(39。,39。dd/mm/yy39。439。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。16/05/9239。),0,1)。,to_date(39。dd/mm/yy39。10039。,39。,39。16/03/9239。1339。),to_date(39。,39。dd/mm/yy39。339。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。11/06/9239。),0,1)。,to_date(39。dd/mm/yy39。3039。,39。,39。18/04/9239。539。),to_date(39。,39。dd/mm/yy39。139。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。10/02/9239。)。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。柏圖電子股份有限公司39。,39。上海市南京路39。,39。(020)11111239。,39。(021)11111339。)。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。旭聯(lián)電子股份有限公司39。,39。鄭州市人民路39。,39。(021)11111239。,39。(020)11111339。)。insert into customer(custname,custadd,custphone,custfax) values(39。銘望電子股份有限公司39。,39。石家莊市人民路39。,39。(037)11111139。,39。(021)11111239。)。customer:insert into customer(custname,custadd,custphone,custfax) values(39。內(nèi)存39。)。,39。,to_date(39。,39。?？?9。dd/mm/yy39。(037)11111239。)。,39。,to_date(39。,39。高中39。dd/mm/yy39。(021)11111139。)。,39。,to_date(39。,39。專科39。dd/mm/yy39。(010)11111139。)。,39。,to_date(39。,39。高中39。30039。xxx39。0070239。,39。,to_date(39。,39。高中39。60039。xxx39。0060739。,39。,39。,39。二年39。3239。Hermes39。Gary39。,39。),39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。生管39。02/12/9339。鄭州市中山路39。,39。,39。,39。,39。4000039。29/04/9239。上海市四川路39。,39。,39。,39。,39。8000039。24/07/9139。廣州市人民路39。,39。,39。,39。,39。4000039。dd/mm/yy39。(031)1111139。)。,39。,39。,39。3000039。dd/mm/yy39。(010)11111139。)。,39。,to_date(39。,39。?？?9。40039。xxx39。0030339。,39。,to_date(39。,39。大學39。dd/mm/yy39。(021)1111239。)。,39。,to_date(39。,39。研究所39。dd/mm/yy39。(037)11111139。)。,39。,to_date(39。,39。研究所39。dd/mm/yy39。北京市海淀區(qū)39。,39。壓合科39。,39。3339。insert into Depart(DeptNo,DeptName,LOC) values (39。)。鄭州39。,39?？偨?jīng)理室39。實現(xiàn)表主鍵自動增長的對應表的序列Customer_seq:create sequence customer_seq start with 1increment by 1nomaxvaluenocyclenocache。生產(chǎn)管理系統(tǒng)1． ER圖2．數(shù)據(jù)字典 Table：字段名稱數(shù)據(jù)元素名稱字段類型字段長度鍵值empid員工編號VARCHAR210PKempname員工姓名VARCHAR210empadd員工地址VARCHAR220empphone員工電話VARCHAR212電子郵件VARCHAR220mgr上司VARCHAR26hiredate雇用日期DATEsal薪資NUMBER10m傭金NUMBER7,2pro職稱VARCHAR212deptno部門編號NUMBER2FKeduca學歷VARCHAR212exper經(jīng)歷VARCHAR220 Table：字段名稱數(shù)據(jù)元素名稱字段類型字段長度鍵值deptno部門編號NUMBER2PKdeptname部門名稱VARCHAR210loc地點VARCHAR213 Table：字段名稱數(shù)據(jù)元素名稱字段類型字段長度鍵值proid產(chǎn)品編號VARCHAR210PKproname產(chǎn)品名稱VARCHAR220stiqty尚有數(shù)量NUMBER10insqty需補數(shù)量NUMBER10Val產(chǎn)品單價NUMBER10 Table：字段名稱數(shù)據(jù)元素名稱字段類型字段長度鍵值custid客戶編號VARCHAR210PKcustname客戶姓名VARCHAR222custadd客戶地址VARCHAR220custphone客戶電話VARCHAR212custfax客戶傳真VARCHAR212 Table：字段名稱數(shù)據(jù)元素名稱字段類型字段長度鍵值ordid訂單編號VARCHAR210PKproid產(chǎn)品編號VARCHAR210FKcustid客戶編號VARCHAR210FKo_qty訂購數(shù)量NUMBER20orddate訂購日期DATE8d_date交貨日期DATE8Is_delivery是否出貨NUMBER1Is_invoice是否需要發(fā)票NUMBER1 Table：字段名稱數(shù)據(jù)元素名稱字段類型字段長度鍵值wipid工令編號VARCHAR210PKproid產(chǎn)品編號VARCHAR210FKw_qty數(shù)量NUMBER10Is_finish是否完成NUMBER1 Table：字段名稱數(shù)據(jù)元素名稱字段類型字段長度鍵值ordid訂單編號VARCHAR210FKinvid發(fā)票編號VARCHAR210PKproid產(chǎn)品編號VARCHAR210FKmoney金額NUMBER10 Table：字段名稱數(shù)據(jù)元素名稱字段類型字段長度鍵值proid產(chǎn)品編號VARCHAR210FKordid訂單編號VARCHAR210FKcarno出車編號VARCHAR210delino出貨編號VARCHAR210PK3．授權情況一覽（★為對此人授權）1. EMP Table: 權限人員SelectInsertUpdateAlterDeleteAbel總經(jīng)理室★Ivan總經(jīng)理室Alan監(jiān)督室Henry監(jiān)督室Bard管理部★Harry管理部★Bart人事科★★★★★Eden管理部Beau管理部Carl會計科Ed會計科Cliff會計科Dan業(yè)務部Frank業(yè)務部Hermes生管科Des生管科Gale生管科Beck生管科Gary生管科Danny生管科Ford生管科Cash品?？艵ddy 品保科Barton 品?？艻an制造部Hank制造部Ira壓合科Abner壓合科Jack內(nèi)務科Ade內(nèi)務科 Table： 權限人員SelectInsertUpdateAlterDeleteAbel總經(jīng)理室★Ivan總經(jīng)理室Alan監(jiān)督室Henry監(jiān)督室Bard管理部★Harry管理部★Bart人事科★★★★★Eden管理部Beau管理部Carl會計科Ed會計科Cliff會計科Dan業(yè)務部Frank業(yè)務部Hermes生管科Des生管科Gale生管科Beck生管科Gary生管科Danny生管科Ford生管科Cash品保科Eddy 品?？艬arton 品?？艻an制造部Hank制造部Ira壓合科Abner壓合科Jack內(nèi)務科Ade內(nèi)務科 Table： 權限人員SelectInsertUpdateAlterDeleteAbel總經(jīng)理室★Ivan總經(jīng)理室★Alan監(jiān)督室★Henry監(jiān)督室★Bard管理部★Harry管理部★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)務科 Table： 權限人員SelectInsertUpdateAlterDeleteAbel總經(jīng)理室★Ivan總經(jīng)理室★Alan監(jiān)督室★