Create user-s requirements specification for easydrive

Assignment Help Basic Computer Science
Reference no: EM1351822

Q1) The EasyDrive School of Motoring was established in Glasgow in 1992. Since then, the school has grown steadily and now has several offices in most of the main cities of Scotland. However, the school is now so large that more and more administrative staff are being employed to cope with the ever-increasing amount of paperwork. Furthermore, the communication and sharing of information between offices, even in the same city, is poor. The Director of the School, Dave MacLeod, feels that too many mistakes are being made and that the success of the school will be short-lived if he does not do something to remedy the situation. He knows that a database could help in part to solve the problem and has approached you to help in creating a database system to support the running of the EasyDrive School of Motoring. The Director has provided the following brief description of how the EasyDrive School of Motoring operates.

Data Requirements

Each office has a manager, several instructors, and administrative staff. The manager is responsible for the day-to-day running of the office. Clients must first register at an office and this requires that they complete an application form, which records their personal details. Clients then book their lessons. A lesson is for one hour, which begins and ends at the office. A lesson is with a particular instructor in a particular car at a given time. Lessons can start as early as 8 am and as late as 8 pm. After each lesson, the instructor records the progress made by the client and notes the mileage used during the lesson. Each office has a pool of cars, which are adapted for the purposes of teaching. Each car is allocated to a particular instructor. Once ready, a client applies to take a driving test at the local government testing centre. After the test is completed, the client returns to the school and the test results are recorded.

Query Transactions (Sample)
The Director has provided some examples of typical queries that the database system for the EasyDrive School of Motoring must support:

(a) The name and telephone number of the manager of each office.
(b) The full address of all offices in the city of Glasgow.
(c) The names of all female instructors based in the Bearsden office in the city of Glasgow.
(d) The total number of staff at each office.
(e) The total number of clients at each office.
(f) The lessons for a given instructor.
(g) The employee numbers and names of staff who are over 55 years old.
(h) The registration number of the cars used at the Bearsden office in the city of Glasgow.
(i) The names of all clients who passed the driving test in January 2005.
(j) The names of all clients that have taken the driving test more than three times.
(k) The average number of miles driven during a lesson.
(l) The number of administrative staff at each office.


Write a mission statement for the EasyDrive School of Motoring database system.

Write mission objectives for the EasyDrive School of Motoring database system.

Create a user's requirements specification for the EasyDrive School of Motoring database system. Use a single major user view for the application (Director View).

Reference no: EM1351822

Compare and contrast the benefits of sharing digital

Research both sides of the argument. Compare and contrast the benefits of sharing digital content and the desire to protect it. Which side do you believe has the more vali

What is the ranking of the algorithms

To perform the tests, create a randomly generated array of 1,000 elements. What is the ranking of the algorithms? What happens when you increase the array size to 10,000 ele

New technology requirement that you have identified

Identify and analyze what you believe to be the most significant new technology requirements for the health care industry. Indicate how providers should approach the implement

Create a new swept solid using new rectangle as the profile

Create a new swept solid using the new rectangle as the profile, and use the Twist option to twist the swept profile 270°. Your drawing should look similar to the one in Fig

Solve the following problems using linearity of expectation.

Solve the following problems using linearity of expectation. . (For each problem you will want to think about what the appropriate random variables should be and define them e

The mobile application development project

Identify at least four (4) attributes of the mobile application development project that can be measured and controlled and evaluate how each is a critical factor for the su

Number of deployment platforms

1. Identify and describe how the following events would change and SDP: a. The software design tool is not acquired as planned. d. Only half the number of deployment platforms

Explain the relationship between the parameters

The assignment is to prepare a general plot that enables one to calculate the drag coefficient for flow past any submerged object as long as the sphericity can be calculated


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