Examination System

A web application that generates exams for students and save their grades

Table of Contents

• Examination System
  • Table of Contents
  • About The Project
    • Built With
  • Getting Started
    • Prerequisites
    • Installation
  • Usage
  • Contributors

About The Project

This is a Nodejs Project connected with a sql server database. It is made for sql server course as a project.

During the pandamic every university or educational place had and still has to have an online examination system for their students to make their exams in it.

• Every student has an exam have to open the system and start his/her exam and the grade is calculated after the exam ends so the student can know the grade through his/her account in this course or subject.

• Every instructor can discover his/her student's grade in his/her courses

• If you are student you will go to your pages as a student and if you are instructor you will go to your own pages in the system

(back to top)

Built With

This application built with node js and uses sql server database to run.

• Nodejs
• EJS
• Bootstrap

(back to top)

Getting Started

How to set the project locally?

Prerequisites

• Nodejs

  npm install npm@latest -g

• Sql Server

Installation

1. Clone the repository

git clone git@github.com:RandaHadad/Database-Project

2. Restore the database backup to your local machine and set a user for the database as a database owner to configure with the web application

1. Go to Nodejs Folder in the application

cd Nodejs

4. Install NPM packages

npm install

5. Go to dbConfig js file to write your sql server database configurations

const config = {
    server: 'localhost',
    authentication: {
        type: 'default',
        options: {
            userName: 'ExaminationUser', // update me
            password: 'pass' // update me
        }
    },
    options: {
        database: 'Exam_System', // update me
        validateBulkLoadParameters: false,
        encrypt: false,
    }
};

(back to top)

Usage

1. Write this command to run the project

 npm start

2. Go to your browser and write localhost:8080 to run the project

(back to top)

Contributors

Thanks for you all

• Alaa Maher
• Amr Elauoty
• Eslam Aboalela
• Mohamed Najeeb
• Randa Hadad

(back to top)