QUESTION:

MOTOR VEHICLE BRANCH ADMINISTRATION

The motor vehicle branch administrators driving tests and issues driver’s  licenses. Any person who wants driver’s license must first take a learners exam at any motor

vehicle branch in the province. If he/she fails the exam , he can take the exam again any time after a week of the failed exam date, at any branch. If he passes the

exam ,he will be issued a license(learners type) with a unique license number. A learners  license may contain a single restriction on it. The person may take his driver’s

exam 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 exam, the branch

issues him a driver’s licence .A driver’s license must also record if the driver has completed driver’s education ,for insurance  purpose. Each driver should own a vehicle .If he has no money he can lend it through loan.

Create a E-R diagram following these steps.

1. Find out the entities in the spec.?

2. Find out the relationships among the entities?

3. Find out the attributes of the entities and the relationships?

4. Figure out constraints between entities and relationships?

answer:

1 .Entities:

Driver

Branch

License

Vehicle

Loan

2: IDENTIFY RELATIONSHIPS:

 

 

3 AND 4 :IDENTIFYING KEY ATTRIBUTES AND OTHER RELEVANT ATTRIBUTES

Driver: driver sin, driver name

Branch: branch id, branch name, branch address, branch phone, branch city, branch postalcode.

Vehicle: vehicle no, vehicle type

Loan: loan no, loan type ,loan date

LICENSE:LICENSE NO,LICENSE CLASS,LICENSE EXPIRY.

5 DRAWING ER DIAGRAM

 

 
 

 

 

Advertisements