Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Metro Trains provides rides on diesel and steam trains throughout the state. It owns 32 engines, each with a unique serial number consisting
The Metro Trains provides rides on diesel and steam trains throughout the state. It owns 32 engines, each with a unique serial number consisting of 6 digits. Printed below are data for trips on September 10. Each trip lasts a minimum of 1.5 hours. Serial # 173954 624974 130856 442751 820451 003876 Trip Date 09/10 09/01 09/10 09/11 09/10 09/10 Engine Type D S E D DD S Departure time Return time 09:15 11:46 10:25 10:23 12:30 16:42 13:45 17:43 15:00 18:32 15:30 15:45 Table notes: Valid train codes (engine type column): D = Diesel, S = Steam The above table has five data fields: (1) Serial Number, (2) Trip Date, (3) Engine Type, (4) Departure Time and (5) Return Time. A data analyst at Metro Trains identified errors in five of the six records in the data-table above. The errors are as follows: 1. 2nd row - Wrong date is used (09/01 instead of 09/10); also, return time is earlier than departure time (and thus, the duration is less than at least 1.5 hours) 2. 3rd row - serial number has the letter o instead of a zero; engine type (E) is invalid. 3. 4th row - Wrong date is used (09/11 instead of 09/10). 4. 5th row - Engine Type (DD) is invalid. 5. 6th row - Duration of trip is less than 1.5 hours. (3a) For each of the five (5) data fields, identify and explain one input edit control that could be used to detect the input errors identified above.
Step by Step Solution
★★★★★
3.43 Rating (162 Votes )
There are 3 Steps involved in it
Step: 1
Serial Number A regular expression could be used to ensure that the serial number is a valid 6digit ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started