School project · CS2102
Relational Database Project
Modelled, designed, and implemented a relational database from ER diagram to stored procedures and triggers in PostgreSQL.
The problem
Given a contextual problem, produce a normalised schema with full relational integrity, then expose behaviour through SQL functions, procedures, and triggers.
What I did
Group project: produced the ER model, translated it to a normalised schema, and implemented stored functions, procedures, and triggers to enforce business rules. Functional dependencies and normalisation covered individually.
Outcome
Delivered a working PostgreSQL implementation meeting all specified constraints — a foundation that has been directly useful in production database work.