Question: create an entity based diagram and write a database design for the following You are in charge of keeping track of Rutgers bus system. You

create an entity based diagram and write a database design for the following

You are in charge of keeping track of Rutgers bus system. You operate a number of different kind of bus, for example, LX or REXL. For each kind of bus, you want to keep track of the operating hours and days of operations. For example, A bus operates from 7:00 AM until 9:30 PM during the weekdays and H bus operates from 6:00 AM until 2:30 AM during the weekdays. For each bus, you want to store bus ID, date acquired, maximum mileage. Each kind of bus uses multiple buses, but, for simplicity, assume one bus can be used in exactly one kind of bus. If a bus 12255039 is LX bus, then the bus will be LX until it reaches the maximum mileage.

The event of a bus leaving the first station is called a dispatch. Every time a bus dispatches, you want to record which bus was dispatched, who was the driver, the date/time the dispatch started, the date/time the dispatch ended, and up to 255 characters of text for driver comment (such as back door is not working). Each driver has a unique employee ID, along with a first name, last name, middle name, date of birth, cell phone number, and date of last safety training.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!