Web app and DBMS

AHS vaccination service

Web app and DBMS

AHS vaccination service

Web app and DBMS

AHS vaccination service

Appointment update screen
Appointment update screen

The Challenge


A database management system (DBMS) is designed to store and retrieve data efficiently for organizations. During the pandemic, my group and I created a database project to improve Canada's vaccine rollout, which had been criticized for being slow. The database connected different parties involved in the vaccination process, including labs with vaccines and testing kits, to increase efficiency. The challenge was to balance the sharing of information without compromising personal privacy. The project aimed to include all entities involved in the system while ensuring that no one had excessive power.

DBMS tree
DBMS tree
DBMS tree

The Solution


A database management system was developed to connect parties working to end the pandemic and keep them updated on their progress. The database speeds up the process for patients, the Alberta government, and vaccination and testing centers. In addition to efficiency, safety and privacy were also a top priority during development. The database stores data securely and avoids sharing unnecessary personal information. Existing data is updated to prevent duplication. The system's data storage capabilities also enable analytics to improve the situation.


Skills Applied:


• SQL • API • HTML/CSS • JavaScript • Postman

  • Project relational model
  • Project relational model
  • Project relational model

The Result


The projects highlight the power of database management systems in facilitating pandemic response efforts. By connecting all relevant parties, including labs, testing centers, and government agencies, databases can improve the speed and efficiency of the response effort. They can also enable analytics to take proper measures to improve the situation.


Overall, the results of these projects show that well-designed database management systems can play a crucial role in pandemic response efforts. By keeping all relevant parties connected and informed, these systems can help to accelerate the response and ensure that accurate data is available to all stakeholders.

Discover more projects ↆ

Appointment update screen
Appointment update screen
Calgary Transit app model
Penalty kick stats
Coffee-chat landing page

Discover more projects ↆ

Appointment update screen
Appointment update screen
Calgary Transit app model
Penalty kick stats
Coffee-chat landing page

Discover more projects ↆ

Appointment update screen
Appointment update screen
Calgary Transit app model
Penalty kick stats
Coffee-chat landing page

LET'S WORK TOGETHER

Feel free to get in touch with me.

LET'S WORK TOGETHER

Feel free to get in touch with me.

LET'S WORK TOGETHER

Feel free to get in touch with me.