Systems Analysis and Design 10th Edition Rosenblatt Chapter 9 Case Studies Chapt

Question

Systems Analysis and Design 10th Edition Rosenblatt Chapter 9 Case Studies Chapter Case: Scenic Routes Task #4 page 397

Scenic Routes operates a bus company that specializes in travellling on secondary roads, rather than Interstate Highways. Their slogan is :"It Takes a Little Longer, But It's Scenic." The firm needs to update its passenger reservation system.

Background:

Data Items must include reservation number, Route Number, Date, Origin, Destinations, Departure Time, Arrival Time, Passenger Name, and Seat Number. For Example, Route 97 leaves Monroe, VA, dailyat 8:00am and arrives in Spencer, VA, 100 miles away, at 11:00am. Scenic wants to use an alphabetic reservation code, similar to the codes that airlines use.

4. Use sample data to populate the fields for three records?

Explanation / Answer

reservation number route number date origin destination departure time arrival time passenger name seat number R1000 8 29-1-16 bangalore sringeri 10 pm 6 am shanta A1 R1002 5 29-1-16 Bangalore mysore 9:30 am 12:30 pm Manoj A11 R1101 12 29-1-16 Bangalore Tumkur 8:30 am 11:00 am Swetha A16

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.