National Economic and Demographic Development Indicators: A Relational Dataset for 50 Countries (2000–2024)

This dataset provides a normalized relational database of economic, demographic, and investment indicators for 50 countries spanning the years 2000 to 2024. Countries were selected to represent a broad cross-section of the global economy, including nations from six continents, and both developed and developing economies. The dataset is organized into four relational tables: Country, EconomicIndicators, Demographics, and InvestmentIndicators.
The Country table contains static reference information for each of the 50 countries, including continent, geographic region, development status, capital city, and official language. The EconomicIndicators table includes annual time-series data on GDP (in current US dollars), GDP per capita, consumer price inflation rate, unemployment rate, and trade balance as a percentage of GDP. The Demographics table captures population dynamics including total population, urban population share, age dependency ratio, population growth rate, and life expectancy at birth. The InvestmentIndicators table records government expenditure on education, current health expenditure, gross fixed capital formation (used as a proxy for infrastructure investment), net foreign direct investment inflows, and gross capital formation, all expressed as a percentage of GDP.
The dataset is designed to support relational database modeling, normalization analysis, and economic research. All tables satisfy Third Normal Form (3NF). Primary keys and foreign key relationships are clearly defined. This dataset is suitable for use in database design coursework, comparative economic analysis, and longitudinal demographic studies.