The orders Table has a Column called "date" that says at which date the meal can be fetched. But the meal itself has a date, too. This makes the date-Column in orders unnecessary; The date can be fetched with one join.
It even creates Bugs when changing the Date of the Meal without changing the dates of the Orders. This should not be the Case.
Anonymous