Questions: Given the metadata above for columns of the Product & Vendor tables,

Question

Questions: Given the metadata above for columns of the Product & Vendor tables, write CREATE TABLE statements for these tables incl PK, FK & CHECK constraints

Column DataType Size Decimal Domain PK? FK? Positions PRODUCT LINE P CODE Character 8 PDESCRIPT Character 1 35 P INDATE Valid date Date PONHAND Numeric 5 0 2 0 P MIN Numeric 2 0 2 20 P PRICE Numeric 3 2 P DISCOUNT Numeric 20.00 & s 1.00 6 0 V CODE Numeric VENDOR PRODUCT 2 1000000 V NAME Character 1- 35 V CONTACT Character 1-20 V AREACODE Numeric 3 0 2 100 & S 999 7 0 V PHONE Numeric 2 1010000 2 V STATE Alphabetic Character VORDER Character 1 'Y', 'N'

Explanation / Answer

CREATE TABLE PRODUCT
(
P_CODE CHARACTER(8),
PDESCRIPT CHARACTER(35) NOT NULL,
P_INDATE DATE,
P_ONHAND NUMERIC(5,0) CHECK (P_ONHAND>=0),
P_MIN NUMERIC(5,0) CHECK (P_MIN>=0),
P_PRICE NUMERIC(6,2) CHECK (P_PRICE>=0),
P_DISCOUNT NUMERIC(3,2) CHECK (P_DISCOUNT >= 0 AND P_DISCOUNT <= 1.00),
PRIMARY KEY (P_CODE),
FOREIGN KEY (P_CODE) REFERENCES VENDOR(V_CODE)
);

CREATE TABLE VENDOR
(
V_CODE NUMERIC(6,0) CHECK (V_CODE>=1000000),
V_NAME CHARACTER(35) NOT NULL,
V_CONTACT CHARACTER(20) NOT NULL,
V_AREACODE NUMERIC(3,0) CHECK (V_AREACODE >=100 AND V_AREACODE<=999),
V_PHONE NUMERIC(7,0) CHECK (V_PHONE>=1010000),
V_STATE CHARACTER(2),
V_ORDER CHARACTER(1) CHECK (V_ORDER = 'Y' OR V_ORDER = 'N'),
PRIMARY KEY (V_CODE),
FOREIGN KEY (V_CODE) REFERENCES VENDOR(P_CODE)
);

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.