Answered step by step
Verified Expert Solution
Link Copied!

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

9th Edition

1337614689, 1337614688, 9781337668262, 978-1337614689

More Books

Students also viewed these Accounting questions