This is the Monster Market database. Open the customers tab: email is unique.
- Add customer 13:
Ken Ito, fromJP, signed up on 2025-06-10, with the emailava.chen@example.com. The database refuses it. Which constraint does the error name? - Customer 10 has no email. Before you run it: will the database accept customer 13 with no email? Answer yes or no.
- Add customer 13 with no email.
- Create a table
coupons:id(whole number, the primary key),code(text, required, and never the same for two coupons) andpercent_off(whole number). - Each customer may use each coupon only once. Create a table
coupon_useswithcustomer_id,coupon_id(whole numbers, required) andused_on(date, required), where the database refuses a second use of the same coupon by the same customer.