Write a SQL script to add another
table to your database. Include these fields in
your Product table:
Field Name
Description
Data Type
Sample Value
ProductID
Product ID
integer
5
ProductName
Product Name
varchar(50)
candle
Description
Product Description
varchar(255)
Bee’s wax candle
picUrl
Filename of the product’s picture
varchar(50)
candle.gif
Price
Product Price
decimal
10.99
ProductID
should be the Primary Key. It is an auto-increment field.
The Price
field stores prices to 7 significant digits and to 2...