A web application with Crud functionality (create, read, update, and delete) for a student database

You are required to build a web application with CRUD functionality (create, read, update, and delete) for a student database.
All users should be able to browse the database via a website which should organised by the course enrolments for students. Only admin users should have permission to add, edit, or delete courses and students.


User access control:
• Users can view records
• Admin staff can make changes
• Access should not be granted without successful login
User interface/ front end website:
• Show the courses – a course can be selected to show students enrolled in that course
• Search for students by name or id
• Show the number of students in each course
• Implement admin functions.
The application should include client and server components with a database storing data:
1. The server should be a web API built using Nodejs and Express.


2. The client should be built using html, css, and javascript. Use the Fetch api to make calls to the server api endpoints.
3. Use an Azure SQL database for storage