This is the Monster Market database. Link icons mark the foreign keys.
- The product team sends a new product: id 13,
Kraken Poster, price12.00, in the new category 6,Wall Art. Add the product. The database refuses it. Which table does the DETAIL line name? - Add category 6 and product 13.
- Create a table
wishlistwithcustomer_idandproduct_id(whole numbers, required) andadded_on(date, required, today by default). Each id must point to a row that exists in its table. - Grace Okafor (customer 12) wants the Kraken Poster. Add it to her wishlist.
- Try to drop the
categoriestable. Which table does the DETAIL line say depends on it?