Question: Read and analyse the following specification of a sample database domain. A transportation company would like to create a database to record some of

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 a number of 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. Each 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 a city name, street name and building number. Each intermediate stop has a unique number in a sequence of intermediate stops within a transportation service. A transportation service is described by a planned departure time from an origin location, the planned arrival times and departure times at the intermediate stops and a planned arrival time a destination location. A city of departure, planned departure time, and a city of destination uniquely identify each transportation service. The transportation company assigns the drivers and busses to the transportation services. Shorter transportation services have one bus and one driver assigned. Longer transportation services have a single bus and multiple drivers assigned. Each driver is assigned to a section of a longer transportation service. A section starts at a location, and it includes a number of successive locations a transportation service passes through. A description of a bus consists of a registration number, make, model fuel consumption and a total number of seats available. An objective if this task is to construct a conceptual schema for the specification of a database domain listed above. Artificial identification attributes, commonly known as "id" attributes are not allowed in your solution. Use the UMLet tool to create a drawing of a conceptual schema in the notation of UML simplified class diagrams explained to you during the lecture classes in DPITI 15. No other notation will be accepted. Remember to use the CSIT115-815Palette palette.
Step by Step Solution
There are 3 Steps involved in it
Based on the provided specification here is a conceptual schema represented in the notation of UML s... View full answer
Get step-by-step solutions from verified subject matter experts
