Question
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
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:
- Identify and list all the ENTITIES in the specification above.
- 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.
- Indicate all CONSTRAINTS between entities and relationships.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started