Please use UML Modelling Notation. (Don't use Chen’s Notation or Crow’s Feet Notation) -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. You are required to design a database for a car championship. The requirements are as follows: In the championship, each car’s information such as the car model, the top speed and the acceleration will be stored, and it is identifiable through a unique car ID. Each car will be drove by only one driver. Each driver’s info such as the unique driver number, driver name and the experience level of the driver are stored as well. A driver may have many trainers from more experience drivers and these experience drivers would have at least one trainee who follow them. Each of these drivers are usually supported by a team which each team have a name and is identifiable through the team number. Usually, a team would have at least one driver in the race. Every race would have a specific race ID and a race name. In a race would consists of many cars and each race would have a record of the race date and its winner (no. 1, 2, and 3). Every race will be held at one track at a time, vice versa. These tracks’ info is recorded such as the unique track id and the location. Basically, all the tracks can be divided into two different types based on the purposes, which are circuit and rally. For circuit tracks will have the info like type of circuits and its layout. While rally track will have the length of the rally, and the start place.
Subject:
Topic: EERD
Please use UML Modelling Notation. (Don't use Chen’s Notation or Crow’s Feet Notation)
-Based on the information given below, draw the conceptual EERD where you should include the enhanced features.
You are required to design a database for a car championship. The requirements are as follows:
In the championship, each car’s information such as the car model, the top speed and the acceleration will be stored, and it is identifiable through a unique car ID. Each car will be drove by only one driver. Each driver’s info such as the unique driver number, driver name and the experience level of the driver are stored as well. A driver may have many trainers from more experience drivers and these experience drivers would have at least one trainee who follow them. Each of these drivers are usually supported by a team which each team have a name and is identifiable through the team number. Usually, a team would have at least one driver in the race.
Every race would have a specific race ID and a race name. In a race would consists of many cars and each race would have a record of the race date and its winner (no. 1, 2, and 3). Every race will be held at one track at a time, vice versa. These tracks’ info is recorded such as the unique track id and the location. Basically, all the tracks can be divided into two different types based on the purposes, which are circuit and rally. For circuit tracks will have the info like type of circuits and its layout. While rally track will have the length of the rally, and the start place.
Step by step
Solved in 2 steps with 2 images
