Please recreate this table in my MySQL and then export it as

Please recreate this table in my MySQL and then export it as PDF or jpeg. I would like the actual tables made in MySQL?

SUPPLIER DEPARTMENT Supplier ID Department Code Department Name Aisle Number Supplier Name PRODUCT Product Code Product Description Unit of Measure Cost Amount Markup Percent Supplier ID (FK) Department Code (FK)

Solution

CREATE TABLE DEPARTMENT
(
Department_Code int NOT NULL,
Department_Name varchar(255),
Aisle_Number int,
PRIMARY KEY (Department_Code)
);
  
CREATE TABLE SUPPLIER
(
Supplier_ID int NOT NULL,
Supplier_Name varchar(255),
PRIMARY KEY (Supplier_ID)
);
  
CREATE TABLE PRODUCT
(
Product_Code int NOT NULL,
Product_Description varchar(255),
Unit_of_Measure varchar(255),
Cost_Amount double,
Markup_Percent double,
Supplier_ID int,
Department_Code int,
PRIMARY KEY (Product_Code),
FOREIGN KEY (Supplier_ID) REFERENCES SUPPLIER(Supplier_ID),
FOREIGN KEY (Department_Code) REFERENCES DEPARTMENT(Department_Code)
)