Student Enquiry Database Management System

This Student Enquiry Database Management System is an web application integrated with Oracle sql plus and currently working on ejs for the frontend and node for the backend.
The connection string to connect the app to Sql database is configured in the app.js file.
The username and password used in the Passport.js for the login system is stored in the app.js with its functions in passport.js file which is imported in app.js.

Server based on localhost with port number 1001 which can be changed accordingly in app.js

Screenshots -

Login Page:

Welcome Page:

Data Representation:

Add new student:

Edit existing student data:

Edit Page:

Filters:

Dependecies in the app.js :

• "body-parser": "^1.19.0",
• "connect-flash": "^0.1.1",
• "ejs": "^3.0.1",
• "express": "^4.17.1",
• "express-flash": "0.0.2",
• "express-session": "^1.17.1",
• "express-validator": "^6.4.0",
• "method-override": "^3.0.0",
• "oracledb": "^4.2.0",
• "passport": "^0.4.1",
• "passport-local": "^1.0.0"
• "nodemon": "^2.0.3"

TO START THE SERVER TYPE "npm run devStart" IN THE TERMINAL.