Requirement

In this database, you have the following information:

• A user has a unique ID, name and yelping_since (when the user joined Yelp, formatted like YYYY-MM-DD)
• A business has a unique id, name. A business has at least one category. A business might have some photos of its food and environment.
• A category has a unique id and name. There are many categories: Mexican food, Burgers, Chinese food and so on (see full categories https://www.yelpblog.com/2018/01/yelp_category_list#section2)
• A photo has a unique id, caption, and an PNG image.
• A user can give a review to a business. Each review consists of a 5-star scale (1-5) rating and a textual description. For instance, User (ID 4) gave 4 stars to a restaurant Taco bell and said, Great place to hang out after work, the prices are decent. A user can only review a business once. The database needs to store each review operation: who gave such a review to whom, when.
• A user can write a tip to a business (similar to tag). A user can give tips to a business multiple time. Each tip consists of a short phrase. For instance, User (ID 20) gave long waiting time tip to a restaurant Pita Jungle. Two days later, he added a new tip secret menu to the same restaurant. The database needs to store each tip operation: who gave such a tip to whom, when.

Additional Information:

1. Please pay attention to attribute names and corresponding notations for every attribute E.g., the Primary key must have an underline.
2. Identify participation constraints as per the given instructions.
3. Naming configuration for entity set (Users, Business etc), relationship set and attributes is flexible as long as they fulfill the requirements and make sense. Identify entity, relationship and attributes as per the instructions.
4. Read requirements carefully to understand the differentiation in binary and ternary relationship
5. The points will be deducted if you miss any notation (e.g., primary key, total participation etc.) related to ER diagram.
6. Try to stick to the given information in the Requirement section as much as possible.
7. You are free to use any software, such as PowerPoint, to draw figures if you follow the format we discussed in class. Do not submit handwritten/hand-drawn assignments.
8. You can find some helpful explanations from Yelp official doc (Links to an external site.), but you need to follow the instruction of this assignment.