VaccinationSystem-DB

This is the final project of the database course, which is an implementation of a vaccination system database using SQL. Three types of people, such as Doctors, Nurses and People are supported in this system with various capabilities.

Tables

The information of each user includes 2 parts: System info and User Info. The user info of all members is the same, but their personal info differs based on their rules. The information of health centers, the history of vaccination, the bard of vaccines and their vial should be recorded.

Mentioned items are ‌recognizeable by checking out the tables.

Users

The users need to sign up and create an account to be able to use this platform. The user type determines the user's access and operations.

Doctors' Operations

1. Adding New Brand
2. Adding New Health Center
3. Deleting Accounts

Nurses' Operations

There are four types of nurses: Matron, Supervisor, Nurse and Paramadic, and their responsibilities are based on their types.

1. Vial Creation: Metrons
2. Injection: All Four Types

People's Operations

Each member, such as people, doctors and nurses, should be able to

1. View Their Account Info
2. Change Their Password
3. Score
4. View the Score of Centers
5. View the Number of Vaccinated People of Each Brand
6. Vies the Top 3 Centers for Each Brand
7. Viewing the Possible Center for Their Second Doses