Question: Part 2: Draw ERD and place cardinalities (16 points) Groupon is a leading online platform providing consumers with deals from local merchants. Suppose the manager

Part 2: Draw ERD and place cardinalities (16 points) Groupon is a leading online platform providing consumers with deals from local merchants. Suppose the manager of the data center of Groupon wants to build a small database to store and manage information about Groupon's restaurant-related business. He is seeking your help with the design of the database. Here is detailed information: A restaurant has a number of attributes, including name, location (one restaurant has only one location), price range, and food types (a restaurant may have multiple food types). A restaurant can offer zero or multiple deals. A deal has the following attributes: deal name, start date, end date, discount rate, original price, and tipping point. A deal can be offered by one and only one restaurant. A customer can purchase one or more deals. For each purchase, the manager also wants to record the quantity of the deal that a customer has bought. A deal can be purchased by zero or many customers. A customer has the following attributes: name, gender, age, address, and email
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
