Reference no: EM131756160

Hello

I am having a little bit of a problem with creating and inserting  a MySQL table that will hold a list of category ,Option, budget, purchase tables . I am not to sure how to create the tables in my sql and insert a dummy data into it  ?inserting  a MySQL table that will hold a list of category ,Option, budget, purchase tables . I am not to sure how to create the tables in my sql and insert a dummy data into it  ? Can you please correct me or show me how to create and insert inorder to provide a working sql query? insert inorder to provide a working sql query?

CREATE TABLE CATEGORY(

  CATAGORY_ID VARCHAR(10) NOT NULL ,

  CATTYPE VARCHAR(35)NOT NULL,

  CATDESCREPTION VARCHAR(100) NOT NULL,

  PRIMARY KEY (CATEGORY_ID)

)

 INSERT INTO CATEGORY VALUES (1, "WINDOW", " INTERIOR PILLAR WINDOW" );

CREATE TABLE OPTION(

  ITEM_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,

  DESCREPTION VARCHAR(35) NOT NULL,

  MATERIALCOST DECIMAL(8 2) NOT NULL,

  ITEMQUANTITY DECIMAL(8 2) NOT NULL;

  PRIMARY KEY (item_id),

  FOREIGN KEY (category_id) REFERENCES category (category_id),

  FOREIGN KEY (sub_id) REFERENCES categories (sub_id)

)

INSERT INTO OPTION VALUES (1, "CASEMENT", " INTERIOR GLASSWINDOW" );