Backend.md

Backend assignment (nodeJS)

Problem Statement:

Your task is to build a Library Management System, which has the following features:

• A client portal and an admin portal (should include authentication and authorization).
• Admins can list the books available in the library, update that list and approve/deny checkout/check-in requests made by the clients.
• Clients can view the list of books and request admin to checkout/check-in particular books.
• Clients should be able to see the checked out books against their account.
• Passwords should be hashed before storing in the database.

Bonus Points:

• Read about and implement methods to prevent SQL injection.

Here are some resources below for further reading:

• MySQL:

  • https://www.mysqltutorial.org/mysql-nodejs/
  • https://www.tutorialspoint.com/mysql/index.htm
  • https://www.w3schools.com/sql/

• ExpressJS:

  • https://expressjs.com/en/starter/installing.html

• Hashing:

  • https://auth0.com/blog/hashing-passwords-one-way-road-to-security/