Zombie Virus – Phase 3: The Cure

Phase 3 of the zombie apocalypse project marks a pivotal shift in humanity’s survival strategy — the introduction of a potential cure. With hope on the horizon, this phase focuses on analyzing the impact of the cure, distributed as a vaccine, on infection rates, survivor management, and city resilience. As the cure becomes available, it is critical to evaluate its efficacy and ensure its distribution is maximized to save as many lives as possible.

Training Video:

Overview

This phase introduces a new dimension of analysis centered around the rollout and impact of the cure. Data from cities, survivor camps, and infection statistics are combined to measure progress toward eradicating the infection and rebuilding communities.

The datasets simulate:

  • Cure Distribution: Vaccine rollout dates and their effect on infection trends.
  • Post-Cure Recovery: Infection decline and survivor camp dynamics after the vaccine is introduced.
  • City Resilience: How cities adapt to the new reality, focusing on their ability to reduce infections and manage survivors effectively.

Objectives

Phase 3 tasks are centered around evaluating the effectiveness of the cure and identifying opportunities to improve outcomes. The key objectives are:

  1. Assess the Impact of the Cure: Measure infection rate declines and determine how long it takes cities to achieve infection-free status.
  2. Analyze Recovery Trends: Understand survivor camp dynamics and resource availability as infections subside.
  3. Identify Resilient Cities: Evaluate and rank cities based on their ability to reduce infections, support survivors, and recover effectively.
  4. Provide Strategic Insights: Use data to recommend actions that optimize the distribution and efficacy of the cure.
SQL Premium Project: Zombie Phase 3

SQL Premium Project: Zombie Phase 3

Ask Tutor