CREATE TABLE Rider(
    name VARCHAR(30),
    weight REAL,
    PRIMARY KEY(name)
) ENGINE=innodb;

CREATE TABLE Participants(
    competition VARCHAR(30) NOT NULL,
    rider VARCHAR(30) NOT NULL,
    PRIMARY KEY(competition, rider),
    FOREIGN KEY(competition) REFERENCES Competition(name),
    FOREIGN KEY(rider) REFERENCES Rider(name)
) ENGINE=innodb;

CREATE TABLE Competition(
    name VARCHAR(30),
    PRIMARY KEY(name)
) ENGINE=innodb;

::Riders::
(Name : Weight)
Alan : 55
David : 60
Peter : 65
Stan : 60


::Competition::
(Name)
Derby
York


::Participants::
(Competition : Rider)
Derby : Alan
Derby : David
York : Alan
York : Peter
York : Stan