Provide MySQL & PostgreSQL code please I'm having difficulties Instructions: YOU WILL NOT WRITE SQL CODE THIS

Provide MySQL & PostgreSQL code please I'm having difficulties

 

Transcribed Image Text:

Instructions: YOU WILL NOT WRITE SQL CODE THIS WAY: CREATE TABLE-Product prod_id CHAR(10), Phame VARCHAR(30) price DECIMAL PRIMARY KEY (prod_id), CHECK-(price->0)); BUT YOU WILL PROVIDE NAMES FOR ALL OF THE CONSTRAINTS AND USE ALTER TABLE: CREATE TABLE Product( prod_id CHAR(10), poame price VARCHAR(30), DECIMAL); ALTER TABLE Product ADD CONSTRAINT pk_product PRIMARY KEY (prod_id); ALTER TABLE Product ADD CONSTRAINT ck product.price CHECK (price > 0); Primary key constraints begin with pk_. Foreign key constraints begin with fk... Check constraints begin with ck.. Instructions: YOU WILL NOT WRITE SQL CODE THIS WAY: CREATE TABLE-Product prod_id CHAR(10), Phame VARCHAR(30) price DECIMAL PRIMARY KEY (prod_id), CHECK-(price->0)); BUT YOU WILL PROVIDE NAMES FOR ALL OF THE CONSTRAINTS AND USE ALTER TABLE: CREATE TABLE Product( prod_id CHAR(10), poame price VARCHAR(30), DECIMAL); ALTER TABLE Product ADD CONSTRAINT pk_product PRIMARY KEY (prod_id); ALTER TABLE Product ADD CONSTRAINT ck product.price CHECK (price > 0); Primary key constraints begin with pk_. Foreign key constraints begin with fk... Check constraints begin with çk.. Instructions: YOU WILL NOT WRITE SQL CODE THIS WAY: CREATE TABLE-Product prod_id CHAR(10), Phame VARCHAR(30) price DECIMAL PRIMARY KEY (prod_id), CHECK-(price->0)); BUT YOU WILL PROVIDE NAMES FOR ALL OF THE CONSTRAINTS AND USE ALTER TABLE: CREATE TABLE Product( prod_id CHAR(10), poame price VARCHAR(30), DECIMAL); ALTER TABLE Product ADD CONSTRAINT pk_product PRIMARY KEY (prod_id); ALTER TABLE Product ADD CONSTRAINT ck product.price CHECK (price > 0); Primary key constraints begin with pk_. Foreign key constraints begin with fk... Check constraints begin with ck.. Instructions: YOU WILL NOT WRITE SQL CODE THIS WAY: CREATE TABLE-Product prod_id CHAR(10), Phame VARCHAR(30) price DECIMAL PRIMARY KEY (prod_id), CHECK-(price->0)); BUT YOU WILL PROVIDE NAMES FOR ALL OF THE CONSTRAINTS AND USE ALTER TABLE: CREATE TABLE Product( prod_id CHAR(10), poame price VARCHAR(30), DECIMAL); ALTER TABLE Product ADD CONSTRAINT pk_product PRIMARY KEY (prod_id); ALTER TABLE Product ADD CONSTRAINT ck product.price CHECK (price > 0); Primary key constraints begin with pk_. Foreign key constraints begin with fk... Check constraints begin with çk..

Answer rating: 100% (QA)

Based on the instructions and the image provided it appears that you are tasked with writing SQL code for the creation of a table named Product with c... View the full answer