Question: BUS 431 Information Systems In Class Exercise: University Fleet Database (Subtype Relationship) You are in charge of maintenance records for the bus fleet operated by

BUS 431 Information Systems In Class Exercise: University Fleet Database (Subtype Relationship) You are in charge of maintenance records for the bus fleet operated by METU State University (MSU). You operate a number of different kinds of bus", for example "MERCEDES Travego" or "MAN Neoplan. For each kind of bus, you want to keep track of the manufacturer, model number" (which may contain letters), recommended maintenance interval in both miles and days of operation, grade of oil recommended, and engine oil capacity. Each bus in your fleet has a unique license plate number. For each bus, you also want to know what kind of bus it is, when it was manufactured when you acquired it, and how many odometer miles it had when you acquired it. For each bus in your fleet, you want to be able to retrieve records of all maintenance operations performed on it. For each maintenance operation, you want to be able to retrieve the time the maintenance began, the bus's odometer mileage, and text (up to 512 characters) indicating what maintenance was performed. Each driver has a unique driver's license number, along with a first name, last name, middle name/initial, date of birth, cell phone number, home phone number, and date of last safety training. Each driver is assigned to use specific buses. So, each driver can drive more than bus and each can be used by more than one driver in each travel. By law, your drivers cannot use out-of-country licenses, so all driver's licenses are from the same country. a. Now suppose that you find out that only 5% of drivers have some comments about their health conditions, while 95%have no comments. Add a table to your database so that health comments about drivers are stored in a separate table, but each comment can still be associated with a particular driver. Draw a new entity-relationship diagram and rewrite the database design outline
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
