Question: Please answer ASAP! Question 3.150 p_ointsl You are in charge of keeping track of Rutgers bus system. You operate a number of different kind of

Please answer ASAP!

Please answer ASAP! Question 3.150 p_ointsl You
Question 3.150 p_ointsl You are in charge of keeping track of Rutgers bus system. You operate a number of different kind of bus, for example, \"LX\" or \"REEL.\" For each kind of bus, you want to keep track of the operating hours and days of operations [weekday or weekend). For example, \"A\" bus operates from T: AM until 9:31} PM during the weekdays and \"H\" bus operates from t AM until 2:3 AM during the weekdays. For each bus, you want to store bus ID, date acquired, maxiinurn mileage. Each kind obes uses multiple buses, but, for simplicity, assume one bus can he used in exactly one kind of bus. If a bus 1312255039 is \"LR\" bus, then the bus will be \"LX\" until it reaches the maximum mileage. Also, you have access to a table of stations. For each station, you want to store station ID, name, and the description of location. The event of a bus leaving a station by a driver is called a dispatch. Every time a bus dispatches, you want to record which bus was dispatched, who was the driver, the datei'time and the station the dispatch started, the dateftime and the station the dispatch ended, and up to 255 characters of text for driver comment (such as \"back door is not working\"}. Only about 5% of dispatches result in any comments. Each driver has a unique employee ID, along with a first name, last name, middle name, date of'birtb, cell phone number, and date of last safety training. In addition, you want to keep track of which kind of bus covers which stations. Design a database to hold all this information. Draw an entity-relationship diagram and write a database design outline. You may create \"ID\" elds as necessary, If possible, create a design that avoids wasting space on empty comment elds

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 General Management Questions!