Database Fundamentals - Relational Design & PL/SQL Portfolio
High Distinction portfolio covering ER modelling, normalisation, multi-table SQL and PL/SQL procedural programming across MySQL and Oracle.
Overview
A High Distinction portfolio for Deakin's Database Fundamentals unit, progressing from foundational database concepts to relational design, advanced SQL implementation and PL/SQL procedural programming.
The problem
Needed to demonstrate the full arc of database design skills - from modelling business requirements through to enforcing business logic inside the database itself - across two different RDBMS engines.
My approach
Modelled business requirements with Entity-Relationship diagrams and applied normalisation up to Third Normal Form to design efficient, redundancy-free schemas; implemented full relational databases with multi-table JOINs, nested subqueries and constraint enforcement in both MySQL and Oracle; wrote stored procedures, triggers and functions in PL/SQL to simulate realistic business logic; and researched the intersection of machine learning and modern database systems, including in-database model serving, ETL vs. ELT pipelines, federated learning and ML-aware data governance.