Use the supplied DDL SQL to create the following tables with coded relationships in Oracle AppEx.  Underneath each SQL paste a screenshot of the table structure from AppEx.   CREATE TABLE PRODUCT (  P_CODE     VARCHAR(10) NOT NULL,  P_DESCRIPT VARCHAR(35) NOT NULL,  P_INDATE   DATE        NOT NULL,  P_QOH      SMALLINT    NOT NULL,  P_MIN      SMALLINT    NOT NULL,  P_PRICE    NUMBER(8,2) NOT NULL,  P_DISCOUNT NUMBER(5,2) NOT NULL,  V_CODE     INTEGER,  PRIMARY KEY (P_CODE),  FOREIGN KEY (V_CODE) REFERENCES VENDOR);     CREATE TABLE VENDOR (  V_CODE     INTEGER     NOT NULL,  V_NAME     VARCHAR(35) NOT NULL,  V_CONTACT  VARCHAR(15) NOT NULL,  V_AREACODE CHAR(3)     NOT NULL,  V_PHONE    CHAR(8)     NOT NULL,  V_STATE    CHAR(2)     NOT NULL,  V_ORDER    CHAR(1)     NOT NULL,  PRIMARY KEY (V_CODE));             CREATE TABLE CUSTOMER ( CUS_CODE       NUMBER PRIMARY KEY, CUS_LNAME       VARCHAR(15) NOT NULL, CUS_FNAME       VARCHAR(15) NOT NULL, CUS_INITIAL     CHAR(1), CUS_AREACODE CHAR(3) DEFAULT '615' NOT NULL CHECK(CUS_AREACODE IN ('615','713','931')), CUS_PHONE       CHAR(8) NOT NULL, CUS_BALANCE     NUMBER(9,2) DEFAULT 0.00, CONSTRAINT CUS_UI1 UNIQUE(CUS_LNAME,CUS_FNAME));

A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter3: Creating Tables
Section: Chapter Questions
Problem 7CAT: Review the data for the TRIP table in Figure 1-5 in Chapter 1 and then review the data types used to...
Question
  • Use the supplied DDL SQL to create the following tables with coded relationships in Oracle AppEx.  Underneath each SQL paste a screenshot of the table structure from AppEx.

 

CREATE TABLE PRODUCT (

 P_CODE     VARCHAR(10) NOT NULL,

 P_DESCRIPT VARCHAR(35) NOT NULL,

 P_INDATE   DATE        NOT NULL,

 P_QOH      SMALLINT    NOT NULL,

 P_MIN      SMALLINT    NOT NULL,

 P_PRICE    NUMBER(8,2) NOT NULL,

 P_DISCOUNT NUMBER(5,2) NOT NULL,

 V_CODE     INTEGER,

 PRIMARY KEY (P_CODE),

 FOREIGN KEY (V_CODE) REFERENCES VENDOR);

 

 

CREATE TABLE VENDOR (

 V_CODE     INTEGER     NOT NULL,

 V_NAME     VARCHAR(35) NOT NULL,

 V_CONTACT  VARCHAR(15) NOT NULL,

 V_AREACODE CHAR(3)     NOT NULL,

 V_PHONE    CHAR(8)     NOT NULL,

 V_STATE    CHAR(2)     NOT NULL,

 V_ORDER    CHAR(1)     NOT NULL,

 PRIMARY KEY (V_CODE));

 

 

 

 

 

 

CREATE TABLE CUSTOMER (

CUS_CODE       NUMBER PRIMARY KEY,

CUS_LNAME       VARCHAR(15) NOT NULL,

CUS_FNAME       VARCHAR(15) NOT NULL,

CUS_INITIAL     CHAR(1),

CUS_AREACODE CHAR(3) DEFAULT '615' NOT NULL CHECK(CUS_AREACODE IN ('615','713','931')),

CUS_PHONE       CHAR(8) NOT NULL,

CUS_BALANCE     NUMBER(9,2) DEFAULT 0.00,

CONSTRAINT CUS_UI1 UNIQUE(CUS_LNAME,CUS_FNAME));

 

Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning