a) Draw an Entity-Relationship Diagram (ERD) for the above scenario using the Crow’s Foot notation (exclude all attributes). Resolve many-to-many relationships, if any. Make common business rule assumption if necessary.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 foreignkey with an *. Question 2Consider 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 foodstalls and consumers. The company receives customers' order via mobile app and redirects the orders totheir partner food stalls for preparation. When the foods are ready, the company deliverymen will deliveryto respective customers within an estimated timeframe.For every order placement, user must provide the shipment address and particulars of the order. Each ordertransaction can include one or more menu items. The ORDER entity consists of attributesOrderCode(Identifier), OrderDateTime, ShipmentAddress, EstimaTime, CustPhoneNo and TotalCharge,while MENU_ITEM entity consists of attributes ItemCode(identifier), Desc, UnitPrice , Category andRatings. 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 wouldnot have the same identifier as they are provided by two distinct food stalls. Each food stall may cater oneor 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.

The given is a set of details that are to be stored for designing the data model of food and…

Answered: ibutes). Resolve many-to-many…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

a) Draw an Entity-Relationship Diagram (ERD) for the above scenario using the Crow’s Foot notation (exclude all attributes). Resolve many-to-many relationships, if any. Make common business rule assumption if necessary.

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 *.