Question: Design an Entity-Relationship Diagram (ERD) for a car race database with the following requirements. We have cars, for each car we keep its VIN number

Design an Entity-Relationship Diagram (ERD) for a car race database with the following requirements. We have cars, for each car we keep its VIN number (unique ID), engine type, color, make, and model We have drivers, for each driver we keep ID (unique), name, DoB, and age (derived attribute) Drivers use cars to enter races, each race has some attributes such as the race number (unique ID), race type, the number of rounds, and date. Each driver can enter many races and can use the same car or different one in each race. Thus the same car can participate in many races. In the design, we want to capture which car is used by which driver and in which race. We also need to capture the winner of each race (the driver who won the race) and the winning time (the time taken to finish and win the race). Cars may make accidents. We need to capture the accident history of cars. For each accident, we need to capture the involved car(s), involved driver(s), the race in which the accident took place
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
