Database computer science

Greyhound has asked us to create a scheduling database for their bus service. This database will store

details about their buses, travel itineraries, passengers, and bookings.

Consider the following requirements:

$$ Greyhound has one or more buses.

$$ A Greyhound bus has a model number, a unique registration number, and the capacity

to take one or more passengers.

$$ A bus trip has a unique trip number, a departure bus station, a destination bus station, a

departure date and time, and an arrival date and time. Each trip has an anticipated

duration.

$$ Each bus trip is carried out by a single bus.

$$ A passenger has given names, a surname, many possible email addresses, and phone

numbers.

$$ A passenger has an address with street, apartment number city, state, zip code, zip code

plus $4.$

$$ A passenger can book a seat on a bus.

$$ A passenger has an emergency contact with name, relationship, and phone number.

Use these requirements and the standards established in class to draw an er$-$diagram for this databse.

$$ You MUST use VISIO to draw this!

$$ You must make this legible on one page. Landscape with $0\mathrm{.}5$ inch margin top, bottom,

left, and right.

$$ You must provide a title called $$Greyhound Bus Database er$-$Diagram$.$ Center it on the

page horizontally.

$$ You must provide a page number on the bottom. Center it on the page horizontally.

$$ I must be able to print this without spilling over onto additional pages.

$$ YOU MUST CONFORM TO STANDARDS WE DISCUSSED IN CLASS for er$-$Diagrams.