1 activity to create a product table with common data types activity w
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.