BPafK0Dq

1CREATE DATABASE IF NOT EXISTS AM05_Q2;
2SHOW DATABASES;
3
4CREATE TABLE VENDORS
5	(vendor_name   		VARCHAR(50), 
6     vendor_address		VARCHAR(50),
7CONSTRAINT VENDORS_PK
8PRIMARY KEY (vendor_name));
9
10CREATE TABLE PARTS
11	(part_no   			INT NOT NULL, 
12     description		VARCHAR(50),
13CONSTRAINT PARTS_PK
14PRIMARY KEY (part_no));
15
16CREATE TABLE UNITCOSTS
17	(part_no   			INT, 
18     vendor_name		VARCHAR(50),
19     unit_cost			INT,
20CONSTRAINT UNITCOSTS_PK
21PRIMARY KEY (part_no, vendor_name));