Individual Project

The dataset contains economic, education, and health data for over 200 countries from 1974 to 2024. The dataset is split into four tables that can work together in a MySQL database.

The Country table has basic information about each country name, country code, what continent it's on, its region, development status, capital city, and population. Country varies by different continents and regions, and its identifier is the country name.

The EconomicIndicator table contains yearly economic data for each country, including GDP in current US dollars, GDP per capita, GDP growth rate, consumer price inflation rate, and unemployment rate as a percentage of the total labor force.

The EducationIndicator table has education related features by the year, including adult literacy rate for the population aged 15 and up, government expenditure on education as a percentage of GDP, gross primary school enrollment rate, primary education completion rate, and the number of primary school age children who are out of school.

The HealthIndicator table has yearly health statistics including life expectancy at birth, measles immunization coverage for children aged 12 to 23 months, infant mortality rate per 1000 live births, current health expenditure as a percentage of GDP, and HIV prevalence in the population aged 15 to 49.

All of the indicator related data was from the World Bank's World Development Indicators database. The database is structured in the Third Normal Form to reduce any redundancy and ensure data integrity. Each indicator table is linked to the Country table by a foreign key relationship, allowing for efficient queries.

本数据集涵盖1974年至2024年间全球200余个国家的经济、教育与健康数据。数据集分为四张数据表，可在MySQL数据库中协同运作。

国家表（Country table）存储各国基础信息，包含国家名称、国家代码、所属大洲、地区、发展状态、首都及人口。国家信息按大洲与地区划分，以国家名称作为唯一标识符。

经济指标表（EconomicIndicator table）收录各国年度经济数据，包括按当前美元计价的国内生产总值（GDP）、人均GDP、GDP增长率、消费者物价通胀率以及以占劳动力总人口百分比计的失业率。

教育指标表（EducationIndicator table）包含年度教育相关特征，具体包括15岁及以上人口成人识字率、政府教育支出占GDP的比重、小学毛入学率、小学教育完成率以及失学小学适龄儿童数量。

健康指标表（HealthIndicator table）收录年度健康统计数据，包括出生时预期寿命、12至23月龄儿童麻疹疫苗接种覆盖率、每1000名活产婴儿的婴儿死亡率、当前卫生支出占GDP的比重以及15至49岁人群的艾滋病病毒（HIV）感染率。

所有指标相关数据均源自世界银行（World Bank）的世界发展指标（World Development Indicators）数据库。该数据库遵循第三范式（Third Normal Form）进行架构设计，以减少数据冗余并保障数据完整性。各指标表均通过外键关联至国家表，可支持高效查询操作。