Racing data model. Several companies have invested their money in race cars. Companies are have a company name and number. A race car may be owned by an individual company or may be jointly owned by a group of companies. For every car, the total money invested, the contributions of each company as well as their percentage shares need to be recorded.
Every company needs to keep track of the overall funds it has invested in cars.
Each car has a vehicle identifier and a specific engine size. Cars are assigned to drivers who may race the cars. It is possible that several drivers are assigned to one car. Currently, a paper form is used to record the name of each driver with the total number of hours and the mileage a driver has logged on a car. In addition, total hours and total mileage are recorded per car.