Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please create an ER diagram in UML notation showing all the entities, attributed , realtionships and multiplicity constrains You are asked to design a database

please create an ER diagram in UML notation showing all the entities, attributed , realtionships and multiplicity constrains
image text in transcribed
You are asked to design a database for a company that operates driving schools at several cities in UK. It is to store information about the driving schools, clients, instructors, cars and details of bookings for driving lessons and tests. A driving school has a unique ID and address. It employs several driving instructors and some administration staff with various job roles, e.g. manager, secretary, assistant. All members of staff have a unique ID, forename, surname, gender, contact phone number, address. Instructors have a valid driving license number recorded, other members of staff have their role recorded. Each instructor is allocated a specific car by the school. Each car has a numeric identifier, a registration number and model. A client has a unique ID, forename, surname, gender, date of birth, address, contact phone number, and a provisional driving license number. After clients register with a driving school near where they live, they may book individual lessons with a particular instructor in the school. Each lesson lasts for an hour. A client may change to a different instructor at any stage. A client may apply for a driving test at the nearest test centre. Each centre has a unique ID, name, address and contact phone number. A client may make multiple attempts to pass the test. For each test, the instructor should be available to drop off and pick up the client before and after the test at the centre. If a client fails a test, the reasons for failure must be recorded

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Constraint Databases

Authors: Peter Revesz

1st Edition

1441931554, 978-1441931559

More Books

Students also viewed these Databases questions

Question

Explain how Sample function works in R.

Answered: 1 week ago