How to translate high level entity relationship into schema?

Can you please check my Entity Relationship Diagram (ERD)?

  • this is the scenario of driving school :- The Foxy Driving School administers driving tests and issues driver's licenses. Any person who wants a driver's license must first take a learner's exam at any Foxy Driving School branch in the province. If he/she fails the exam, he/she can take the exam again any time after a week of the failed exam date, at any branch. If he/she passes the exam, he/she is issued a license (type license = learner's) with a unique license number. A learner's license may contain a single restriction on it to inform the driver is novices. The person may take his driver's exam at any branch any time before the learner's license expiry date (which is usually set at six months after the license issue date). If he/she passes the exam, the branch issues him a driver's license. A driver's license must also record if the driver has completed driver's education and cost involved, for insurance purposes. the entity type i identified and it's relationship are :- Driving School (1...1) -------have---------(1...*) Driving Branch Driving School (1...1)---------issues-------(1...*) Driving Licence Driving School (1...1)---------administers------(1...*) Driving test Driving license (1..1)--------have--------(1....*) Learners License Driving license (1..1)--------have--------(1....*) Learners License Driving license (1..1)--------have--------(1....*) Drivers License Driving Branch (1.1)--------registers-----(1...*) clients is there anything i have to add? Thanks In Advance =)

  • Answer:

    Car

Michael Jackson at Yahoo! Answers Visit the source

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.