Skip to content

Latest commit

 

History

History
15 lines (6 loc) · 480 Bytes

File metadata and controls

15 lines (6 loc) · 480 Bytes

Databases Project 2024

Final Mark for Module: 82%

Project to Design and Implement a database system for an employment agency using MySQL.

Created six tables normalised to 3NF, making use of constraints and a range of data types.

Created 4 SQL VIEWS to display data useful to an end consumer. Views contained use of WHERE clauses, Aggregate Functions, Joins, and Filtering.

Demonstrated the possibility of connecting our database to a 3rd Party system using Python.