data base Assignment 1

Shahad Baloush

Teams

Race

Agents

Riders

Events

Bikes

Sponsor

Rider

Sponsorship

Participation

RiderSponsorship (RiderID, SponsorID)

FK SponsorID  Sponsors

FK RiderID  Riders

Riders (RiderID, FirstNam, LastNam, City, State, Street, Zip, PhoneNum, DateJoined, AgentID, TeamID)

SK Last Nam

FK TeamID  Teams

AgentID  Agents

Agents (AgentID, FirstNam, LastNam, Street, City, State, ZipCode, PhoneNum)

Participation (RiderID, RaceID, Placement, BikeID)

FK RiderID Riders

FK BikeID  Bikes

FK RaceID  Races

Teams (TeamID, TeamNam)

Sponsors (SponsorID, SponsorNam, Street, City, State, Zip, PhoneNum)

SK SponsorNam

Bikes (BikeID, BikeNam, Weight, Description, Picture)

SK BikeNam

Events (EventID, EventNam, EventLocation, Street, City, State, ZipCode, StartDate, EndDate, SponsorID)

SK EventNam

FK SponsorID  Sponsors

Races (RaceID, EventID, RaceNam, Level, RaceLocation, Date, StartTime, EndTime)

FK RaceID  Races

FK EventID  Events

SK RaceNam