Design conceptual model of a database using ER Diagram for the following scenario

 

 

Uber Eats business Rules. 

UberEATs is an online platform for food ordering services. Uber eats partner with restaurants and independent delivery persons to provide food services to the end customers. 

Customers need to provide their email address or mobile phone number and password for registration. One needs to also provide your name and language of communication during registration. Once registration process completes, one can login using your UberEATS account.

One can save up to two delivery addresses in the app. One have to add at least one primary payment option to use UberEATS platform. The primary payment option can be credit card or debit card. One can add card information about payment options by manually typing the information. Other than this one can add gift cards in the payment options. For this one need to add gift card code in the UberEATS app.  One can add multiple gift cards to the account. Gift cards never expire. 

Customer can order different menus offered by different restaurants. For each menu, one needs to select menu items with their preferences for the customisable menu items. Once preferences are selected, one can add order to the order cart. In an order cart, one can order multiple menu items from the same restaurant but not from multiple restaurants.  If one likes to order from multiple restaurants, one can place another order from a different restaurant while your current order is being prepared and delivered. To place the order, you need to checkout, where you need to select delivery address, delivery option, and payment method. One can also add a promotion code during checkout. Delivery options are of two types: 'deliver as soon as possible' or 'scheduled'. If scheduled selected, one needs to provide date and time for delivery. You can also add special delivery instructions in your order.

 

Once order is placed, one can follow from the status of their order which can be prepared, ready for pickup, going out for delivery, cancelled or delivered etc. One can also view the estimated delivery time of the order. Order can be cancelled by the restaurant, customer or delivering driver.

 

Generally, the total cost of an UberEATS order will include ordered menu cost, Delivery Fee, Service Fee, and other applicable fees such as busy area fee and priority fee. All these will be clearly specified in a customer receipt which may also include discounts from promotion. One can view receipts of all the past orders.

 

Customer can opt to receive marketing communication from restaurants. In that case, customer name, email, and order history will be shared with restaurants who can use this information for personalised marketing communications. These communications can include special offers, promotions or loyalty/reward programs.

 

Customers can save new promo codes and view their status (i.e. active, redeemed, and expired) with their discount details. Only one discount (promo code) can be applied per order. 

User can provide feedback about their orders using 5 star rating system and comments on quality of order, delivery quality, inaccuracy in the order etc.

 

 

Restaurants can partner with UberEATS program and use the platform for advertising their menus and receive orders. To request partnership with UberEATS, a restaurant needs to provide its name and details such as primary address, number of locations and estimated weekly to-go orders. One needs to also provide email address and mobile number. UberEATS can accept or reject this request. Once request is accepted, one needs to agree with UberEATS terms and conditions. After request and agreement is accepted, an account is created with the email address of the restaurant and password. 

UberEATS receives all the orders and will process payments on behalf of restaurant . On a weekly basis, restaurants receive all the order payments after deduction of uber eats fees.

 

Restaurants can add different menus using menu maker function of UberEATS. Before one can add a menu, first a restaurant needs to add categories by providing a name to it. Within a category, one can add multiple menus. 

To add new menu items, one must provide a menu name and detailed description. One must assign menu hours (breakfast, lunch, or dinner). You need to also provide days in the week when the menu will be available to customers. You need provide which category this menu belongs to.

Each menu consists of multiple menu items. Each menu items need name, description, price and tax rate. You can also add dietary preference such as vegetarian or gluten free with each item. You need to provide a photo for each menu item. Each item can be marked as 'sold out' or 'available'

One can also create customisations which can be attached to multiple menu items. Each customisation consists of multiple customisation options which are available for customers to choose while ordering. Each customisation option has a name and cost associated with it. For example, if coffee is the menu item, one can add customisation options of different types of milk such as soy, almond, cow milk.  For each customisation, there is limit that need to be set by the restaurant. This limit indicates how many customisation options that can be selected.

 

When a customer places an order, restaurant can view the orders they have received. As soon as restaurant read the order details, order status changes to 'in-preparation'. Once order is preparation finished, restaurant updates the order status to 'ready for pickup'.  As soon as status is updated, delivery person's estimated time to pick up the order will appear with order details. Restaurant can also view the delivery person's contact information assigned for pickup.

After delivery person picks up the order, order status changes to "on delivery". Once delivery is finished restaurant can rate the delivery person.

 

In due to unforeseen events, restaurants can cancel the order by giving appropriate reasoning. In such cases, customers are not charged. However, restaurants still need to pay uber eats fees.

 

 

One can signup as deliver person for UberEATS. For signup, one must provide proof of ID such as passport details, driving licence information and vehicle registration number. One must provide his name, email, phone number and address. Each delivery person who wants to get jobs from UberEATS needs to go through a background check. Once background check is completed, their account is activated to receive delivery orders. 

 

Once a restaurant changes the status of order to pickup, nearby deliver persons will receive the request to pick up with trip information. Before a delivery person accepts an order, an upfront trip information is given including estimated earning, where to pickup and where to deliver.  The delivery person can either opt to accept or reject the request. If request is accepted by a delivery person, he needs to pick up the order after checking the order details and drop-off the order to the delivery address. Driver can call the customer in case delivery address is not found. Driver can cancel the order if customer does not pickup the call or call back after certain amount of time. All these call details are kept for auditing purposes. Driver can rate customer and restaurant for each delivery. 

The delivery person receives their earning weekly basis in their bank account. 

Answer rating: 100% (QA)

Heres a description of the conceptual ER diagram for Uber Eats along with key entities and relationships Entities Customer Attributes customerid name ... View the full answer