A project for principle of database management at HCMIU.

• This is a simple web allows patients to view their personal profolio and make an appoiment with doctors.
• Beisde patients we also have pages for doctors, staffs and nurses.

Team members

Order	Name	Task	Contribution
1	Nguyen Manh Viet Khoi	Fullstack, UI Designer, Project scheduling, Login Authorization, git	30
2	Hồ Gia Khang	Fullstack, UI Designer, Login Authentication	30
3	Phạm Gia Khang	Backend, Data Standardization, Debugger,Database designer, Write reports	20
4	Nguyễn Tiến Hưng	Backend	20
5	Ngô Đức Huy	N/A	0

Tech Stack

• Back-end: Spring Boot, Spring Data JPA, RESTful API
• Front-end: Reactjs, Bootstrap
• Database Management System: PostgreSQL

Features

Basic feature

• Sign in: User can sign in with their username and password if they have an existing account.
• Register: User registers for a new username and password, add basic information like phone number, address.
• Edit user information: User can edit their username and other information on their profile.

Patients

• Make an appointment: Patients cant make and appointment with doctos.

Doctors

• View appoinment: Doctors can view appointments in the future.

Staffs

• View rooms: Staffs can view status of rooms.
• Add rooms: Staffs can add new rooms.

Nurses

• View rooms: Nurces can view which rooms to serve.

Diagrams

ER Diagram

Figure 1: ERD diagram for the Department, Doctor, Nurse, Staff, Room, Patient relationship.

Relational model

Figure 2: Relational model of the Department, Doctor, Nurse, Staff, Room, Patient relationship.

How to run the project

1. Clone the project

git clone https://github.com/tpSpace/Hospital-DBMS

2. Setup your PostgresSQL database

• Download PostgresSQL https://www.postgresql.org/download/
• Create /backend/src/main/resources/.env file for username and password to connect to DB.
• Login to psql and create the databse before we run the backend.

CREATE DATABASE hospital;

3. Run backend

• Install openJDK 17
• Recommend to use Intelij to run the project.

4. Run frontend

• Install nodejs 16
• Install npm and run npm i to install necessary dependencies.
• Type npm to run the project.