1. [6 points] Create and display the following table. Let the name of the table be products_tbl

Table 1: products_tbl

PROD_ID PROD_DESC COST

----------------------------------------------------------------------------

11235 WITCH COSTUME 29.99

222 PLASTIC PUMPKIN 18 INCH 7.75

13 FALSE PARAFFIN TEETH 1.1

90 LIGHTED LANTERNS 14.5

15 ASSORTED COSTUMES 10

9 CANDY CORN 1.35

6 PUMPKIN CANDY 1.45

87 PLASTIC SPIDERS 1.05

119 ASSORTED MASKS 4.95

2

1. [4 points] Add a fourth column on Table 1 and name it as STORES. Under this column, you can have the following list of entries stored.

PARTY CITY

TOYS R US

WALGREENS

WALMART

COSTCO

SAFEWAY

TRADER JOES

DOLLAR TREE

TARGET