For the given problem statement, you are expected to:

1. Create an entity-relationship (ER) model of the given problem. In this step, you need

to identify entities, relationships, as well as inferring primary keys and foreign keys for

entities. A description of your solution should accompany the ER diagram.

2. Have a working database environment on your laptop (MySQL as a default), but you can

try other solutions if you want.

3. Create a database based on the relational model using SQL. You need to convert the

designed tables into SQL statements so that you can create the real tables in your DBMS.

Requirements:

The city government of a city wants to keep track of all its registered vehicles, drivers,

and their driving licenses. The city wants to ensure that it has up-to-date information on each

driver and vehicle, as well as their driving history, licenses, and road test results.

Vehicles can be characterized by their license plate number (unique), make, model, year,

and color. Drivers can be characterized by their SSN number (unique), name, address, date

of birth, and phone number. Driving licenses have an license number (unique), expiration

date and can be renewed.

Drivers are tested for their driving skills and knowledge through road tests. Road tests have

a unique test ID, date, and time, and can be conducted by one of the citys licensed driving

instructors. Driving instructors are characterized by their instructor ID, name, address, phone

number, and years of experience.

In addition to road tests, drivers can also accumulate traffic violations. These violations

can result in points being added to their driving record and may result in the suspension or

revocation of their license. Traffic violations are characterized by a violation ID, date, location,

and description of the infraction.