Table Name: PRODUCTS (.5) FIELD NAME DATA TΥΡΕ CONSTRAINT DESCRIPTION PID NUMBER (5) PRIMARY KEY Product ID DESC VARCHAR2(30) NOT NULL Description PRICE NUMBER(5) Price SID NUMBER(5) FOREIGN ΚEY...

SqlTable Name: PRODUCTS<br>(.5)<br>FIELD NAME<br>DATA TΥΡΕ<br>CONSTRAINT<br>DESCRIPTION<br>PID<br>NUMBER (5)<br>PRIMARY KEY<br>Product ID<br>DESC<br>VARCHAR2(30)<br>NOT NULL<br>Description<br>PRICE<br>NUMBER(5)<br>Price<br>SID<br>NUMBER(5)<br>FOREIGN ΚEY<br>Supplier ID<br>2. Add Check constraint to Price column. It must accept price more than 0 only.<br>(.5)<br>3. Add new column QTY as NUMBER(5) for the PRODUCTS table.<br>(.5)<br>4. Insert the given data in SUPPLIERS and PRODUCTS tables:<br>(.5)<br>

Extracted text: Table Name: PRODUCTS (.5) FIELD NAME DATA TΥΡΕ CONSTRAINT DESCRIPTION PID NUMBER (5) PRIMARY KEY Product ID DESC VARCHAR2(30) NOT NULL Description PRICE NUMBER(5) Price SID NUMBER(5) FOREIGN ΚEY Supplier ID 2. Add Check constraint to Price column. It must accept price more than 0 only. (.5) 3. Add new column QTY as NUMBER(5) for the PRODUCTS table. (.5) 4. Insert the given data in SUPPLIERS and PRODUCTS tables: (.5)

Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here