Monster Market collects product reviews. Each review needs these columns:
| Column | What it holds |
|---|---|
id | a whole number, required |
product_id | a whole number, required |
stars | a whole number, required |
body | the text of the review, optional |
approved | yes or no, required; false when the INSERT does not say |
written_on | a date, required; today when the INSERT does not say |
A mistake? Click Reset lab and create the table again.
- Create the
reviewstable. - Add review 1: product 7, 5 stars, the text
Great stickers. List only these four columns. Look at the row in the tab. - Add review 2 for product 7 with no stars. The database refuses it. Which column does the error name?
- The customer gave 4 stars and no text, and the team approves the review. Add review 2.