CREATE DATABASE RacingChampionship;
USE RacingChampionship;


CREATE TABLE Teams (
    TeamID INT PRIMARY KEY AUTO_INCREMENT,
    TeamName VARCHAR(50) NOT NULL,
    Country VARCHAR(50)
);


CREATE TABLE Drivers (
    DriverID INT PRIMARY KEY AUTO_INCREMENT,
    FirstName VARCHAR(50) NOT NULL,
    LastName VARCHAR(50) NOT NULL,
    Age INT,
    TeamID INT,
    Nationality VARCHAR(50),
    FOREIGN KEY (TeamID) REFERENCES Teams(TeamID)
);


CREATE TABLE Races (
    RaceID INT PRIMARY KEY AUTO_INCREMENT,
    RaceName VARCHAR(100) NOT NULL,
    Location VARCHAR(100),
    RaceDate DATE
);


CREATE TABLE Results (
    ResultID INT PRIMARY KEY AUTO_INCREMENT,
    RaceID INT,
    DriverID INT,
    Position INT,
    Points INT,
    FOREIGN KEY (RaceID) REFERENCES Races(RaceID),
    FOREIGN KEY (DriverID) REFERENCES Drivers(DriverID)
);