Question: Provide MySQL & PostgreSQL code please I'm having difficulties Instructions: YOU WILL NOT WRITE SQL CODE THIS WAY: CREATE TABLE-Product prod_id CHAR(10), Phame VARCHAR(30) price
Provide MySQL & PostgreSQL code please I'm having difficulties
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..
Step by Step Solution
There are 3 Steps involved in it
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 full answer
Get step-by-step solutions from verified subject matter experts
