--
-- 	Database Table Creation
--
CREATE TABLE suppliers (
	sid INTEGER,
	sname VARCHAR(256),
	address VARCHAR(256),
        CONSTRAINT suppliers_pk PRIMARY KEY (sid)
	);
CREATE TABLE parts (
	pid INTEGER,
	pname VARCHAR(256),
	color VARCHAR(100),
        CONSTRAINT parts_pl PRIMARY KEY (pid)
	);
CREATE TABLE catalog (
	sid INTEGER,
	pid INTEGER,
	cost NUMERIC(10,2),
	CONSTRAINT catalog_pk PRIMARY KEY(sid,pid),
	CONSTRAINT catalog_sid_fk FOREIGN KEY(sid) REFERENCES suppliers,
	CONSTRAINT catalog_pid_fk FOREIGN KEY(pid) REFERENCES parts
	);