bhavyaagg/Hostel-Management-DBMS-Project

Hostel Management System

A system to manage the infrastructure and students of a hostel

Development

Clone the repository

Make sure to have the latest version of node and npm installed

git clone https://github.com/bhavyaagg/Hostel-Management-DBMS-Project
cd Hostel-Management-DBMS-Project
npm install

Setting up the database

Make sure to have postgres installed(postgresql 96 preferable) and the server is started

psql
create database hosteldb;
create user hosteluser with encrypted password 'hostelpass';
grant all privileges on database hosteldb to hosteluser;
grant all on SCHEMA public to hosteluser;
grant usage on SCHEMA public to hosteluser;

> To login as the hosteluser

```bash
psql -d  hosteldb -U hosteluser

Run the app

npm start

Server will start running on http://localhost:8888