Identify the main relationships between the entities

Assignment Help Basic Computer Science
Reference no: EM131214110

Read the following case study that describes the data requirements for the Easy Drive School of Motoring. The Easy Drive School of Motoring has many well-qualified instructors who have an unbeatable record of success in teaching people to drive. A new client must first attend an interview with an instructor to discuss an appropriate plan of learning. During this interview the client provides personal details, including his or her provisional driving license number. Each client is uniquely identified using a client number. A client may request individual lessons or book a block of five, ten, or twenty lessons The more lessons a client books in advance, the less they are charge per hour for a lesson. An individual driving lesson is for one hour, which begins and ends at the Easy Drive School of Motoring office. A lesson is with a particular instructor in a particular car at a given time. Lessons can start as early as 8am or as late as 8pm. After each lesson, the instructor records the progress made by the client and notes the mileage used during the lesson. The school has a pool of cars, which are adapted for the purposes of teaching. Each instructor has the sole use of a particular car. Once ready, a client applies to take a theoretical and then a practical driving test. If a client fails to pass, the instructor must record the reasons for the failure. Only the results of the latest attempt to pass the theoretical and practical test are recorded.

(a) Identify the main entities of the Easy Drive School of Motoring.

(b) Identify the main relationships between the entities.

(c) Determine the multiplicity constraints for each relationship.

(d) Identify attributes and associate them with an entity or relationship.

(e) Determine candidate and primary key attributes for each entity.

(f) Using your answers (a) to (e), represent the data requirements of the Easy Drive School of Motoring as an ER model. State any assumptions necessary to support your design.

Reference no: EM131214110

Create and save your database model in visio file

Name your Visio file using Lab2_, your first initial, and your last name (e.g., Lab2_JSmith.vsd). Create and save your database model in your Visio file. When you are done, su

Five major responsibilities of database administration

In general, what are data administration's responsibilities to the professional and managerial employees of the company? Concentrate on training, publicity, and liaison task

Write an analysis essays on oracle business intelligence

Write an Analysis Essays on Oracle Business Intelligence as an information system Platform, analyzing specific aspects of the system related to the concepts information m

Myth of mac devices

From the second e-Activity, explain whether or not you believe that the myth of Mac devices being more secure than Windows devices is becoming history, and justify your answ

How do you recommend training the organization

Also, how do you recommend training the following below? Organization, Technical and Management. It's important to know your audience because you want your audience to underst

Determining the real-balances effect

For each of the following scenarios, determine whether the situation described can be attributed to the real-balances effect, the interest-rate effect, or the foreign-purcha

Script section of the body

Within the script section of the body, create an array that will list the names of 7-10 cars that are of the same make. For example you can create a list that will contain c

Find out how a client can negotiate its use

Assume the server reads each client message with gets() or the equivalent, which reads in a string up to an . What would it have to do even to detect that a client had used

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd