F1 Racing Database Analysis
CSCI Database 265
- Jamell Alvarez
F1 Dataset from Kaggle (1950–2024)
The F1 Racing Database is designed to store, organize, and analyze data related to Formula 1 racing. It includes information on drivers, teams, race results, and fastest lap times. The goal is to support performance tracking (e.g., race wins, points, and lap times) across seasons. This database can assist researchers or F1 enthusiasts in evaluating and comparing driver and team performance over time.
- Drivers: Driver name, nationality, car, points, team code, year
- Teams: Team name, total points, car performance, year
- Winners: Race results including grand prix name, winner, laps, and time
- FastestLaps: Fastest laps for each race with driver and car
- DriverChangesLog: Tracks driver changes (e.g., team switches)
- A Driver belongs to a Team (via car and code)
- A Winner is a Driver (linked by code)
- A FastestLap is recorded by a Driver
- DriverChangesLog links to changes in the Drivers table
- Comprehensive Database Design: Schema models real-world relationships between drivers, teams, and races
- SQL Proficiency: Includes meaningful queries, stored procedures, transactions, and triggers
This project is not licensed for commercial use.
It is intended solely for educational purposes as part of a school assignment.
No official license is applied.