Objective

To develop a comprehensive COVID Vaccination Management System to that streamlines appointment scheduling for users and enables administrators to efficiently manage vaccine doses and centers.

Motivation

The motivation behind the COVID Vaccination Management System project is to address the urgent need for a streamlined and efficient solution in the face of the global pandemic. By developing a user-friendly platform for scheduling vaccination appointments, the project aims to alleviate the burden on individuals seeking vaccination and ensure smoother administration for healthcare providers. Additionally, providing administrators with tools to manage vaccine doses and centers efficiently enhances overall vaccine distribution efforts.

Skills: SQL, HTML, JS, BootStrap, PHP

Features

Users:

  • Create a profile: The user will be able to create a profile storing detailed information such as name, age, phone number, email id, adhaar card number.
  • Login into profile: The user can login into his/her profile using name and password. The user will be able to see the information on the dashboard and will also be able to book an appointment.
  • Selection of the vaccination centre: Vaccination centre can be selected using the user’s pincode priority.
  • Book an appointment: Appointments can be booked at the selected centre instantly.

Administrators:

  • Login to administrator profile: The admin can login into his/her profile using name and password.
  • Update the vaccination status of the user: The admin can update the vaccination status after the completion of dose.
  • Update the vaccination quantity: The admin can update the quantity of vaccines available at the centres.

Methododlogy

  1. Database Design: Designed the database schema using SQL to store and manage vaccination-related data efficiently. This included creating tables for patients profile, vaccination centers, appointments, and vaccine inventory.

  2. Data Modeling: Developed an entity-relationship diagram (ERD) to visualize the relationships between different entities in the database schema.

    ER Diagram:

    ER Diagram

    Relational Diagram: Relational Diagram

  3. Database Implementation: Implemented the database schema using SQL to create tables, define relationships, and enforce constraints such as primary keys, foreign keys, and unique constraints. This step involved writing SQL scripts to create, modify, and manage the database structure.

  4. Frontend Development: Developed the user interface using HTML, CSS, and Bootstrap to create a responsive and visually appealing web application. This involved designing web pages for user registration, appointment scheduling, vaccination center search, and vaccination records management.

  5. Backend Development: Implemented the backend functionality using PHP to handle user requests, interact with the database, and perform business logic operations. This included developing PHP scripts to process form submissions, validate user inputs, and execute SQL queries.

  6. Integration: Integrated the frontend and backend components to create a seamless user experience. This involved linking frontend web pages to backend PHP scripts using form submissions, AJAX requests, and session management techniques.

  7. Testing: Conducted rigorous testing to ensure the functionality, reliability, and security of the COVID Vaccination Management System.

Results

userSignup

appointmentBooking

adminLogin

manageVaccines

ManageCentres

patientStatusUpdate