Reviews
review_id
user_id
course_id
review_text
rating
review_date
Users
user_id
username
email
password
Enrollments
user_id
course_id
enrolled_date
CourseCategory Assignments
course_id
category_id
Courses
course_id
title
description
Instructors
instructor_id
name
bio
Course Categories
instructor_id
category_id category_name
Figure 1. Given database diagram.
You are asked to build five APIs, as following:
1.1 The API at url/api/Instructor
using GET method.
Return all instructors along with the information of the courses each instructor teaches. The information of each course is the same as in the Figure below.
Zoom
+ 100%
Close
