This is the Monster Market database.
-
Add product 13,
Broken Mug, with the price-5.00. The database refuses it. Which constraint does the error name? -
Create a table
reviews:id: whole number, the primary keyproduct_id: whole number, requiredstars: whole number, required, only 1, 2, 3, 4 or 5. Name this rulestars_range.body: text, optional
-
Add these reviews with one INSERT:
id product_id stars body 1 7 5 Great stickers 2 10 0 Arrived broken 3 1 4 Soft Which constraint does the error name?
-
The customer of review 2 chose the lowest score the shop allows. Fix the value and add the three reviews.