Provide MySQL & PostgreSQL code please I’m having difficulties Instructions: YOU WILL NOT WRITE SQL CODE THIS WAY: CREATE TABLE-Product

Provide MySQL & PostgreSQL code please I’m having difficulties Instructions: YOU WILL NOT WRITE SQL CODE THIS WAY: CREATE TABLE-Product

Question:

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..

Expert Answer:

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