Interview Query

Yelp-like System

Have you seen this question before?

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.

Next question: Flight Records
Loading comments