Entity Relationship Diagram (ERD) for Driving school.. can you please check if i made a mistake?
-
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 where do i have to put drivers education and cost? do i have to put staff that manages the client ? This is the attribute i figure out :- Driving School (schoolNo,Name) Driving Branch ( BranchNo, Name) Driving Test ( TestNo,TestDate,status,attempt) Driving License (LicenseNo) Learners License (LearnersNo,LearnersName,I/C,LicenseNo) Drivers License (DriversNo,DriversName,I/C, LicenseNo) should i add anything more before i draw the Entity Relationship Diagram? i'm just not sure about my work... if you can please check and comment my mistake Really appreciate your help..thanks Thank You
-
Answer:
There seems to be no available stuff to add for your coding... Good luck!
james at Yahoo! Answers Visit the source
Other answers
There seems to be no available stuff to add for your coding... Good luck!
Related Q & A:
- Where on the net can I find a diagram of the giant water bug body parts needed for a project?Best solution by Yahoo! Answers
- How do I delete my old Yahoo page after I made a new page?Best solution by answers.yahoo.com
- Where can I get a bust statue made of myself?Best solution by tomspinadesigns.com
- HOW CAN I CHANGE MY NAME FROM MY ACCOUNT I MADE A MISTAKE?Best solution by Yahoo! Answers
- Can someone please help me to make a hotmail.fr address?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.