problem 1) Scenic Routes operates the bus company which 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 should include reservation number, Route number, Date, Origin, Destinations, Departure Time, Arrival Time, Passenger Name, and Seat Number. Such as Route 97 leaves Monroe, VA, daily at 8:00 A.M. and arrives in Spencer, VA, 100 Miles away, at 11:00A.M. Scenic wants to use an alphabetic reservation code, similar to codes which airlines use.

Tasks

1) Identify entities and their relationships. Then create the ERD for a reservation system.

2) Create 3NF table designs for a system.

3) For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys.

4) Use data to populate fields for three records.