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.