Food Ordering System (ER Diagram)

An entity-relationship diagram that depicts the entities of the food ordering system.

ER Diagram for Food Ordering System

This ER diagram describes the data model of food ordering system. The modeled system supports various restaurants with different menus. Each menu item allows the customer to choose extras. Coupons can be applied to order to get discounts.

Food Ordering System (ER Diagram)
Food Ordering System (ER Diagram)

The ER model includes these ERD entities:

  • Restaurant
  • Opening Hours - defines at which time the restaurant is open on individual weekdays.
  • Weekday - an enumeration entity with the particular weekdays (Sunday - Saturday)
  • Coupon
  • Menu - specifies the offered food by the restaurant defined with referenced menu items.
  • Menu Group - defines the groups within the restaurant menu (such as soups, appetizers, salads, main courses, dessert).
  • Menu Item - defines a dish offered by the restaurant.
  • Menu Item Extra - defines side dishes and possible modifications to the menu item.
  • Customer
  • Order - an entity that includes the customer choice in the restaurant.
  • Order Item
  • Order Item Extra
  • Order Status - the order may be in one of these statuses: Draft, Ordered, Preparing, Checking, Prepared, Delivering, Taken Over, and Cancelled.

ERD Tool

If you are new here, you may be interested in our ERD tool, which you can use to open the example above:

Download ERD of Food Ordering System

The example of ER diagram for food ordering system can be download here. After downloading you can edit it using Software Ideas Modeler diagramming editor.

Food Ordering System (ER Diagram)

Comments

Dua 22 May 2021 14:55:08

database

good job

Philomena nkunika 29 September 2021 10:17:03

Erd for food ordering system

I have a school project which is due 2 weeks from now.please I need help

New Comment

Comment