A patient-to-doctor web portal 💉

Contributors • Overview • How To Use • Language and Tools • Tables • Flowchart • Relational Table and UML • Progress Report

Contributors

This is a database management system final project made by group B2 :

• Muhammad Suhaili - 2106731535
• Zulfikar Hadzalic - 2106636224
• Shabrina Kamiliya Wiyana - 2106733894

as undergraduates of Computer Engineering Major, Department of Electrical Engineering, Faculty of Engineering, Universitas Indonesia.

Overview

This website is a platform that provides patients being able to make online appointments with specialized doctors. There are three main roles that could be taken as : an admin, a patient, or doctor. Each of them has their own features and actions on this

😷 Here's what we provide for patients:

• Register their accounts and login using them.
• Make appointments according to the doctors schedule and their respective department.
• Review their appointments based on their doctors decision that has the following status: PENDING, ACCEPTED, and REJECTED.

👨‍⚕️ Here's what we provide for doctors:

• Register their accounts and login using them.
• Make a schedule where they would be available to serve patients.
• Review patients appointment and have the decision to accept or reject their appointment.

🏥 Here's what we provide for admins:

• Having full control/CRUD operations for doctors' departments.
• View all doctors and patients lists.

How To Use

1. Clone the repo in the terminal to your local directory

git clone https://github.com/SistemBasisData2023/DocConnect

2. Install the dependencies

npm install

3. Run the server at localhost:5000 on your local browser

npm run server

4. Open localhost:5000/views/login to proceed to the login page

Postman Documentation and Examples

Language and Tools

Tables

1. Patients

This table is used to store patient information when registering on the website.

1. Patient_ID
2. Name
3. Phone Number
4. Address
5. Gender
6. Account_ID

2. Doctors

This table is used to store doctor information when registering on the website.

1. Doctors_ID
2. Account_ID
3. Department_ID
4. Name
5. NIP
6. Phone Number
7. Gender

3. Account

This table is used to store doctors and patients account information.

1. Account_ID
2. Email
3. Password
4. Role

4. Appointment

This table is used to store appointment information when patients make appointments.

1. Appointment_ID
2. Patient_ID
3. Schedule_ID
4. Description
5. Status

5. Schedule

This table is used to store schedule information when doctors input their schedule.

1. Schedule_ID
2. Doctor_ID
3. Date
4. Time

6. Department

This table is used to store departments name and their ID.

1. Department_ID
2. Department_Name

Flowchart

Click to view

Flowchart

---

Relational Table and UML

Click to view

UML

Relational Table

Progress Report

Click to view

Progress Report

• First Report (Click thumbnail below):

https://youtu.be/ZUChd-FVUlU

• Second Report (Click thumbnail below):

https://youtu.be/bN1Se6Y4qYA