Designing an Online Food Delivery System

A customer opens the app in the evening. She picks two dishes from a restaurant nearby. She pays with a card. Then she watches a rider carry the bag across a map.

Five tables are written before the food leaves the kitchen. This case study builds all of them, from that sentence to running SQL. It is the last one in the course, and it uses every rule before it.

What the system must do

Six capabilities, taken from what people do in the app.

Keep customer details, including more than one delivery address each.

Keep restaurant details, with a menu and a rating.