CREATE TABLE Suppliers(
    sid int,
    sname VARCHAR(16),
    address VARCHAR(26),
    PRIMARY KEY(sid)
);

CREATE TABLE Part(
    pid int,
    pname VARCHAR(16),
    color VARCHAR(26),
    PRIMARY KEY(pid)
);

CREATE TABLE Catalog(
    pid int,
    sid int,
    cost NUMERIC(8,2)
    PRIMARY KEY(pid,sid)
    FOREIGN KEY(sid) REFERENCES  Suppliers(sid),
    FOREIGN KEY(pid) REFERENCES Part(pid)
);
INSERT INTO Suppliers(sid, sname, address)
VALUES
(10, 'Ford', 'Ford Address'),
(11, 'Chevy', 'Chevy Address'),
(12, 'Toyato', 'Toyato Address');

INSERT INTO Part(pid, pname, color)
VALUES
(1, 'Wheel', 'Green'),
(2, 'Hood', 'Silver'),
(3, 'Tire', 'Black');

INSERT INTO Catalog(pid,sid, cost)
VALUES
(1, 10, 85.65),
(1, 11, 100),
(1, 12, 200),
(2, 10, 30),
(2, 11, 45),
(2, 12, 60),
(3, 10, 115),
(3, 11, 100),
(3, 12, 79.76);