Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In this assignment, you need to design a yelp business database. You will store some business information, ratings and reviews in this database. Later, you
In this assignment, you need to design a yelp business database. You will store some business information, ratings and reviews in this database. Later, you will use this database to build a recommendation system Requirement In this database, you have the following information: (I) A user has a unique ID, name and yelping_since (when the user joined Yelp, formatted (2) A business has a unique id, name. A business has at least one category. A business might (3) A category has a unique id and name. There are many categories: Mexican food like YYYY-MM-DD) have some photos of its food and environment. Burgers, Chinese food and so on (see full categories https://www.ye!pblog.com/201 8/01/yelp. Category list#section2) (4) A photo has a unique id, caption, and an PNG image. (5) A user can give a review to a business. Each review consists of a 5-star scale (I-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. (6) 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started