A transportation company would like to create a database to record some of its operations…. 1 answer below »

FIRST GRADER essay writing company is the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click the button below to place your order.


Order a Similar Paper Order a Different Paper

Task 1

Read and analyse the following specification of a sample database domain.

A transportation company would like to create a database to record some of its operations. The company owns and uses several busses to implement transportation services between the cities.

The company employs administration staff members, drivers and mechanics. A common description of an employee consists of a unique employee number, first name last name and date of birth. Additionally, drivers are described by a unique driving licence number and category of a driving licence. Mechanics are also described by a list of qualifications acquired in the past together with a date when each qualification has been acquired.

The company supports a number of transportation services. A service starts at a city, passes through a number of intermediate stops and ends in another or the same city. An origin location, a sequence of intermediate stops, and a destination location of a service are described by unique addresses. An address consists of city name, street name and building number. Each intermediate stop has a unique number in a sequence of intermediate stops within a transportation service.

Attachments:

Got stuck with another paper? We can help! Use our paper writing service to score better grades and meet your deadlines.

Get 15% discount for your first order


Order a Similar Paper Order a Different Paper
Writerbay.net