Database Design Report: COVID Vaccine Research at Uxbridge University

This report provides a detailed analysis of a proposed database system for the Uxbridge University's COVID vaccine research project. The introduction outlines the context, including the development of vaccines for different COVID variants and the challenges of managing clinical trial data. The main body delves into the assumptions, business rules, stakeholder analysis (including researchers, project managers, and regulatory bodies like MHRA), and functional requirements for the database. It identifies key functionalities such as vaccine development tracking, clinical trial management, and data collection related to volunteers. The report also includes an Entity-Relationship (ER) diagram and model documentation to illustrate the database structure, detailing entities such as clinical trials, publications, and participants, along with their attributes and relationships. The conclusion summarizes the key findings and the importance of the database for streamlining vaccine development. The report emphasizes the need for a robust system to manage the complexities of clinical trials, research publications, and participant data, ensuring efficient data retrieval and analysis for researchers and other stakeholders. The database aims to improve the recording and management of vaccine development processes, allowing for better access to information that supports the alignment of the vaccine development process.