Part 2

-- Generated by Oracle SQL Developer Data Modeler 18.1.0.082.1035 -- at: 2019-07-06 19:48:13 EDT -- site: Oracle Database 11g -- type: Oracle Database 11g CREATE TABLE addrss ( addrid NUMBER(7) NOT NULL, res_no VARCHAR2(20), street VARCHAR2(300) NOT NULL, city VARCHAR2(100) NOT NULL, state CHAR(2), zip CHAR(10), addrtype CHAR(1) NOT NULL, shipng_shpng_id NUMBER(7) NOT NULL, shipng_order_order_id NUMBER(7) NOT NULL, shipng_order_transctn_tran_id NUMBER(7) NOT NULL, shipng_order_promo_prm_id NUMBER(7) NOT NULL, whrhse_whr_id NUMBER(7) NOT NULL, whrhse_invt_invt_id NUMBER(7) NOT NULL, whrhse_invt_sup_id NUMBER(7) NOT NULL, cust_cust_id NUMBER(7) NOT NULL ); ALTER TABLE addrss ADD CONSTRAINT addrss_pk PRIMARY KEY ( addrid, shipng_shpng_id, shipng_order_order_id, shipng_order_transctn_tran_id, shipng_order_promo_prm_id, whrhse_whr_id, whrhse_invt_invt_id, whrhse_invt_sup_id, cust_cust_id ); CREATE TABLE cust ( cust_id NUMBER(7) NOT NULL, fname VARCHAR2(100) NOT NULL, lname VARCHAR2(7) NOT NULL, cust_email VARCHAR2(320) ); ALTER TABLE cust ADD CONSTRAINT cust_pk PRIMARY KEY ( cust_id ); CREATE TABLE emply ( empid NUMBER(7) NOT NULL, fname VARCHAR2(100) NOT NULL, lname VARCHAR2(100) NOT NULL, dept VARCHAR2(100) NOT NULL, desgn VARCHAR2(100) NOT NULL, addrss_addrid NUMBER(7) NOT NULL, addrss_shpng_id NUMBER(7) NOT NULL, addrss_order_id NUMBER(7) NOT NULL, addrss_tran_id NUMBER(7) NOT NULL, addrss_prm_id NUMBER(7) NOT NULL, whrhse_whr_id NUMBER(7) NOT NULL, whrhse_invt_id NUMBER(7) NOT NULL, whrhse_sup_id NUMBER(7) NOT NULL, addrss_whr_id NUMBER(7) NOT NULL, addrss_invt_id NUMBER(7) NOT NULL, addrss_sup_id NUMBER(7) NOT NULL, addrss_cust_cust_id NUMBER(7) NOT NULL ); ALTER TABLE emply ADD CONSTRAINT emply_pk PRIMARY KEY ( empid, addrss_addrid, addrss_shpng_id, addrss_order_id, addrss_tran_id, addrss_prm_id, addrss_whr_id, addrss_invt_id, addrss_sup_id, addrss_cust_cust_id, whrhse_whr_id, whrhse_invt_id, whrhse_sup_id ); CREATE TABLE invt ( invt_id NUMBER(7) NOT NULL, invt_desc VARCHAR2(300) NOT NULL, invt_size NUMBER(2) NOT NULL, inv_date DATE NOT NULL, in_stock NUMBER(7) NOT NULL, cost NUMBER(10,2) NOT NULL, suplr_sup_id NUMBER(7) NOT NULL ); ALTER TABLE invt ADD CONSTRAINT invt_pk PRIMARY KEY ( invt_id, suplr_sup_id ); CREATE TABLE "ORDER" ( order_id NUMBER(7) NOT NULL, ord_desc VARCHAR2(300) NOT NULL, transctn_tran_id NUMBER(7) NOT NULL, promo_prm_id NUMBER(7) NOT NULL ); ALTER TABLE "ORDER" ADD CONSTRAINT order_pk PRIMARY KEY ( order_id, transctn_tran_id, promo_prm_id ); CREATE TABLE promo ( prm_id NUMBER(7) NOT NULL, prm_desc VARCHAR2(200), prm_amt NUMBER(10,2) NOT NULL ); ALTER TABLE promo ADD CONSTRAINT promo_pk PRIMARY KEY ( prm_id ); CREATE TABLE shipng ( shpng_id NUMBER(7) NOT NULL, shng_desc VARCHAR2(100), shpng_status CHAR(1) NOT NULL, order_order_id NUMBER(7) NOT NULL, order_transctn_tran_id NUMBER(7) NOT NULL, order_promo_prm_id NUMBER(7) NOT NULL ); ALTER TABLE shipng ADD CONSTRAINT shipng_pk PRIMARY KEY ( shpng_id, order_order_id, order_transctn_tran_id, order_promo_prm_id ); CREATE TABLE shp_crt ( shp_id NUMBER(7) NOT NULL, cost NUMBER(10,2) NOT NULL, cust_cust_id NUMBER(7) NOT NULL, invt_invt_id NUMBER(7) NOT NULL, invt_sup_id NUMBER(7) NOT NULL, transctn_tran_id NUMBER(7) NOT NULL ); ALTER TABLE shp_crt ADD CONSTRAINT shp_crt_pk PRIMARY KEY ( shp_id, cust_cust_id, invt_invt_id, invt_sup_id, transctn_tran_id ); CREATE TABLE suplr ( sup_id NUMBER(7) NOT NULL, sup_name VARCHAR2(300) NOT NULL, addrid NUMBER(7) ); ALTER TABLE suplr ADD CONSTRAINT suplr_pk PRIMARY KEY ( sup_id ); CREATE TABLE transctn ( tran_id NUMBER(7) NOT NULL, card_num NUMBER(14) ); ALTER TABLE transctn ADD CONSTRAINT transctn_pk PRIMARY KEY ( tran_id ); CREATE TABLE whrhse ( whr_id NUMBER(7) NOT NULL, whr_nm VARCHAR2(100) NOT NULL, invt_invt_id NUMBER(7) NOT NULL, invt_sup_id NUMBER(7) NOT NULL ); ALTER TABLE whrhse ADD CONSTRAINT whrhse_pk PRIMARY KEY ( whr_id, invt_invt_id, invt_sup_id ); ALTER TABLE addrss ADD CONSTRAINT addrss_cust_fk FOREIGN KEY ( cust_cust_id ) REFERENCES cust ( cust_id ); ALTER TABLE addrss ADD CONSTRAINT addrss_shipng_fk FOREIGN KEY ( shipng_shpng_id, shipng_order_order_id, shipng_order_transctn_tran_id, shipng_order_promo_prm_id ) REFERENCES shipng ( shpng_id, order_order_id, order_transctn_tran_id, order_promo_prm_id ); ALTER TABLE addrss ADD CONSTRAINT addrss_whrhse_fk FOREIGN KEY ( whrhse_whr_id, whrhse_invt_invt_id, whrhse_invt_sup_id ) REFERENCES whrhse ( whr_id, invt_invt_id, invt_sup_id ); ALTER TABLE emply ADD CONSTRAINT emply_addrss_fk FOREIGN KEY ( addrss_addrid, addrss_shpng_id, addrss_order_id, addrss_tran_id, addrss_prm_id, addrss_whr_id, addrss_invt_id, addrss_sup_id, addrss_cust_cust_id ) REFERENCES addrss ( addrid, shipng_shpng_id, shipng_order_order_id, shipng_order_transctn_tran_id, shipng_order_promo_prm_id, whrhse_whr_id, whrhse_invt_invt_id, whrhse_invt_sup_id, cust_cust_id ); ALTER TABLE emply ADD CONSTRAINT emply_whrhse_fk FOREIGN KEY ( whrhse_whr_id, whrhse_invt_id, whrhse_sup_id ) REFERENCES whrhse ( whr_id, invt_invt_id, invt_sup_id ); ALTER TABLE invt ADD CONSTRAINT invt_suplr_fk FOREIGN KEY ( suplr_sup_id ) REFERENCES suplr ( sup_id ); ALTER TABLE "ORDER" ADD CONSTRAINT order_promo_fk FOREIGN KEY ( promo_prm_id ) REFERENCES promo ( prm_id ); ALTER TABLE "ORDER" ADD CONSTRAINT order_transctn_fk FOREIGN KEY ( transctn_tran_id ) REFERENCES transctn ( tran_id ); ALTER TABLE shipng ADD CONSTRAINT shipng_order_fk FOREIGN KEY ( order_order_id, order_transctn_tran_id, order_promo_prm_id ) REFERENCES "ORDER" ( order_id, transctn_tran_id, promo_prm_id ); ALTER TABLE shp_crt ADD CONSTRAINT shp_crt_cust_fk FOREIGN KEY ( cust_cust_id ) REFERENCES cust ( cust_id ); ALTER TABLE shp_crt ADD CONSTRAINT shp_crt_invt_fk FOREIGN KEY ( invt_invt_id, invt_sup_id ) REFERENCES invt ( invt_id, suplr_sup_id ); ALTER TABLE shp_crt ADD CONSTRAINT shp_crt_transctn_fk FOREIGN KEY ( transctn_tran_id ) REFERENCES transctn ( tran_id ); ALTER TABLE whrhse ADD CONSTRAINT whrhse_invt_fk FOREIGN KEY ( invt_invt_id, invt_sup_id ) REFERENCES invt ( invt_id, suplr_sup_id ); -- Oracle SQL Developer Data Modeler Summary Report: -- -- CREATE TABLE 11 -- CREATE INDEX 0 -- ALTER TABLE 24 -- CREATE VIEW 0 -- ALTER VIEW 0 -- CREATE PACKAGE 0 -- CREATE PACKAGE BODY 0 -- CREATE PROCEDURE 0 -- CREATE FUNCTION 0 -- CREATE TRIGGER 0 -- ALTER TRIGGER 0 -- CREATE COLLECTION TYPE 0 -- CREATE STRUCTURED TYPE 0 -- CREATE STRUCTURED TYPE BODY 0 -- CREATE CLUSTER 0 -- CREATE CONTEXT 0 -- CREATE DATABASE 0 -- CREATE DIMENSION 0 -- CREATE DIRECTORY 0 -- CREATE DISK GROUP 0 -- CREATE ROLE 0 -- CREATE ROLLBACK SEGMENT 0 -- CREATE SEQUENCE 0 -- CREATE MATERIALIZED VIEW 0 -- CREATE SYNONYM 0 -- CREATE TABLESPACE 0 -- CREATE USER 0 -- -- DROP TABLESPACE 0 -- DROP DATABASE 0 -- -- REDACTION POLICY 0 -- -- ORDS DROP SCHEMA 0 -- ORDS ENABLE SCHEMA 0 -- ORDS ENABLE OBJECT 0 -- -- ERRORS 0 -- WARNINGS 0