Learning Objective: Construct conceptual (ER diagram) and logical models from a statement requirement to solve common design problems
computer science
Description
Question 1
Learning Objective: Construct conceptual (ER diagram) and logical models from a statement requirement to solve common design problems
Deli-Very is a food delivery service provider. It employs part-time staff to perform its
deliveries. The details of each delivery staff, that is, the staff id, a first and last name, and
contact as well as the number of deliveries performed and the delivery details are tracked.
Customers can place their order from any one of the many food establishments registered
with it. A registered food establishment has one or more outlets, and each outlet offers the
same menu at the same prices. Deli-Very takes a cut from each food order. The cut ranges
from 10% to 35%, depending on how long the food establishment has been with Deli-Very.
The cut is not reflected on the food order, and is incurred by the food establishment
Customers must register before placing orders. The required details for registration are a
valid email and a telephone number. Upon a successful registration, the customer is assigned
customer id. To make payments by card, customers can add a card details: number and type.
If payment for a food order is made by card, a payment code is recorded. If payment is by
cash, a payment status reflects complete only when the delivery staff submits the cash
collected for the food order to Deli-Very. Otherwise, the payment status reflects Pending.
