COVID-19 TRACKER One Of Your Uncle Who's Working Under Department Of Health Learned That You've Taking Up Programming Class. That's Why You've Been Asked If It Would Be Possible For You To Replicate Their Current COVID Tracker. This Is His Small Step To Check Whether You Can Help Him On Creating An Automated Data Analytics. Develop A Program That Will COVID-19 TRACKER One of your uncle who's working under Department of Health learned that you've taking up programming class. That's why you've been asked if it would be possible for you to replicate their current COVID tracker. This is his small step to check whether you can help him on creating an automated data analytics. Develop a program that will replicate the COVID19 Tracker by DOH You are provided with the official August 4 Data from DOH in csv format (csv is discussed on the next subsection) On the said spreadsheet, Your program should be able to do the ff analytics: Total Number of Cases: (a) Confirmed, (b) Active, (c) Recovered, (d) Death Total Confirmed Cases by Region Total Confirmed Cases by Region and Published Date Total Confirmed Cases by Age Group Sample Console Input    Expected Console Output 1 5    Analysis Options: 1. Total Confirmed Case 2. Total Case By Region 3. Total Case on Region by Publish Date 4. Total Death by Age Group 5. Exit Choice: 1 Confirmed: 112593, Active: 44429, Recovered: 66049, Died: 2115 Choice: 5 2 NCR 5    Analysis Options: 1. Total Confirmed Case 2. Total Case By Region 3. Total Case on Region by Publish Date 4. Total Death by Age Group 5. Exit Choice: 1 Type Region: NCR Total count on NCR is 59805 Choice: 5 2 Region VII 5    Analysis Options: 1. Total Confirmed Case 2. Total Case By Region 3. Total Case on Region by Publish Date 4. Total Death by Age Group 5. Exit Choice: 1 Type Region: Region VII Total count on Region VII is 0 Choice: 5 2 Region VII: Central Visayas 5    Analysis Options: 1. Total Confirmed Case 2. Total Case By Region 3. Total Case on Region by Publish Date 4. Total Death by Age Group 5. Exit Choice: 1 Type Region: Region VII: Central Visayas Total count on Region VII: Central Visayas is 16954 Choice: 5 3 NCR 2020-08-04 5    Analysis Options: 1. Total Confirmed Case 2. Total Case By Region 3. Total Case on Region by Publish Date 4. Total Death by Age Group 5. Exit Choice: 3 Type Region: NCR Type Date[YYYY-MM-DD]: 2020-08-04 Total count on NCR published on 2020-08-04 is 3139 Choice: 5 3 NCR 2019-06-05 5    Analysis Options: 1. Total Confirmed Case 2. Total Case By Region 3. Total Case on Region by Publish Date 4. Total Death by Age Group 5. Exit Choice: 3 Type Region: NCR Type Date[YYYY-MM-DD]: 2019-06-05 Total count on NCR published on 2019-06-05 is 0 Choice: 5 4 60 to 64 5    Analysis Options: 1. Total Confirmed Case 2. Total Case By Region 3. Total Case on Region by Publish Date 4. Total Death by Age Group 5. Exit Choice: 4 Enter Age Group (e.g. 50 to 54): 60 to 64 Total count for agegroup 60 to 64 is 289 Choice: 5 4 60 to 74 5    Analysis Options: 1. Total Confirmed Case 2. Total Case By Region 3. Total Case on Region by Publish Date 4. Total Death by Age Group 5. Exit

Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter4: Entity Relationship (er) Modeling
Section: Chapter Questions
Problem 7P
icon
Related questions
Question

COVID-19 TRACKER One Of Your Uncle Who's Working Under Department Of Health Learned That You've Taking Up Programming Class. That's Why You've Been Asked If It Would Be Possible For You To Replicate Their Current COVID Tracker. This Is His Small Step To Check Whether You Can Help Him On Creating An Automated Data Analytics. Develop A Program That Will
COVID-19 TRACKER

One of your uncle who's working under Department of Health learned that you've taking up programming class. That's why you've been asked if it would be possible for you to replicate their current COVID tracker. This is his small step to check whether you can help him on creating an automated data analytics.

Develop a program that will replicate the COVID19 Tracker by DOH

You are provided with the official August 4 Data from DOH in csv format (csv is discussed on the next subsection) On the said spreadsheet, Your program should be able to do the ff analytics:

Total Number of Cases: (a) Confirmed, (b) Active, (c) Recovered, (d) Death
Total Confirmed Cases by Region
Total Confirmed Cases by Region and Published Date
Total Confirmed Cases by Age Group
Sample Console Input    Expected Console Output
1
5    Analysis Options:
1. Total Confirmed Case
2. Total Case By Region
3. Total Case on Region by Publish Date
4. Total Death by Age Group
5. Exit
Choice: 1
Confirmed: 112593, Active: 44429, Recovered: 66049, Died: 2115
Choice: 5
2
NCR
5    Analysis Options:
1. Total Confirmed Case
2. Total Case By Region
3. Total Case on Region by Publish Date
4. Total Death by Age Group
5. Exit
Choice: 1
Type Region: NCR
Total count on NCR is 59805
Choice: 5
2
Region VII
5    Analysis Options:
1. Total Confirmed Case
2. Total Case By Region
3. Total Case on Region by Publish Date
4. Total Death by Age Group
5. Exit
Choice: 1
Type Region: Region VII
Total count on Region VII is 0
Choice: 5
2
Region VII: Central Visayas
5    Analysis Options:
1. Total Confirmed Case
2. Total Case By Region
3. Total Case on Region by Publish Date
4. Total Death by Age Group
5. Exit
Choice: 1
Type Region: Region VII: Central Visayas
Total count on Region VII: Central Visayas is 16954
Choice: 5
3
NCR
2020-08-04
5    Analysis Options:
1. Total Confirmed Case
2. Total Case By Region
3. Total Case on Region by Publish Date
4. Total Death by Age Group
5. Exit
Choice: 3
Type Region: NCR
Type Date[YYYY-MM-DD]: 2020-08-04
Total count on NCR published on 2020-08-04 is 3139
Choice: 5
3
NCR
2019-06-05
5    Analysis Options:
1. Total Confirmed Case
2. Total Case By Region
3. Total Case on Region by Publish Date
4. Total Death by Age Group
5. Exit
Choice: 3
Type Region: NCR
Type Date[YYYY-MM-DD]: 2019-06-05
Total count on NCR published on 2019-06-05 is 0
Choice: 5
4
60 to 64
5    Analysis Options:
1. Total Confirmed Case
2. Total Case By Region
3. Total Case on Region by Publish Date
4. Total Death by Age Group
5. Exit
Choice: 4
Enter Age Group (e.g. 50 to 54): 60 to 64
Total count for agegroup 60 to 64 is 289
Choice: 5
4
60 to 74
5    Analysis Options:
1. Total Confirmed Case
2. Total Case By Region
3. Total Case on Region by Publish Date
4. Total Death by Age Group
5. Exit

 

Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Database Environment
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning