← Back to Projects
MSc Project · COMP11108 · Database Design & Implementation
DriveSmart Motors — Relational Database System
Designed and implemented a full relational database from conceptual ERD through to physical implementation in Microsoft Access. Produced a complete data dictionary, applied 1NF→2NF→3NF normalisation, enforced referential integrity across five tables, and wrote 10 SQL queries covering stock, revenue, history, and performance.
Overview
An MSc database design and implementation project (COMP11108) for a fictional car dealership, "DriveSmart Motors" — covering the full lifecycle from requirements and conceptual modelling through to a working physical database with real queries.
Process
- Built a conceptual Entity-Relationship Diagram (ERD) covering customers, sales, cars, staff, and services
- Produced a complete data dictionary documenting every field, type, and constraint
- Applied progressive normalisation — 1NF → 2NF → 3NF — to eliminate redundancy and ensure data integrity
- Implemented the physical database in Microsoft Access, enforcing referential integrity across five interrelated tables (Customer, Sale, Car, Service, Staff)
- Wrote 10 SQL queries covering stock levels, revenue reporting, sales history, and staff/service performance — collectively tracking £128k in revenue
Why it's relevant
Database normalisation and query design are core to both data engineering and backend roles — this project demonstrates the full theory-to-practice pipeline, from ERD to working SQL against a real schema.
SQLERDNormalisationMS Access