CSC2203 First ex

CREATE TABLE IF NOT EXISTS Sale (

    `SaleID` INT,

    `SaleDate` DATETIME,

    `Tax` NUMERIC(2, 0),

    `Total` VARCHAR(3) CHARACTER SET utf8,

      PRIMARY KEY(SALEID),

       FOREIGN KEY(SALEID),

);



CREATE TABLE IF NOT EXISTS Sale_Item (

    `SaleID` INT,

    `SaleItemID` INT,

       PRIMARY KEY(SALEID),

       FOREIGN KEY(SALEID),



);



CREATE TABLE IF NOT EXISTS ITEM (

    `ITEMID` INT,

    `Name` VARCHAR(4) CHARACTER SET utf8,

    `Cost` VARCHAR(3) CHARACTER SET utf8,

    `Price` VARCHAR(3) CHARACTER SET utf8,

       PRIMARY KEY(ITEMID),

       FOREIGN KEY(ITEMID),



);