Student Database Management

This repository contains a student database management system, where you can store, manage, and retrieve information about students. The system is built using NodeJS, ExpressJS, ejs engine, css, and MySQL with a focus on using the Model-View-Controller (MVC) design pattern.

Features for admins

Store and manage student data
Add, edit, and delete students
Retrieve information about students
Filter students based on different criteria

Features for students

Can edit their profiles' information
Can add their courses
Can store notes in their courses

Prerequisites

NodeJS
ExpressJS
ejs engine
HTML
CSS
MySQL

Project Details

You can see Project Photos of its pages

You can see Project Structure for this project files

Getting Started

Clone the repository to your local machine.

   git clone https://github.com/shawkyebrahim2514/Student-Database-Management

Install the required dependencies.

   npm install

Access the application by navigating to http://localhost:3000 in your web browser.

Database Design

You can see Database Scheme for this project

You can see Database Quiries that used in this project

Generate fake students for test

You can use Faker.js to generate fake students to test this project

You can see Fake Students that used in this project