BCCC Data Impacts Of Covid19 In Different Countries Data Modeling

Description

Use the attached data file to set up data modeling, Like draw a ERD.

1 attachments

Slide 1 of 1

attachment_1

attachment_1

Unformatted Attachment Preview

country_name
Afghanistan
Albania
Algeria
Andorra
Antigua and Barbuda
Argentina
Armenia
Netherlands
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bhutan
Bolivia
Bosnia and Herzegovina
Brazil
Brunei
Bulgaria
Burkina Faso
Cabo Verde
Cambodia
Cameroon
Canada
Central African Republic
Chad
Chile
China
China
Colombia
Congo (Brazzaville)
Congo (Kinshasa)
Costa Rica
Cote d’Ivoire
region
Aruba
Hong Kong
country_codepopulation test_pop
AFG
38,928,346
ALB
2,877,797
DZA
43,851,044
AND
77,265
ATG
97,929
ARG
45,195,774
ARM
2,963,243 4269.80259
ABW
106,766
AUS
25,499,884 806.06556
AUT
9,006,398 876.279237
AZE
10,139,177
BHS
393,244
BHR
1,701,575 125.549694
BGD
164,689,383
BRB
287,375
BLR
9,449,323 590.582688
BEL
11,589,623 2743.10604
BLZ
397,628
BEN
12,123,200
BTN
771,608
BOL
11,673,021
BIH
3,280,819
BRA
212,559,417 72620.2313
BRN
437,479
BGR
6,948,445
BFA
20,903,273
CPV
554,441
KHM
16,718,965
CMR
26,545,863
CAN
37,742,154 490.387116
CAF
37,742,154
TDC
16,302,699
CHL
19,116,201
HKG
7,496,981 1422.30715
CHN
########## 4497.8868
COL
50,882,891 19791.0895
COG
5,518,087
COG
89,561,403
CRI
5,094,118
CIV
26,378,274
Croatia
Cuba
Cyprus
Czechia
Denmark
Diamond Princess
Djibouti
Dominica
Dominican Republic
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Eswatini
Ethiopia
Denmark
Fiji
Finland
France
France
France
France
France
France
Gabon
Gambia
Georgia
Germany
Ghana
Greece
Grenada
Denmark
France
US
Guatemala
Guernsey
Guinea
Guinea-Bissau
Guyana
HRV
CUB
CYP
CZE
DNK
DJI
DMA
DOM
ECU
EGY
SLV
GNQ
ERI
EST
SWZ
ETH
Faroe Islands FRO
FJI
FIN
FRA
French GuianaGUF
French Polynesia
PYF
New Caledonia
NCL
Saint Barthelemy
BLM
St Martin
MAF
GAB
GMB
GEO
DEU
GHA
GRC
GRD
Greenland GRL
Guadeloupe GLP
Guam
GUM
GTM
GGY
GIN
GNB
GUY
4,105,267
11,326,616
1,207,359
10,708,981
5,792,202
3,500
988,000
71986
10,847,910
17,643,054
102,334,404
6,486,205
1,402,985
3,546,421
1,326,535
1,160,164
114,963,588
48,873
896,445
5,540,720
65,273,511
298,682
2,225,734
2,416,668
3,989,167
83,783,942
31,072,940
10,423,054
112,523
56,770
400,124
168,775
17,915,568
70,000
13,132,795
1,968,001
786,552
3542.07679
1699.29879
760.131496
956.405912
6156.35556
5895.90019
Haiti
Holy See
Honduras
Hungary
Iceland
India
Indonesia
Iran
Iraq
Ireland
Israel
Italy
Jamaica
Japan
Jersey
Jordan
Kazakhstan
Kenya
Korea, South
Kosovo
Kuwait
Kyrgyzstan
Laos
Latvia
Lebanon
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
China
Madagascar
Malaysia
Maldives
Mali
Malta
France
Mauritania
Mauritius
France
Mexico
HTI
VAT
HND
HUN
ISL
IND
IDN
IRN
IRQ
IRL
ISR
ITA
JAM
JPN
JEY
JOR
KAZ
KEN
KOR
Macao
Martinique
Mayotte
KWT
KGZ
LAO
LVA
LBN
LBR
LBY
LIE
LTU
LUX
MAC
MDG
MYS
MDV
MLI
MLT
MTQ
MRT
MUS
MYT
MEX
11,402,528
801
9,904,607
9,660,351
341,243
##########
273,523,615
83,992,949
40,222,493
4,937,786
8,655,535
60,461,826
2,961,167
126,476,461
106,800
10,203,134
18,776,707
53,771,296
51,269,185
1,810,463
4,270,571
6,524,195
7,275,560
1,886,198
6,825,445
5,057,681
6,847,352
38,128
2,722,289
625,978
6087.17769
149.799385
233899.048
2767.81727
2235.4171
406.720343
7672.68024
178.815221
35.5880917
4222.77994
1644.46208
3668.8531
27,691,018
32,365,999
3302.99
540,544
20,250,833
441,543 496.673791
375,265
4,649,658
1,271,768
272,815
128,932,753
Moldova
Monaco
Mongolia
Montenegro
Morocco
Mozambique
Namibia
Nepal
Netherlands
Netherlands
Netherlands
New Zealand
Nicaragua
Niger
Nigeria
North Macedonia
Norway
Oman
Pakistan
Panama
Paraguay
Peru
Philippines
Poland
Portugal
US
Qatar
Republic of the Congo
France
Romania
Russia
Rwanda
Saint Kitts and Nevis
Saint Lucia
Saint Vincent and the Grenadines
San Marino
Saudi Arabia
Senegal
Serbia
Seychelles
Singapore
MDA
MCO
MNG
MNE
MAR
MOZ
NAM
NPL
Curacao
CUW
Sint Maarten SXM
NLD
NZL
NIC
NER
NGA
MKD
NOR
OMN
PAK
PAN
PRY
PER
PHL
POL
PRT
Puerto Rico PRI
QAT
COG
Reunion
REU
ROU
RUS
RWA
KNA
LCA
VCT
SMR
SAU
SEN
SRB
SYC
SGP
4,033,963
39,242
3,278,290
628,066
36,910,560
31,255,435
2,540,905
29,136,808
164,093
17,134,872
4,822,233
6,624,554
24,206,644
206,139,589
2,083,374
5,421,241
5,106,626
220,892,340
4,314,767
7,132,538
32,971,854
109,581,078
37,846,611
10,196,709
2,860,853
2,881,053
5,518,087
895,312
19,237,691
145,934,462
12,952,218
53,199
183,627
115,000
33,931
34,813,871
16,743,927
8,737,371
98,347
5,850,342
2855.812
8257.24829
300.146219
415993.107
5707.36376
106389.396
4791.31675
5188.15831
1257.39449
Slovakia
Slovenia
Somalia
South Africa
Spain
Sri Lanka
Sudan
Suriname
Sweden
Switzerland
Syria
Taiwan*
Tanzania
Thailand
Timor-Leste
Togo
Trinidad and Tobago
Tunisia
Turkey
US
Uganda
Ukraine
United Arab Emirates
United Kingdom
Uruguay
Uzbekistan
Venezuela
Vietnam
Zambia
Zimbabwe
SVK
SVN
SOM
ZAF
ESP
LKA
SDN
SUR
SWE
CHE
SYR
TWN
TZA
THA
TLS
TGO
TTO
TUN
TUR
USA
UGA
UKR
ARE
GBR
URY
UZB
VEN
VNM
ZMB
ZWE
5,459,642
2,078,938
15,893,222
59,308,690
46,754,778
21,413,249
43,849,260
586,632
10,099,265
8,654,622
17,390,388
23,816,775
59,734,218
69,799,978
1,318,445
8,278,724
1,399,488
11,818,619
84,339,067
331,002,651
45,741,007
43,733,762
9,890,402
67,886,011
3,473,730
33,469,203
28,435,940
97,338,579
18,383,955
14,862,924
3422.97304
309.734505
91951.4574
706.242308
2163.6555
1266.04162
9853.18718
5282.77209
87467.524
79.123216
1345.82314
10039.0449
density
60
105
18
164
223
17
104
593
3
109
123
39
2239
1265
668
47
383
17
108
20
11
64
25
83
64
76
138
95
56
4
8
13
26
7140
153
46
16
40
100
83
quarantine_initial_date
schools_closure_initial_date
public_initial_date
gdp2019
health_exp first_ca



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}