Menu

Food Delivery

This database diagram represents a simple Food Delivery App system with three connected tables:

1. Restaurants – Stores details of each restaurant including its ID, name, and location.

2. MenuItems – Contains menu items offered by restaurants, with each item linked to a restaurant through a foreign key (restaurant_id).

3. Orders – Records customer orders, linking each order to a menu item using item_id.

The relationships ensure that each menu item belongs to one restaurant, and each order refers to one specific item. This structure supports efficient food ordering and tracking.