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.本数据集构建了覆盖2000年至2024年时间跨度的标准化关系型数据库，收录50个国家的经济、人口与投资相关指标。所选国家覆盖六大洲的发达与发展中经济体，能够代表全球经济的广泛截面。 本数据集共分为四张关系型数据表：国家表（Country）、经济指标表（EconomicIndicators）、人口统计表（Demographics）与投资指标表（InvestmentIndicators）。 国家表（Country）存储50个国家的静态参考信息，涵盖所属大洲、地理区域、发展状态、首都及官方语言。 经济指标表（EconomicIndicators）包含年度时间序列数据，具体包括以现价美元计价的国内生产总值（Gross Domestic Product，GDP）、人均GDP、消费者物价通胀率、失业率以及贸易差额占GDP的百分比。 人口统计表（Demographics）记录人口动态相关数据，包括总人口、城镇人口占比、年龄抚养比、人口增长率与出生时预期寿命。 投资指标表（InvestmentIndicators）收录各项以占GDP百分比表示的指标：政府教育支出、当期卫生支出、作为基础设施投资代理变量的固定资本形成总额、外国直接投资净流入额以及资本形成总额。 本数据集旨在支持关系型数据库建模、规范化分析与经济学研究。所有数据表均符合第三范式（Third Normal Form，3NF），主键与外键关系均已明确界定。该数据集适用于数据库设计课程作业、比较经济分析及纵向人口研究。