Description

The application also stores and manages information about the cars. A specific car is identified by their license plate with the color of the car recorded. The current scheme for license plate starts with letter S followed by two letters, four digits, and the final checksum letter (see: Wikipedia). The brand and the model of each car are also recorded, which we call as the make of the car.
The application also tracks all passenger information of a car that are being rented. If a car is not currently being rented, there should be no passenger. For simplicity, the passenger will ride for the entire duration of the rented car. So if a car is being rented in the interval [s, e], then any passenger of this car will ride in the car for the entire interval [s, e].
References
Page 2
2. (6 points) Schema
(a) (6 points) Entity-Relationship Diagram
Draw the entity-relationship diagram for the application, including candidate keys and cardinality constraints, in the notations of the lecture.
You should not simply translate the DDL from your previous submission to entity-relationship diagram. Instead, you should have a fresh attempt.
(b) (0 points) Schema Translation
Given your entity-relationship diagram, you are encouraged to translate the diagram into DDL. There is no submission for this. Instead, you are encouraged to compare the DDL from your previous submission with the current DDL.
Submission
• Canvas Submission: “Assignments > Questions 2” (one file per project group)
• Files
– ER Diagram: erd.pdf
Note: There is no submission for schema translation but you are encouraged to attempt them and discuss them on Canvas.
Page 4