From Raw Data to Relational Database

In this article I detail the process of transforming raw data into a structured relational database. I walk through the steps of data cleaning, transformation, and normalisation, before designing an Entity-Relationship Diagram (ERD) to model the database structure. I highlight best practices for database design and documentation,  and provide a clear guide for anyone looking to manage data efficiently in relational databases. 

View article >>

Database Normalisation: A Walkthrough from 0NF to 3NF

In this article I walk through the process of transforming unorganised data into a fully normalised relational database. I explain how to identify and remove partial and transitive dependencies, ensuring that the final design reduces redundancy and improves data integrity. 

View article >>