Normalized Multi-Table Socioeconomic, Population, Education, and Investment Dataset for 50 Countries (2018–2020)

This dataset presents a normalized multi-table relational database containing socioeconomic, demographic, educational, and investment indicators for 50 selected countries for 2018, 2019, and 2020. The dataset is organized into five interconnected tables: Country, Economic_Indicators, Population_Statistics, Education_Statistics, and Investment_Indicators. Each table is linked through a common CountryID key, ensuring referential integrity and consistent relationships across the database.

The Economic_Indicators table includes key macroeconomic variables such as Gross Domestic Product (GDP), GDP per capita, inflation rate, and unemployment rate. The Population_Statistics table provides demographic data, including the total population and the percentage of the population living in urban areas. The Education_Statistics table contains government expenditure on education as a percentage of GDP. The Investment_Indicators table includes foreign direct investment (FDI) inflows as a percentage of GDP. Together, these tables provide a comprehensive view of economic performance, demographic trends, education investment, and international capital flows.

The data used in this dataset were collected from publicly available international sources, primarily the World Bank’s World Development Indicators. The datasets were carefully cleaned, filtered, and normalized to support efficient querying, maintain data integrity, and enable meaningful analysis. This dataset is suitable for comparative analysis of economic development, demographic changes, and policy-related indicators across multiple countries and time periods.