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.