Designing The Database

Based off our research and discussion, we agreed that the main issues that medical personnel would face in vaccine distribution during an pandemic would be overcrowding of medical facilities, panic and chaos amongst the public, fake news and misinformation spread on the Internet and social media and lastly, a lack of awareness of where to collect the vaccine, which causes confusion amongst the public. These will cumulate into an extremely choatic situation that will be hard for the medical personnel to handle. Thus, we sought to create a web application, and later on a mobile application if we had the time, to tackle these issues.

We wanted to make of the ASP.NET framework, since we had experience using the framework in our previous semester, in our Web Application Development module. To complement the web application, Adwin and I had to work on the database.

For the database, I focused mainly on the conceptual design of the database, while Adwin focused more on the implementation of the SQL codes. Through the use of Visual Paradigm, a software development tool, I mapped out most of the database classes and their characteristics, for example if they were unique or nullable. When Adwin was implementing the database, we ran into some hiccups, which was expected when implementing a database of this size in one go. However, lucky for us, there were not much changes to be made, and after some final adjustments and addition of classes, our database was fully implemented and ready to go.

After implementing the database, we then had to implement the classes in the ASP.NET code itself. This was complicated as well, as we had to ensure that the code matches with the database. Furthermore, as the classes were very closely interlinked, we had to tread with care to ensure that the classes in the code were what we intended.