National Intercity Train Services provides intercity travel by trains, and offers several routes, each identified by...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
National Intercity Train Services provides intercity travel by trains, and offers several routes, each identified by a route code. A route has a route name, a starting station, and a terminal station, and makes stops at various stations. A route is scheduled to run on different days of a week. possibly at different times on those days of the week. On some days of a week e.g.. on weekends, the route may run more than once a day. Each scheduled route is identified by a route code and a running number starting from 1 for each route. The estimated travel duration from the starting station to each station of a route is recorded. Stations are identified by a station id. In addition, the name and address of the station are available to anyone checking on a route. The stations on a route are also given a running number starting from 1, sequenced in order from the starting station so that a route schedule with time reflected on the stations in sequence can be displayed. To be employed by National Intercity Train Services as a train driver, a person must first possess a car driving license. Upon employment, National Intercity Train Services trains its train driver and conducts qualification tests on the different train models that National Intercity Train Services purchases. Each train model is identified by a model and a make, and includes the model specifications. Each train has a train number and a purchase reference number. A train driver must pass the qualification test for the train model of the train assigned for a journey. Each qualification test has a one year validity period. A test result and test details are recorded for each test. On the scheduled day of week, the actual time the train departs is recorded. When the journey reaches the terminal station, the time is again recorded. Unfortunately, train incidences do happen, and National Intercity Train Services wants to keep track of them for maintenance scheduling as well as for driver retraining purposes. When an incident happens, an investigating officer is assigned to the case. The incident is given an incident number. The date and time of incident, a description and the incident status must be recorded. The station related to the incident, if applicable, is also recorded. The investigating officer should record how the station has contributed to the incident. Each staff employed by National Intercity Train Services has a staff id, name, gender, date of birth, start date of employment, a job title, and one or more educational qualification. The ICT330 awarding institution and date of award are recorded for each educational qualification. Construct a conceptual (ER) model from the statements of requirements to represent the data model, showing (i) Tutor-Marked Assignment (11) entities, with entities name, relevant attributes and identifier, (14 marks) relationships with maximum and minimum cardinalities and relationship name. (16 marks) State your assumption(s) for only data requirements that are not specified. National Intercity Train Services provides intercity travel by trains, and offers several routes, each identified by a route code. A route has a route name, a starting station, and a terminal station, and makes stops at various stations. A route is scheduled to run on different days of a week. possibly at different times on those days of the week. On some days of a week e.g.. on weekends, the route may run more than once a day. Each scheduled route is identified by a route code and a running number starting from 1 for each route. The estimated travel duration from the starting station to each station of a route is recorded. Stations are identified by a station id. In addition, the name and address of the station are available to anyone checking on a route. The stations on a route are also given a running number starting from 1, sequenced in order from the starting station so that a route schedule with time reflected on the stations in sequence can be displayed. To be employed by National Intercity Train Services as a train driver, a person must first possess a car driving license. Upon employment, National Intercity Train Services trains its train driver and conducts qualification tests on the different train models that National Intercity Train Services purchases. Each train model is identified by a model and a make, and includes the model specifications. Each train has a train number and a purchase reference number. A train driver must pass the qualification test for the train model of the train assigned for a journey. Each qualification test has a one year validity period. A test result and test details are recorded for each test. On the scheduled day of week, the actual time the train departs is recorded. When the journey reaches the terminal station, the time is again recorded. Unfortunately, train incidences do happen, and National Intercity Train Services wants to keep track of them for maintenance scheduling as well as for driver retraining purposes. When an incident happens, an investigating officer is assigned to the case. The incident is given an incident number. The date and time of incident, a description and the incident status must be recorded. The station related to the incident, if applicable, is also recorded. The investigating officer should record how the station has contributed to the incident. Each staff employed by National Intercity Train Services has a staff id, name, gender, date of birth, start date of employment, a job title, and one or more educational qualification. The ICT330 awarding institution and date of award are recorded for each educational qualification. Construct a conceptual (ER) model from the statements of requirements to represent the data model, showing (i) Tutor-Marked Assignment (11) entities, with entities name, relevant attributes and identifier, (14 marks) relationships with maximum and minimum cardinalities and relationship name. (16 marks) State your assumption(s) for only data requirements that are not specified.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these programming questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Skid more Company sold merchandise on July 1, 2007 to Joseph Company, accepting a $100,000 down payment and a 8% note payable for the balance of $400,000. The cost of the merchandise to Skid more was...
-
How much EI has been withheld from the pay of an employee who has earned $52,288 during the current year? What is the employer's EI expense for this employee?
-
Write a recursive method to return the number of uppercase letters in an array of characters. You need to define the following two methods. The second one is a recursive helper method. Write a test...
-
Assume an auditor sets acceptable risks of incorrect rejection and incorrect acceptance at .10 and .05, respectively, applies ratio estimation, and obtains the following results: estimated population...
-
On December 1, 2014, the Iaia Wholesale Co. is attempting to project cash receipts and disbursements through January 31, 2015. On this latter date, a note will be payable in the amount of $ 107,000....
-
You expect an after-tax rate of return of 28% on your investments. A target company earns $263,000 (after taxes, per year). What is the maximum amount you would be willing to pay for this company?
-
James Garage Ltd is a high end tire and rim sales company with installation and repair facilities. The following information can be obtained from the company's financial statements. James Garage Ltd...
-
4 1 / 4 O + H 75% CS6310- Software Architecture & Design Assignment #1 [100 points]: Dataflow Architectures with Orange Data Mining (v1) Spring Term 2024 - created by the CS6310 Instructional Team 14...
-
When a spigot is open, water emerges from a garden hose with a speed of 14.53 inches per second. If the garden hose has an opening with a cross-sectional area of 0.63 square inches, what would be the...
-
A noisy generator produces a sound intensity of 0.15 W/m at a distance of 16 m. Find the sound intensity at a distance of 20 m Find the sound level in decibels at that distance At what distance is...
-
2.2. Consider the Cox-Ingersoll-Ross short rate model dr(t) = [a br(t)]dt + or(t)dW+(t), where a, b, o> 0 and where W is a Brownian motion under the risk neutral (martingale) probability P. (a) Show...
-
The future value and present value equations also help in finding the interest rate and the number of years that correspond to present and future value calculations. If a security currently worth...
-
Problem 5 Shown below are the operating results of Bulalacao Company, a large corporation, since its start of operations: 2016 2017 2018 2019 2020 2021 Gross income 4,000,000 4,500,000 5,500,000...
-
You and your partner have turned your hobby of building precision drones and unmanned aerial systems (UAS) for filming and photography into a successful Internet business called Aerospace Drones....
-
Decades after the event, Johnson & Johnson (J&J), the 130-year-old American multinational, is still praised for swiftly The company indicated that its response was based on the expectations set forth...
-
How did industrialization change workers personal and workplace conditions?
-
Describe your experiences with unions, either as a member or as a non-member. Have your experiences been positive or negative? How have your experiences affected your attitudes toward unions and...
-
What factors in the workplace are likely to cause the kind of dissatisfaction that would lead to unionization?
-
Compute the autocorrelation function of a periodic square wave with zero mean value and compare this result with that of a sinusoidal wave of the same period. Assume the amplitudes to be the same for...
-
The correlation coefficient of \(x\) and \(y\) is given by a. \(\sigma_{x y}\) b. \(\sigma_{x y} /\left(\sigma_{x} \sigma_{y} ight)\) c. \(\sigma_{x} \sigma_{y}\)
-
True or False. If \(x(t)\) is stationary, its mean will be independent of \(t\).
Study smarter with the SolutionInn App