Peter is really happy with his website. He's decided to open an online store with products for people who fall in love. Heart-shaped balloons, rings, fresh flowers – anything you can imagine. Let's create a table called product
for him. Take a look at the description below, decide on the data types, and provide a suitable SQL statement.
Each product has an id
(an integer number) and a name
that's 64 characters long at most. It also has a description
, which can be of up to 256 characters. We also need the price
for each product (all of them cost below $300.00). Last but not least, we want to store product weights in a column named weight
and we are okay with small rounding errors.