Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
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 erdiagram for this databse.
You MUST use VISIO to draw this!
You must make this legible on one page. Landscape with inch margin top, bottom,
left, and right.
You must provide a title called Greyhound Bus Database erDiagram 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 erDiagrams.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started