Read and analyse the following specification of a sample database domain. A transportation company would like...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
Based on the provided specification here is a conceptual schema represented in the notation of UML s... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these operating system questions
-
A University would like to create a database to record information about some of its activities. The university offers a number of degrees to students. A degree is described by a unique name, total...
-
How does national culture relate to business structures?
-
Review the list of activities associated with low-cost and high-cost customers in Exhibit 15.10. Select a company with which you are familiar and explain which activities would most likely apply to...
-
Plastico is interested in how it compares with its competitors in the same industry. a. Taking each of these variables, explain at an intuitive level whether you would expect Plastico to have more or...
-
The table below describes a hypothetical experiment on 2400 persons. Each row of the table specifies a category of person, as defined by their pre-treatment predictor $x$, treatment indicator $T$,...
-
Assume the following facts for Munoz Company in 2016. Munoz reported pretax financial income of $ 800,000. In addition, Munoz reported the following differences between its pretax financial income...
-
What strategies do you employ to optimize temporal resource allocation amidst multifaceted commitments and obligations ? Explain
-
On January 1, 2024, Palmero Company purchased an 80% interest in Santos Company for $2,800,000, at which time Santos Company had retained earnings of $1,000,000 and capital stock of $500,000. On the...
-
Morgan takes diligent notes during every meeting held in their insurance office. Its his job to report the minutes used for discussion and decisions the were made during the meetings to report to...
-
If the length of the major axis of the earth's orbit is \(186,000,000 \mathrm{mi}\) and its eccentricity is 0.017 , how far is the earth from the sun when it is at aphelion and at perihelion?
-
Using Schein's definition of organizational culture from the section that explains approaches to analyzing workplace cultures, divide the class into six teams and assign one part of the definition to...
-
Concerning the decision-making processes of people in workplaces, Mary Douglas (1986, 4) asserts that "an answer is only seen to be the right one if it sustains the institutional thinking that is...
-
If you are a practicing technical communicator currently, find some document in your organization that you can talk about not only for what it says, but also for what it does. What kind of cultural...
-
What could a technical communicator do, if anything, to be more critically conscious of the mediating effects of tools?
-
A plane takes off from a runway travelling due east with a velocity of 246 km/hour at an angle of 13.5 degrees above the horizontal. It travels at constant velocity for 15 minutes at which time it...
-
Use this circle graph to answer following Exercises. 1. What fraction of areas maintained by the National Park Service are designated as National Recreation Areas? 2. What fraction of areas...
-
What are the SQL built-in functions? How do you use them in an SQL query?
-
For the following exercises, you will address problems and answer questions from the Solmaris Condominium Group staff. You do not use the Solmaris database for any of these exercises. 1. The log...
-
What is a visibility symbol in UML?
-
The chief goal of the private sector is effciency.Why? The primary focus of the public sector is equity. Why? It is quite possible to be highly effcient yet ineffective. It is also possible to be...
-
Why is healthcare reform such a contentious issue in the United States? Why have public and private efforts been unsuccessful in fully addressing the challenge of affordable health care? What role(s)...
-
Drawing on economic theory, what kinds of market failure underlie the worlds most pressing problems? Examine three examples: hunger, groundwater contamination, and literacy.
Study smarter with the SolutionInn App