Global Economic, Demographic, and Investment Indicators Dataset(2018-2020)

This dataset represents a normalized relational database designed to analyze global economic, demographic, and investment indicators across multiple countries over a defined period. The primary objective of this dataset is to provide a structured and scalable data model that supports analytical queries and demonstrates best practices in database design and normalization.

The database is composed of four main entities: country, economic_indicators, demographic_indicators, and investment_indicators. The country table stores static information such as country name, ISO code, region, development status, and capital city. The other three tables store time-dependent data linked to each country through foreign key relationships, enabling the representation of longitudinal data across multiple years.

The economic_indicators table includes key financial metrics such as GDP, GDP per capita, inflation rate, unemployment rate, and industrial contribution to the economy. The demographic_indicators table focuses on population-related data, including total population, growth rate, life expectancy, median age, and fertility rate. The investment_indicators table captures government and private sector investment metrics, such as education expenditure, infrastructure investment, foreign direct investment, and construction investment.

This dataset was designed following normalization principles up to Third Normal Form (3NF), ensuring minimal redundancy, improved data consistency, and efficient storage. Each table represents a distinct domain, and all relationships are enforced through primary and foreign key constraints to maintain referential integrity.

Although the dataset uses synthetically generated data, its structure is inspired by real-world sources such as the World Bank and United Nations datasets. It is suitable for academic purposes, including data analysis, database management, and machine learning preprocessing. The dataset enables users to explore relationships between economic performance, population dynamics, and investment strategies across different countries and years, making it a valuable resource for both educational and analytical applications.