Question: . Users can be identified by their email-id. Other information stored for a user includes name, date of birth and address. Each user has a

 . Users can be identified by their email-id. Other information stored

. Users can be identified by their email-id. Other information stored for a user includes name, date of birth and address. Each user has a star rating (1-5) indicating trustwor- thiness . A user may choose to "follow other users Each user reviews one or more restaurants . A review contains scores for the following items: Ambiance, Food Quality, Service, Price and Overall Experience. Each score is on a discrete scale of 1 - 5 (5 denoting the largest score). Optional free text comments are also saved Each restaurant has a name and address. The same restaurant name can have multiple addresses. A restaurant belongs to exactly one of the following types: Ethnic, Fast food, Fast casual, Casual dining, Family style or Fine dining . A restaurant can serve multiple cuisines. Each user likes one or more cuisines . A restaurant accepts coupons. A coupon contains a coupon-code which is unique to a specific restaurant. The discount percentage and a specific date that the coupon is valid is stored. Users can have multiple coupons Hlow to proceed 1. Draw the ER (or EER) diagram for your system 2. Map the ER (or EER) model to a relational model

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!