Multiple Tables

• Creating Table

CREATE TABLE Supplier (
    SupplierID INTEGER PRIMARY KEY, 
    Name VARCHAR(20) NOT NULL, 
    Phone CHAR(9) NULL
);

• Adding data into Table

INSERT INTO Supplier VALUES (1, "Moana", "234-13321");

INSERT INTO Supplier VALUES (2, "Aweu", "123-13321");

INSERT INTO Supplier VALUES (3, "Projen", "345-13321");

• Alter Table to Create a Reference Integrity

ALTER TABLE Product 
    ADD CONSTRAINT fk_product_supplier 
    FOREIGN KEY (Supplier) 
    REFERENCES Supplier(SupplierID);

• Conform the Reference Integrity

INSERT INTO Product VALUES ("Walach", 3.99, 3);

INSERT INTO Product VALUES ("Waduch", 1.99, 5);