Exericse: Simple shop system


The following screenshot is a real-world sample from a catering service


Design a database model based upon the screenshot/PDF above.

  • Orders are transferred from the PDF to the database; there is no need for a user authentication
  • Each item is available through a defined menu
  • Let's assume that the shop only delivers to customers in the United States