ER Diagram for Food Ordering System
Budget: $10 – $30 USD
This ER diagram describes the data model of food ordering system. The modeled system supports different menus. Each menu item allows the customer to choose extras.
The ER model includes these ERD entities:
Employee Role - may be in one of [driver, cook, manager].
Vehicle - defines the main data of Vehicles.
Employee - defines the main data of Employees.
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.
The ER model includes these ERD entities:
Employee Role - may be in one of [driver, cook, manager].
Vehicle - defines the main data of Vehicles.
Employee - defines the main data of Employees.
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.