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
Related Q & A:
- Can you please help me sign in to my Yahoo Messenger?Best solution by Yahoo! Answers
- Can you please tell me why the expressive social style is the most important one?Best solution by answers.yahoo.com
- Can anyone PLEASE help me get into my e-mail?Best solution by Yahoo! Answers
- Can someone please help me? Nursing?Best solution by Yahoo! Answers
- Tagalog speakers can you please translate for me?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
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.