Draw ER Diagram The DMV is creating a new database based on the…

Question Answered step-by-step Draw ER Diagram The DMV is creating a new database based on the… Draw ER DiagramThe DMV is creating a new database based on the following design requirements:A vehicle has a year and color and is uniquely identified by its license plate number. Each vehicle is either a car or truck. A car has a make and model. A truck (think semi-truck, not pickup) has a “ton capacity”. Every vehicle in the system must be owned by 1 person. The person does not have to have a driver’s license to own the particular vehicle type. A person is identified by their SSN (unique). Their name (first, last, middle), eye color (blue, green, brown, gray), height in inches, and multiple phone numbers are kept.A person can request either a driver’s license (making them a driver) or an identification card (not a driver). Drivers are assigned a unique driver’s license number. Drivers can be granted permission to be professional drivers who can operate trucks. A driver can only drive cars unless they are a professional driver. A professional driver can operate both trucks and cars.A car may be driven by only 1 driver (owner or not). Each truck has one or more professional drivers who can operate it.  Computer Science Engineering & Technology MYSQL Share QuestionEmailCopy link Comments (0)