Global Economic and Demographic Indicators Dataset (1974-2023): A 50-Country Normalized SQL Database

This dataset presents a comprehensive, fully normalized relational database capturing critical economic, investment, and demographic indicators for 50 diverse countries spanning a 50-year period from 1974 to 2023. Designed specifically for relational database management systems (RDBMS), the dataset is structured in Third Normal Form (3NF) to eliminate data redundancy and ensure referential integrity. Instead of raw flat files, this dataset is provided as a complete, self-contained SQL dump (.sql file) that includes the Data Definition Language (DDL) to create the schema and the Data Manipulation Language (DML) to populate the records. The database is divided into four interconnected tables: a central 'Country' parent table, and three child tables ('Economic_Record', 'Investment_Record', and 'Demographic_Record'). The Country table establishes the primary entity with unique identifiers (Country_ID), ISO Alpha-3 codes, continent classifications, and development statuses (Developed vs. Developing). The Economic_Record table details annual Gross Domestic Product (GDP in current USD), GDP per capita, inflation rates (consumer prices), and unemployment rates. The Investment_Record table tracks Foreign Direct Investment (FDI) net inflows, gross capital formation (total investment as a percentage of GDP), and gross national savings. Finally, the Demographic_Record table incorporates United Nations data on total population, life expectancy at birth, and annual population growth rates. By synthesizing authoritative data from the World Bank and the UN, this dataset offers an integrated resource for researchers and students looking to perform complex SQL querying and cross-country comparisons using clean, relational data architectures.