MySQL & APIs

The purpose of this assignment is to create SQL queries to support functional requirements, create a business logic layer to have API for each functional requirement using NodeJS, test and demonstrate results using Postman, and practice remote database connection and role$-$based access control.

Based on the college scenario from the previous practical assignment, you will be provided with a MySQL database, dummy data and design documents $($including function requirements$).$ Your group is expected to develop SQL queries and APIs to address the functional requirements and demonstrate the functionalities.

Here are the steps:

Create SQL queries needed to support functional requirements.

Install NodeJS and all the required packages, including $$mysql$2($not mysql$)$ and $$express$$ packages.

Install postman application.

Write a NodeJS and Express application to connect to the database.

Add APIs to $($D$)$ to support functional requirements. $($For API coding, following the instructions here: Express "Hello World" example $($expressjs$.$com$)$

Find a way to restrict access for some actions that need to be performed by a role. For example, some actions such as assigning a course to a teacher are performed by college staffs, pass and fail decisions are done by teachers.

Test and demonstrate results of executing your APIs using Postman application: