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