Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3.3E One of your (hipster) acquaintances thinks he has the next billion-dollar startup idea for an app. Pizza Delivery with Entertainment. He heard from other

image text in transcribed

3.3E One of your (hipster) acquaintances thinks he has the next billion-dollar startup idea for an app. Pizza Delivery with Entertainment. He heard from other people that you are following the course on database management, and asks you to design the EER model. Afterwards, be will use the EER model to ask programmers to implement the app. He explains the basic functionality of the app as follows: customers can order pizzas from restaurants to be delivered to a specific address, and if they want to, they can choose a special "entertainment order". When an order is an entertainment order, the delivery person stays with the customer after delivering the pizza and entertains the custamers (e.g., by singing, making jokes, doing magic tricks, etc.) for a certain amount of time. Now follows a detailed explanation of the range of capabilities of the app: when people create an account for the app and become app users, they have to indicate their birthday and fill in their name and address. Every user should also be uniquely identifiable. Once the account is created, the users should be presented with three options: the first option in the app is to select "business owner". Of these basiness owners, we also ask them to provide their Linkedin account so we can add them to our professional network. Every business owner can own a number of pizza restaurants. Of these pizza restaurants, we want to register the zip code, address, phone number, website, and the opening hours. Each pizza restaurant can offer a number of pizzas. Of those pizzas, we want to keep the name (margarita, quattro stagioni, etc.), the crust structure (for example, classic Italian crust, deep dish crust, cheese crust), and the price. While two pizaas from different pizza restaurants may have the same name, they will not be exactly the same as the taste will be different, and thus should be considered unique. Moreover, pizzas should be distinguishable even if they have the same price, e.g., a pizza margarita from Pizza Pronto in New York which casts $12 must be distinguishable from a pizza margarita from Pizza Rapido in Singapore, which also costs $12. The second option in the app is to select "hungry customer". For these hungry customers, we need a delivery address. Hungry customers can make orders for pizzas. Each order gets assigned an ID, and we want our app to log the date and time when the order was placed. We also allow the hungry customer to indicate the latest time of delivery, and ask how many people the order is for. An order can be for ane or more pizzas. Also, a special type of order can be made: the entertainment order. Not every order has to be an entertainment order. Bat when a hungry customer indicates that he or she wants to be entertained while eating the pizza, we not only want to register all the regular arder information, but also the type of entertainment the user requests, and for how lons (a duration). The third option in the app to select is that of "entertainer". When users select entertainer, they need to provide a stage name, write a short bio about themselves, and indicate their price per 30 minates. Every entertainment order is falfilled by exactly one entertainer. Every entertainer can choose for which pizza restaurant(s) heishe wants to work. For each pizza restaurant an entertainer wants to work with, heishe should indicate hisher availability by day (Monday, Tuesday, Wednesday, etc.). Make an EER model and UML class diagram to model the data requirements. Camment on the limitations of both models

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions

Question

How do Data Types perform data validation?

Answered: 1 week ago

Question

How does Referential Integrity work?

Answered: 1 week ago