Skip to main content

Variant 3: Database "Restaurant Management System"

info

Level: Hard

Description

Design a database for a restaurant chain that manages multiple locations, menu items, orders, and staff.

  • Each restaurant location has its own kitchen staff, servers, and managers.
  • The menu includes various categories (appetizers, main courses, desserts).
  • Each menu item has ingredients, preparation time, and cost.
  • The system tracks inventory of ingredients and manages suppliers.
  • Customers can place orders for dine-in, takeaway, or delivery.
  • The system handles table reservations and manages seating arrangements.
  • Staff schedules and shifts are managed for each location. The system tracks customer feedback and ratings.

MVP Features

  • Basic restaurant location management
  • Menu items and categories
  • Basic order processing (dine-in and takeaway)
  • Staff management and basic scheduling
  • Simple inventory tracking

Final Version Features

  • Table reservations
  • Advanced inventory management with suppliers
  • Detailed staff scheduling and shift management
  • Customer feedback and rating system

Technical overview

Minimal Set of Base Tables:

MVP Tables:

  • Locations
  • Staff
  • MenuItems
  • Orders
  • BasicInventory

Final Version Tables:

  • Reservations
  • Ingredients
  • Suppliers
  • CustomerFeedback
  • ShiftSchedules

Minimum Set of Table Fields:

MVP Fields:

  • Location ID
  • Location address
  • Staff ID
  • Staff role
  • Menu item name
  • Menu category
  • Item price
  • Order number
  • Order type (dine-in/takeaway)
  • Order status
  • Basic inventory count

Final Version Fields:

  • Reservation date/time
  • Table number
  • Ingredient name
  • Ingredient quantity
  • Supplier details
  • Feedback rating
  • Feedback comment
  • Customer information
  • Shift details