Database Management System
CSE · Quiz · Spring 26
Paper 1 of 8By Md. Ferdous Foysal Hridoy (1)Switch
Paper 1 of 8
Read the questions as text
Read off the PDF by AI, so it may have mistakes. The PDF is the original.
Quiz 1
Smart Online Food Delivery System
A Smart Online Food Delivery System is designed to manage customers, restaurants, delivery partners, orders, and payments on a single platform.
When a customer registers on the platform, the system assigns a unique customer ID. For each customer, the system stores full name, email address, date of birth, and gender. Every customer must have at least one contact number, but some customers may have more than one. The system also stores the customer's delivery address, including house number, street name, city, and postal code.
The platform partners with restaurants. Each restaurant has a unique restaurant ID. For each restaurant, the system stores restaurant name, location, contact number, and food category. A restaurant may be registered on the platform even if it has no active orders.
Restaurants offer food items. Each food item has a unique item code and belongs to exactly one restaurant. For each food item, the system stores item name, price, and availability status. A food item cannot exist without a restaurant.
Customers place orders. Each order has a unique order ID and order date. A customer may place many orders, but each order belongs to exactly one customer. An order must include at least one food item. For each ordered item, the system stores quantity and item price at the time of order.
The platform employs delivery partners. Each delivery partner has a unique partner ID. For each partner, the system stores full name, phone number, vehicle type, and license number. A delivery partner may deliver many orders, but an order is delivered by only one delivery partner.
Some orders may be cancelled, while others are successfully delivered. For each order, the system stores order status, delivery time, and customer rating, if provided.
The system handles payments. Each payment has a unique payment ID. For each payment, the system stores payment date, amount, and payment method. A payment cannot exist unless the related order exists. Some orders may be placed but not yet paid.
Customers can also leave reviews for restaurants. Each review has a unique review ID, review date, rating, and comments. A review cannot exist unless both the customer and the restaurant exist. A customer may review a restaurant multiple times on different dates.