GreekEat – Marketplace of national food and grocery
GreekEat is a high-end Greek food market chain comprising a variety of restaurants, food and beverage stations, bakery, and retail items. Part supermarket, part high-end food court, and part culinary arts school, GreekEat was fashioned around the concept of Europe’s open markets and designed to bring together multiple aspects of consumer interaction with food. Currently GreekEat has 4 locations in Greece and about 10 stores all over the world. It is an alliance of small-scale producers, who have been making the finest foods and beverages in limited quantities for generations. The information system behind must be able to support both producers, localized all over Greece, and customers who can buy Greek food in the physical stores around the world and online and receive at home. Each producer is not obliged to sell his/her product at all stores (both physical and online), but GreekEat obliges each producer to properly handle his/her shelves, which must be always full of products of the categories and types they have declared. Customers may buy from the groceries, from the restaurant, and attend cook classes. Social digital marketing is one of the cornerstones of the GreekEat. It is both used to rank the producers for their marketing strategy and to attract customers and keep them loyal at GreekEat brand and favorite producers through its digital channels.
By examining the scenario described above:
- Draw on paper A clear EER diagram of (at least a part of) the information system, in order to answer to the following questions
- List the providers (restaurants, food and beverage stations, bakery, and retail items) and the official address which are currently present in each location, split by category
- Extract the total amount billed to a given store in a given week
The correct answer and explanation is:
Here’s how we can break down the request:
- Enhanced Entity-Relationship (EER) Diagram
- I will design an EER diagram that includes key entities such as Producers, Stores, Customers, Products, Orders, and Locations.
- It will show relationships like producers supplying stores, customers purchasing from different providers, and marketing strategies tracking engagement.
- Listing of Providers and Addresses per Location
- We will extract and organize data showing which providers (restaurants, bakery, etc.) operate at each store location.
- Total Billed Amount Calculation for a Given Store in a Given Week
- We will assume an order structure and calculate the total sales revenue for a store in a specific week.
I will generate the EER diagram now.
I have generated an Enhanced Entity-Relationship (EER) Diagram representing the GreekEat information system. Now, I’ll proceed with listing the providers and extracting the total amount billed to a store in a given week.
I have displayed the provider details by location and the total billed amount for each store in a given week. Let me know if you need any further analysis or explanations!
