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 System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
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 System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education