- The Application Is To Develop A Database System To Help A Non Profit Health Organization To Develop A System To Help Res 1 (63.89 KiB) Viewed 30 times
The application is to develop a database system to help a non-profit health organization to develop a system to help researchers, companies, and world population to keep track of the COVID-19 pandemic progress. The system is called Covid-19 Pandemic Progress System C19PPS. The system divides the world into six regions: Africa, Americas, Eastern Mediterranean, Europe, South-East Asia, and Western Pacific. Each region is composed of a set of countries. For each country, the system maintains information of the total number of populations of the country, the total number of people died from COVID-19 virus, the total number of people who got vaccinated by each type of vaccination, the total number of people who got infected by the COVID-19 virus and have never been vaccinated, for each type of vaccines the total number of people who got vaccinated by that type of vaccine and still got infected by COVID-19 virus, and for each type of vaccines the total number of people who got vaccinated by that type of vaccine and died because of the COVID-19 virus. The type of vaccinations could be Pfizer, Moderna, AstraZeneca, Johnson & Johnson, etc. People from all over the world can use the system to view information related to the progress of COVID-19 in the world. Users of the system could be either administrators, researchers, organization's delegate, or regular people. Users with administrators' privileges can add/delete/edit any user to the system. Users with researchers's privileges can add/delete/edit articles to the system that other users can see and profit from the researcher's findings. Users with organization delegate privileges can add/delete/edit articles for their organization to the system. Administrator users have the privilege to remove any article from the system or suspend any account in the system.
Each article in the system is identified by its author, major topic, minor topic, summary, the article itself, and the date of publication of the article. The summary of each article should not exceed one hundred characters. The author could be either a researcher's first name and last name, or the organization's name. An organization could be either a
company, a research center, or a government agency. Each country has one government agency that uses the system to provide their latest details about the progress of the COVID-19 in the country. Each government agency can add/delete/edit information related to the country alone and not records related to other countries. The historical records of the updates of the progress of COVID-19 are maintained by the system. Each time a new update is provided, the date of the update is recorded with the new record. All users of C19PPS are identified by their first name, last name, citizenship, email address, and phone number. The citizenship value must be a value of a country that already exist in the system.
1. Express the COVID-19 Pandemic Progress System in the E/R model. Use arrows to indicate the constraints on the relationships. Underline the key attributes for the entity and relationship sets. 2. Convert the E/R diagram into at least six relations: Region, Country, User, Organization Researcher, Article. Other relations might be needed to capture all the requirements.