Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
HungryMe is a young entrepreneurial company to offer F&B delivery services that operates between food stalls and consumers. The company receives customers' order via mobile app and redirects the orders to their partner food stalls for preparation. When the foods are ready, the company deliverymen will delivery to respective customers within an estimated timeframe. For every order placement, user must provide the shipment address and particulars of the order. Each order transaction can include one or more menu items. The ORDER entity consists of attributes OrderCode(Identifier), OrderDateTime, ShipmentAddress, EstimaTime, CustPhoneNo and TotalCharge, while MENU_ITEM entity consists of attributes ItemCode(identifier), Desc, UnitPrice , Category and Ratings. Every menu item may be ordered in various orders or haven't been ordered in any order yet. Remark and quantity of each item ordered should be traceable. One menu item comes from a specific food stall. Thus, two menu items with identical description would not have the same identifier as they are provided by two distinct food stalls. Each food stall may cater one or many menu items. The FOOD_STALL entity consists of attriībutes MerchantCode, MerchantName, MerchantLocation and MerchantPhoneNo.

HungryMe is a young entrepreneurial company to offer F&B delivery services that operates between food stalls and consumers. The company receives customers' order via mobile app and redirects the orders to their partner food stalls for preparation. When the foods are ready, the company deliverymen will delivery to respective customers within an estimated timeframe. For every order placement, user must provide the shipment address and particulars of the order. Each order transaction can include one or more menu items. The ORDER entity consists of attributes OrderCode(Identifier), OrderDateTime, ShipmentAddress, EstimaTime, CustPhoneNo and TotalCharge, while MENU_ITEM entity consists of attributes ItemCode(identifier), Desc, UnitPrice , Category and Ratings. Every menu item may be ordered in various orders or haven't been ordered in any order yet. Remark and quantity of each item ordered should be traceable. One menu item comes from a specific food stall. Thus, two menu items with identical description would not have the same identifier as they are provided by two distinct food stalls. Each food stall may cater one or many menu items. The FOOD_STALL entity consists of attriībutes MerchantCode, MerchantName, MerchantLocation and MerchantPhoneNo.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
100%
Question 2 Consider the following scenario of a food and beverage (F&B) delivery partner. HungryMe is a young entrepreneurial company to offer F&B delivery services that operates between food stalls and consumers. The company receives customers' order via mobile app and redirects the orders to their partner food stalls for preparation. When the foods are ready, the company deliverymen will delivery to respective customers within an estimated timeframe. For every order placement, user must provide the shipment address and particulars of the order. Each order transaction can include one or more menu items. The ORDER entity consists of attributes OrderCode(Identifier), OrderDateTime, ShipmentAddress, EstimaTime, CustPhoneNo and TotalCharge, while MENU_ITEM entity consists of attributes ItemCode(identifier), Desc, UnitPrice , Category and Ratings. Every menu item may be ordered in various orders or haven't been ordered in any order yet. Remark and quantity of each item ordered should be traceable. One menu item comes from a specific food stall. Thus, two menu items with identical description would not have the same identifier as they are provided by two distinct food stalls. Each food stall may cater one or many menu items. The FOOD_STALL entity consists of attributes MerchantCode, MerchantName, MerchantLocation and MerchantPhoneNo. Once an order placement is done, the system will automatically assign a deliveryman in-charge to the order. The attributes for DELIVERY_MAN are EmpCode(Identifier), EmpName, EmpPhoneNo and EmpScore. b) For each of the entities in the ERD drawn in Question 2 a), list all relevant attributes using Database Design Language (DBDL) format. In your listing, show all the primary keys, composite keys and foreign keys (if any) clearly. Underline all the primary keys or composite keys and identify the foreign key with an *.
Transcribed Image Text:Question 2 Consider the following scenario of a food and beverage (F&B) delivery partner. HungryMe is a young entrepreneurial company to offer F&B delivery services that operates between food stalls and consumers. The company receives customers' order via mobile app and redirects the orders to their partner food stalls for preparation. When the foods are ready, the company deliverymen will delivery to respective customers within an estimated timeframe. For every order placement, user must provide the shipment address and particulars of the order. Each order transaction can include one or more menu items. The ORDER entity consists of attributes OrderCode(Identifier), OrderDateTime, ShipmentAddress, EstimaTime, CustPhoneNo and TotalCharge, while MENU_ITEM entity consists of attributes ItemCode(identifier), Desc, UnitPrice , Category and Ratings. Every menu item may be ordered in various orders or haven't been ordered in any order yet. Remark and quantity of each item ordered should be traceable. One menu item comes from a specific food stall. Thus, two menu items with identical description would not have the same identifier as they are provided by two distinct food stalls. Each food stall may cater one or many menu items. The FOOD_STALL entity consists of attributes MerchantCode, MerchantName, MerchantLocation and MerchantPhoneNo. Once an order placement is done, the system will automatically assign a deliveryman in-charge to the order. The attributes for DELIVERY_MAN are EmpCode(Identifier), EmpName, EmpPhoneNo and EmpScore. b) For each of the entities in the ERD drawn in Question 2 a), list all relevant attributes using Database Design Language (DBDL) format. In your listing, show all the primary keys, composite keys and foreign keys (if any) clearly. Underline all the primary keys or composite keys and identify the foreign key with an *.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Distributed Database Concepts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS