The DVLA (Driver and Vehicle Licensing Agency) administers driving tests and issues drivers licenses to qualified

drivers. Any person who wants a drivers license must first take a learners test

at any Motor Vehicle Branch in the district. If he/she fails the test, he can take

the test again any time after a week of the failed test date, at any branch. If he

passes the test, he is issued a license (type = Learner) with a unique license

number. A learners license may contain a single restriction on it. The person may

take his drivers test at any branch any time before the learners license expiry

date (which is usually set at six months after the license issue date). If he passes

the test, the branch issues him a drivers license. A drivers license must also

record if the driver has completed drivers education, for insurance purposes.

Create an E-R diagram of the DVLA (Driver and vehicle Licensing Agency) scenario above following the steps below:

1. Identify and list all the ENTITIES in the specification above.
2. Identify and create MEANINGFUL RELATIONSHIPS among

the entities.

(iii) List the ATTRIBUTES (minimum of 5) for each of the entities

and (if any) of the relationships.

3. Indicate all CONSTRAINTS between entities and relationships.