Scenic Routes operates a bus company that specializes in travelling on secondary roads, rather than Interstate highways.
Fantastic news! We've Found the answer you've been seeking!
Question:
Scenic Routes operates a bus company that specializes in travelling 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 lime, Passenger Name, and Seat Number. For example, Route 97 leaves Monroe, VA, daily at 8:00 a.m. and arrives in Spencer, VA, 100 miles away, at 11:00 a.m. Scenic wants to use an alphabetic reservation code, similar to the codes that airlines use.
Tasks
Identify the entities and their relationships. Then create an ERD for the reservations system.
Related Book For
Posted Date: