Yelp-like System

We want to build an application that allows anyone to review restaurants. This app should allow users to sign up, create a profile and leave reviews on restaurants if they wish. These reviews can include texts and images. A user can only write one review for a restaurant but can update their review.

Design the database schema that would support the application’s main functions. The schema should indicate the following:

• The table name
• The names of columns/fields
• The data type of each column/field
• A list of constraints on values (Primary or foreign keys)
• A short description of each column/field

Make sure to elaborate on how the tables join with each other.