Objectives

• Design a comprehensive data model using draw.io.
• Extract, Transform data using Python and Load it into PosgreSQL database.
• Use SQL for schema creation and data management.
• Develop a structured database to enhance data access and analysis.

Technical Article

Understanding Data Modeling

Data Model

Entity Relationship Diagram (ERD)

Dataset Used

This dataset shows the number of teachers per county in kenya. It has been extracted from the Ministry of Educations' - Basic Education Statistical Booklet which captures national statistics for the Education Sector in totality.

More info

1. Original Data Source
2. Data Dictionary

Requirements

1. Python Libraries:

   • Pandas: For reading CSV files and manipulating data.
   • psycopg2-binary: For connecting to PostgreSQL and executing SQL commands.

2. Database Client:

   • psql: Command-line interface for PostgreSQL.
   • pgAdmin: GUI tool for managing PostgreSQL databases.

Technology Used

1. Programming Language: Python
2. Scripting Language: SQL
3. Database: PostgreSQL
4. Data Modeling :draw.io

Source Code

DataModel.ipynb