CREATE TABLE CUSTOMER(CUSTOMER_NUMBER NUMBER(10,0) NOT NULL, CUSTOMER_NAME VCHAR2(25), CUSTOMER_ADDRESS VCHAR2(30),
CUSTOMER_DISTRICT VCHAR(50), CONSTRAINT CUSTOMER_PK PRIMARY KEY (CUSTOMER_NUMBER));

CREATE TABLE CUSTOMER_ORDER(ORDER_NUMBER NUMBER(10,0) NOT NULL, CUSTOMER_NUMBER NUMBER(10,0) NOT NULL, ORDER_DATE DATE
DEFAULT SYSDATE, RECEIVER_NAME VCHAR(25), DELIVERY_ADDRESS VCHAR(200), DELIVERY_DISTRICT(50), FACTORY_NUMBER NUMBER(10,0)
NOT NULL, PROCESSING_STATUS CHAR(1) DEFAULT "U", CHECK (PROCESSING_STATUS IN ("M", "D", "P", "C")) 
OUTSTANDING_PAYMENT FLOAT(9,2) DEFAULT "0.00", CONSTRAINT ORDER_NUMBER PRIMARY KEY (ORDER_NUMBER),
CONSTRIANT CUSTOMER_ORDER_FK FOREIGN KEY FACTORY_NUMBER REFEE^^  

CREATE TABLE ORDER_LINE(ORDER_NUMBER NUMBER(10,0) NOT NULL, COMPONENT_NUMBER NUMBER(10,0) NOT NULL, 
SUPPLIER_NUMBER NUMBER(10,0) NOT NULL, UNIT_PRICE FLOAT(6,2) DEFAULT "0.00", QUANTITY INTEGER(6,0) DEFAULT "0",   
CREATE TABLE COMPONENT (COMPONENT_NUMBER NUMBER(10,O) NOT NULL, COMPONENT NAME VCHAR(25), 
CONSTRAINT COMPONENT_PK PRIMARY KEY (COMPONENT_NUMBER));

CREATE TABLE PURCHASE_ORDER(ORDER_NUMBER NUMBER(10,0) NOT NULL, SUPPLIER_NUMBER NUMBER(10,0) NOT NULL,
ORDER_DATE DATE DEFAULT SYSDATE, PLANNED_DELIVERY_DATE DATE DEFAULT SYSDATE,

CREATE TABLE PURCHASE_ORDER_LINE(ORDER_NUMBER NUMBER(10,0) NOT NULL, SUPPLIER_NUMBER NUMBER(10,0) NOT NULL, COMPONENT_NUMBER
NUMBER(10,0) NOT NULL, UNIT_PRICE FLOAT(6,2) DEFAULT "0.00", QUANTITY INTEGER(6,0) DEFAULT "0",

CREATE TABLE SUPPLIER(SUPPLIER_NUMBER NUMBER(10,0) NOT NULL, SUPPLER_NAME VCHAR(25), SUPPLIER_ADDRESS VCHAR(200),
CONSTRAINT SUPPLIER_PK PRIMARY KEY (SUPPLIER_NUMBER)); 
   
CREATE TABLE SUPPLIER_COMPONENT(SUPPLIER_NUMBER NUMBER(10,0) NOT NULL, COMPONENT_NUMNER NUMBER(10,0) NOT NULL, 
UNIT_PRICE FLOAT(6,2) DEFAULT "0.00", QUANTITY INTEGER(6,0) DEFAULT "0", MANUFACTURE_DAY 

CREATE TABLE FACTORY(FACTORY_NUMBER NUMBER(10,0) NOT NULL, FACTORY_NAME VCHAR(25), FACTORY_DISTRICT VCHAR(50),
CONSTRAINT FACTORY_PK PRIMARY KEY (FACTORY_NUMBER));



pk-CONSTRIANT _PK PRIMARY KEY ()
fk-CONSTRIANT _FK FOREIGN KEY ()REFERENCES ()

    Source: geocities.com/hk/alexmai00

               ( geocities.com/hk)