Question

1. Activity to: Create a Product Table with common data types Activity Write the SQL to create a Product table with the following columns: • ● ID - Integer Name - Variable-length string with maximum 40 characters ProductType - Variable-length string with maximum 3 characters OriginDate - Year, month, and day Weight - Decimal number with six significant digits and one digit after the decimal point Place your CREATE TABLE statement before the INSERT and SELECT statements. Run your solution on a RDBMS of your choice and verify the result table contains the three inserted rows. Hint: Review the example CREATE TABLE statement in the animation above. Carefully check the placement of commas, parentheses, and semicolon.

Fig: 1