PARTICIPATION

ACTIVITY

$3\mathrm{.}3\mathrm{.}4$: Create a Product table.

Write the SQL to create a Product table with the following columns:

ID $-$ Unsigned integer

Name $-$ Variable$-$length string with maximum $40$ characters

ProductType $-$ Fixed$-$length string with maximum $3$ characters

OriginDate $-$ Year, month, and day.

Weight $-$ Decimal number with six significant digits and one digit after the decimal po

Place your CREATE TABLE statement before the INSERT and SELECT statements. Run your contains the three inserted rows.

$--$ Write your CREATE TABLE statement here:

INSERT INTO Product $($ID$,$ Name, ProductType, OriginDate, Weight$)$ VALUES

$(100,$ 'Tricorder', 'COM', $\text{'}2020-08-11\text{'},2\mathrm{.}4),$

$(200,$ 'Food replicator', 'FOD', $\text{'}2020-09-21\text{'},54\mathrm{.}2),$

$(300,$ 'Cloaking device', 'SPA', $\text{'}2019-02-04\text{'},177\mathrm{.}9)$;

SELECT $*$

FROM Product: