DATABASE DESIGN · ORACLE SQL
Modeling Formula 1 across six connected tables.
I designed a normalized database for teams, drivers, races, race results, salaries, and contracts. The model supports queries that bring driver, team, and financial details together, as well as season-point comparisons from race results.
Design and implementation
Primary and foreign keys maintain relationships across the tables. I loaded records in parent-to-child order, then used validation queries to check the data and resolve relationship and column mismatches.
Sample queries combine driver profiles with team, salary, and contract details, and aggregate race results to compare points by season.