Q2.1: Propose an algorithm? « NbDesastreClim » to count the number of "Climatological" type disasters indicated in "Feuill". The result should be written on Feuil2, line 4, column 2. You can use the "for" loop (since you know the total number of disasters).

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
We often hear on television that natural disasters are more numerous and more severe every year because of
global warming. In the following, we propose to analyse data available on the Emergency Events Database
(EM-DAT) to check whether this claim is plausible.
The EM-DAT website provides data on natural, technological and complex disasters since 1900. The data can
be accessed free of charge by creating an account. We have done this for you. On March the 26th, we retrieved
the data on natural disasters since 1900 and simplified the file (by removing columns, but not rows).
On the first tab of the file ('Feuill’), you will find from line 8, the characteristics of each recorded disaster: an
identification number (column 1), the year (column 2), the nature of the disaster (columns 3, 4 and 5), the
location (columns 6, 7 and 8) and the number of deaths resulting from the disaster (column 9).
data - Excel
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Developer
Help
O Tell me what you want to do
X Cut
- 11
-A A
ab Wrap Text
General
Calibri
Normal
à Copy
$ - % ,
Conditional Format as Good
Paste
BIU.
A.
E Merge & Center
+0 .00
00 +0
* Format Painter
Formatting · Table -
Clipboard
Font
Alignment
Number
Styles
C13
fx
Climatological
A
D
F
K
M
P
1 Source:
EM-DAT, CRED / UCLouvain, Brussels, Belgium
www.emdat.be (D. Guha-Sapir)
3/26/2021
2
3 Version:
4 File creation
5 Table type
6 Hof records:
Custom request
15852
Disaster Type Disaster Subt Country
7 Dis No
8 1900-0006-JAM
9 1900-0007-JAM
Disaster Subgroup
1900 Hydrological
1900 Biological
Year
Region
Continent
Total Deaths
Flood
Jamaica
Caribbean
Americas
300
Epidemic
Viral disease lamaica
Caribbean
Eastern Asia
Western Asia
Americas
30
1900 Geophysical
1900 Geophysical
10 1900-0008-IPN
Volcanic activ Ash fll
Japan
Asia
30
11 1900-0009-TUR
Earthquake Ground move Turkey
Asia
140
1900 Meteorological
1900 Climatological
1900 Climatological
Tropical cyclo United States Northern America
Drought
12 1900-0003-USA
Storm
Drought
Drought
Earthquake Tsunami
Americas
6000
13 1900-0002-CPV
14 1900-9001-IND
Cabo Verde Western Africa
Africa
11000
Drought
India
Southern Asia
Asia
1250000
15 1901-0004-JPN
1901 Geophysical
Japan
Eastern Asia
Asia
18
1901 Biological
1902 Geophysical
1902 Geophysical
1902 Geophysical
16 1901-0001-UGA
Eastern Africa
Africa
Epidemic
Earthquake Ground move Azerbaijan Western Asia
Uganda
200000
17 1902-0013-AZE
Asia
86
18 1902-0003-GTM
Volcanic activ Ash fall
Guatemala Central America
Americas
1000
19 1902-0012-GTM
Earthquake Ground move Guatemala Central America
Americas
2000
20 1902-0005 MMR
1902 Meteorological
1902 Geophysical
Storm
Tropical cyclo Myanmar South-Eastern Asia
Saint Vincent Caribbean
Asia
600
21 1902-0007-VCT
Volcanic activ Ash fall
Americas
1565
22 1902-0006-MTQ
Martinique Caribbean
1902 Geophysical
1902 Geophysical
1902 Geophysical
1902 Geophysical
1902 Geophysical
1903 Geophysical
1903 Geophysical
1903 Geophysical
1903 Geophysical
Volcanic activ Ash fall
Americas
Asia
Asia
Americas
30000
Earthquake Ground move China
Volcanic activ Ash fall
23 1902-0014-CHN
Eastern Asia
2500
24 1902-0008-IPN
Japan
Eastern Asia
125
25 1902-0010-GTM
Volcanic activ Ash fall
Guatemala Central America
6000
26 1902-0011-SUN
Earthquake Ground move Soviet Union Russian Federation
Earthquake Ground move israel
Earthquake Ground move Turkey
Mass movem Rockfall
Europe
4562
27 1903-0014-ISR
Western Asia
Asia
20
Western Asia
Northern America
28 1903-0013-TUR
Asia
1700
29 1903-0006-CAN
Canada
Americas
76
30 1903-0007-TUR
Earthquake Ground move Turkey
Western Asia
Asia
3560
1903 Geophysical
1903 Meteorological
1903 Geophysical
1903 Geophysical
1903 Climatological
31 1903-0015-TUR
Earthquake Ground move Turkey
Western Asia
Asia
1000
32 1903-0008-IAM
Storm
Tropical cyclo lamaica
Caribbean
Americas
65
33 1903-0016-IRN
Earthquake Ground move Iran (Islamic ISouthern Asia
Asia
350
Volcanic activ Ash fall
Drought
Comoros (the Eastern Africa
Niger (the) Western Africa
34 1903-0012-COM
Africa
17
35 1903-9001-NER
Drought
Africa
36 1903-0010-USA
1903 Meteorological
1903 Hydrological
1903 Hydrological
1904 Geophysical
Storm
Convective stUnited States Northern America
Americas
98
37 1903-0002-USA
Flood
United States Northern America
Americas
38 1903-0003-USA
Flood
United States Northern America
Americas
250
39 1904-0007-TWN
40 1904-0008-GRC
Asia
Earthquake Ground move Taiwan (Prov Eastern Asia
Southern Europe
3
1904 Geophysical
1904 Geophysical
Earthquake Ground move Greece
Europe
4
Earthquake Ground move Taiwan (Prov Eastern Asia
Tropical cyclo Bangladesh Southern Asia
41 1904-0009-TWN
Asia
145
1904 Meteorological
1905 Geophysical
42 1904-0003-BGD
Storm
Asia
43 1905-0003-IND
Earthquake Ground move India
Southern Asia
Asia
20000
44 1905-000s-ALB
1905 Geophysical
1905 Geophysical
1905 Geophysical
1905 Geophysical
1905 Meteorological
1905 Geophysical
Southern Europe
Eastern Asia
Northern America
Earthquake Ground move Albania
Europe
120
45 1905-0009-IPN
Earthquake Ground move Japan
Asia
11
45 1905-0005-CAN
Mass movem Rockfall Canada
Americas
18
47 1905-0001-ITA
Earthquake Ground move Italy
Southern Europe
Tropical cyclo Philippines (tSouth-Eastern Asia
Europe
557
48 1905-0004-PHL
Storm
Asia
240
49 1905-0010-CHN
--------
Earthquake Ground move China
Eastern Asia
Asia
Feuil1 Feuil2 Feuil3
+
Transcribed Image Text:We often hear on television that natural disasters are more numerous and more severe every year because of global warming. In the following, we propose to analyse data available on the Emergency Events Database (EM-DAT) to check whether this claim is plausible. The EM-DAT website provides data on natural, technological and complex disasters since 1900. The data can be accessed free of charge by creating an account. We have done this for you. On March the 26th, we retrieved the data on natural disasters since 1900 and simplified the file (by removing columns, but not rows). On the first tab of the file ('Feuill’), you will find from line 8, the characteristics of each recorded disaster: an identification number (column 1), the year (column 2), the nature of the disaster (columns 3, 4 and 5), the location (columns 6, 7 and 8) and the number of deaths resulting from the disaster (column 9). data - Excel File Home Insert Draw Page Layout Formulas Data Review View Developer Help O Tell me what you want to do X Cut - 11 -A A ab Wrap Text General Calibri Normal à Copy $ - % , Conditional Format as Good Paste BIU. A. E Merge & Center +0 .00 00 +0 * Format Painter Formatting · Table - Clipboard Font Alignment Number Styles C13 fx Climatological A D F K M P 1 Source: EM-DAT, CRED / UCLouvain, Brussels, Belgium www.emdat.be (D. Guha-Sapir) 3/26/2021 2 3 Version: 4 File creation 5 Table type 6 Hof records: Custom request 15852 Disaster Type Disaster Subt Country 7 Dis No 8 1900-0006-JAM 9 1900-0007-JAM Disaster Subgroup 1900 Hydrological 1900 Biological Year Region Continent Total Deaths Flood Jamaica Caribbean Americas 300 Epidemic Viral disease lamaica Caribbean Eastern Asia Western Asia Americas 30 1900 Geophysical 1900 Geophysical 10 1900-0008-IPN Volcanic activ Ash fll Japan Asia 30 11 1900-0009-TUR Earthquake Ground move Turkey Asia 140 1900 Meteorological 1900 Climatological 1900 Climatological Tropical cyclo United States Northern America Drought 12 1900-0003-USA Storm Drought Drought Earthquake Tsunami Americas 6000 13 1900-0002-CPV 14 1900-9001-IND Cabo Verde Western Africa Africa 11000 Drought India Southern Asia Asia 1250000 15 1901-0004-JPN 1901 Geophysical Japan Eastern Asia Asia 18 1901 Biological 1902 Geophysical 1902 Geophysical 1902 Geophysical 16 1901-0001-UGA Eastern Africa Africa Epidemic Earthquake Ground move Azerbaijan Western Asia Uganda 200000 17 1902-0013-AZE Asia 86 18 1902-0003-GTM Volcanic activ Ash fall Guatemala Central America Americas 1000 19 1902-0012-GTM Earthquake Ground move Guatemala Central America Americas 2000 20 1902-0005 MMR 1902 Meteorological 1902 Geophysical Storm Tropical cyclo Myanmar South-Eastern Asia Saint Vincent Caribbean Asia 600 21 1902-0007-VCT Volcanic activ Ash fall Americas 1565 22 1902-0006-MTQ Martinique Caribbean 1902 Geophysical 1902 Geophysical 1902 Geophysical 1902 Geophysical 1902 Geophysical 1903 Geophysical 1903 Geophysical 1903 Geophysical 1903 Geophysical Volcanic activ Ash fall Americas Asia Asia Americas 30000 Earthquake Ground move China Volcanic activ Ash fall 23 1902-0014-CHN Eastern Asia 2500 24 1902-0008-IPN Japan Eastern Asia 125 25 1902-0010-GTM Volcanic activ Ash fall Guatemala Central America 6000 26 1902-0011-SUN Earthquake Ground move Soviet Union Russian Federation Earthquake Ground move israel Earthquake Ground move Turkey Mass movem Rockfall Europe 4562 27 1903-0014-ISR Western Asia Asia 20 Western Asia Northern America 28 1903-0013-TUR Asia 1700 29 1903-0006-CAN Canada Americas 76 30 1903-0007-TUR Earthquake Ground move Turkey Western Asia Asia 3560 1903 Geophysical 1903 Meteorological 1903 Geophysical 1903 Geophysical 1903 Climatological 31 1903-0015-TUR Earthquake Ground move Turkey Western Asia Asia 1000 32 1903-0008-IAM Storm Tropical cyclo lamaica Caribbean Americas 65 33 1903-0016-IRN Earthquake Ground move Iran (Islamic ISouthern Asia Asia 350 Volcanic activ Ash fall Drought Comoros (the Eastern Africa Niger (the) Western Africa 34 1903-0012-COM Africa 17 35 1903-9001-NER Drought Africa 36 1903-0010-USA 1903 Meteorological 1903 Hydrological 1903 Hydrological 1904 Geophysical Storm Convective stUnited States Northern America Americas 98 37 1903-0002-USA Flood United States Northern America Americas 38 1903-0003-USA Flood United States Northern America Americas 250 39 1904-0007-TWN 40 1904-0008-GRC Asia Earthquake Ground move Taiwan (Prov Eastern Asia Southern Europe 3 1904 Geophysical 1904 Geophysical Earthquake Ground move Greece Europe 4 Earthquake Ground move Taiwan (Prov Eastern Asia Tropical cyclo Bangladesh Southern Asia 41 1904-0009-TWN Asia 145 1904 Meteorological 1905 Geophysical 42 1904-0003-BGD Storm Asia 43 1905-0003-IND Earthquake Ground move India Southern Asia Asia 20000 44 1905-000s-ALB 1905 Geophysical 1905 Geophysical 1905 Geophysical 1905 Geophysical 1905 Meteorological 1905 Geophysical Southern Europe Eastern Asia Northern America Earthquake Ground move Albania Europe 120 45 1905-0009-IPN Earthquake Ground move Japan Asia 11 45 1905-0005-CAN Mass movem Rockfall Canada Americas 18 47 1905-0001-ITA Earthquake Ground move Italy Southern Europe Tropical cyclo Philippines (tSouth-Eastern Asia Europe 557 48 1905-0004-PHL Storm Asia 240 49 1905-0010-CHN -------- Earthquake Ground move China Eastern Asia Asia Feuil1 Feuil2 Feuil3 +
We wish to have a synthetic view of the information relating to disasters: their type and their geographical
distribution. On Sheet 2 of the file, we have listed all the values found on Sheet 1: column 3 (subgroup), column
4 (type) and column 8 (continent).
Feuil2, we want to indicate the number of disasters in each category. Exercises 2 to 4 will allow you to build
a solution based on the use of a parameterised function. This information will allow you to contextualise your
rеport.
Exercise 2: Synthetic analysis of disasters
To begin with, the focus is on disasters related to climat.
Q2.1: Propose an algorithm² « NbDesastreClim » to count the number of "Climatological" type disasters
indicated in "Feuill". The result should be written on Feuil2, line 4, column 2. You can use the "for" loop
(since you know the total number of disasters).
Transcribed Image Text:We wish to have a synthetic view of the information relating to disasters: their type and their geographical distribution. On Sheet 2 of the file, we have listed all the values found on Sheet 1: column 3 (subgroup), column 4 (type) and column 8 (continent). Feuil2, we want to indicate the number of disasters in each category. Exercises 2 to 4 will allow you to build a solution based on the use of a parameterised function. This information will allow you to contextualise your rеport. Exercise 2: Synthetic analysis of disasters To begin with, the focus is on disasters related to climat. Q2.1: Propose an algorithm² « NbDesastreClim » to count the number of "Climatological" type disasters indicated in "Feuill". The result should be written on Feuil2, line 4, column 2. You can use the "for" loop (since you know the total number of disasters).
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Array
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
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