Can someone please create tables based on the picture below

Can someone please create tables based on the picture below in MySQL and then export it to a PDF or jpeg? I would like the actual tables in MySQL

Merged 3NF solution: product [ prod code, prod_desc, um, dept_cd (FK), supplier_id (FK), cost, markup ] dept [ dept cd, dept_name, aisle_no] supplier [ supplier_id, supplier_name ]

Solution

Here is the code to create tables for MySQL:

CREATE TABLE dept(dept_cd int, dept_name varchar(80), aisle_no int,
primary key (dept_cd));
CREATE TABLE supplier(supplier_id int, supplier_name varchar(80),
primary key (supplier_id));

CREATE TABLE product(prod_code int, prod_desc varchar(80), um int,
dept_cd int, supplier_id int, cost decimal(5, 2),
markup int, primary key(prod_code),
foreign key (dept_cd) references dept(dept_cd),
foreign key (supplier_id) references supplier(supplier_id));