Database Principles
A group database project modelling the operations of a vehicle service business. Our team achieved 90%, the highest coursework mark in the year.
- Kind
- Group coursework
- Role
- Team project
- Status
- 90% · Highest in the year
- Built with
My contribution
I helped design the entity–relationship diagram, implement and create the database, and write complex SQL queries. Working across the model and implementation meant connecting the structure of the data to the questions it needed to answer.
The database
The PostgreSQL schema connects customers, vehicles, bookings, staff, parts, and invoicing. The repository includes the ERD, table definitions, queries, views, triggers, and database roles.
A team achievement
The 90% result belongs to the group. My part focused on data modelling, database implementation, and querying, contributing to a complete design and implementation delivered together.