ICT330: Database Management Systems Assignment, SUSS, Singapore Viruses have mutated and countries are sharing data to help control the spread of infection. For ease of communication
Viruses have mutated and countries are sharing data to help control the spread of infection. For ease of communication, when variants are discovered, they are given a unique label. The Pango lineages of different variants may overlap. The points of mutations in the genes for each variant are also recorded. Several variants have common mutation points, and it is useful to the scientific communities to know the variants that are similar to others.
A variant is given a classification when it becomes necessary, and the classifications are based on factors such as speed of transmission and the number of cases. The categories are as follows: variant being monitored, a variant of interest, a variant of concern, and the variant of high consequence.
When a country detects case(s) of the variant, the date(s) and patient biodata, identified by a running case number for that country are tracked. Patient biodata includes data such as nationality, gender, year of birth, vaccination history, as well as patient symptoms. Each symptom has a general description. For example, a low-grade fever is described as any temperature 99.5°F (37.5°C) and 100.3°F (38.3°C). The scientific communities note that there are cases of reinfection, possibly from the same or different variants, and these cases are of special interest.
For each country, record the population size as well as the percentage of the population that has been vaccinated. Cases are also defined as local primary, local secondary, or imported cases. Imported cases have a history of travel from an affected county 14 days before the onset of infection. The travel history of such cases must be recorded.
Construct a conceptual model from the statements of requirements to represent the data model, showing
- Entities, with entities named, relevant attributes, and identifier,
- Relationships with maximum and minimum cardinalities and relationship names.
Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
- ESG531 Circular Economy for a Sustainable Future Group-Based Assignment: Circular Transformation Roadmap for SMEs towards 2030
- Business Marketing Assignment: Showcasing Fresco Pizza Hub’s Competitive Advantage over MegaSlice Pizza
- ECE210 Advocacy and Collaborations with Families Assignment: Supporting Grieving Children Through Culturally Responsive and Family-Centred Practices
- ACC707 Accounting and Finance Assignment: Evaluating Investment Decisions, Budgeting Practices, and Financial Performance through Ratio Analysis
- NCO201 Learn to Learn, Learn for Life TMA01: Developing Self-Awareness and Strategies for Lifelong Learning
- PSS219 Public Safety and Security in Singapore Group-Based Assignment: Analyzing Ministry Strategies and Challenges from the 2025 Committee of Supply Debate
- MTH240 Engineering Mathematics I TMA: Applications of Linear Algebra in Engineering Problems and System Analysis
- Engaging Youth with IBM Skills Build Assignment: Developing Creative Approaches to Boost Skills and Career Prospects
- BUS368 Innovation Management and Digital Transformation Assignment: Managing Innovation and Uncertainty in Foldable, Trifold, and Stretchable Display Technologies
- BUS366 Assignment: Enhancing Process Efficiency and Recruitment Effectiveness through Lean Six Sigma Methodologies
UP TO 15 % DISCOUNT