Huffman Trucking Driver's Log Case

1. What does Huffman Trucking Driver's Log currently track?

Name, Employee ID, Date, tractor ID, trailer 1, 2 and 3 ID, Co-Driver Name, Co-Driver employee ID, off duty start time 1, off duty stop time 1, off duty start time 2, off duty stop time 2, total hours off duty, sleeper berth start time 1, sleeper berth stop time 1, sleeper berth start time 2, sleeper berth stop time 2, total hours sleeper berth, driving start time 1 and 2, driving stop time 1 and 2, total hours driving, on duty (not driving) start time 1 and 2, on duty (not driving) stop time 1 and 2, total hours on duty (not driving), odometer start 1 and 2, odometer stop 1 and 2, total miles driving, comments.

2. What benefits would a database provide over paper records?

A database is far superior to a paper system. With a database a user can access needed information whenever he/she wants. They can organize the data in various ways, they can find that data easily, and if they need to change the data it can be done rather simply. Also, the information can be cross-referenced, maintained, updated, protected and expanded with ease and very minimal effort. A database (electronic) promotes effective and efficient data searches along with productivity increases in the work environment due to less work needed to gather/find pertinent information. Finally, the space saved and requirements such as fire protection, lighting, climate control and extra manpower are nullified with electronic databases. You do still need these items but the extent you would need them in a paper record environment is significantly reduced. With backups virtually instantaneous, and protection maximized there should never be a worry about loss or compromise.

3. Describe the objectives of the database. See "Database Systems" Section 9.3.1.

This database will present information about the drivers for Huffman Trucking. It will contain information about the drivers, including but not limited to name, address, and contact numbers. Other information that will be available will be a log, that the driver will maintain, about trips the driver has made to deliver or retrieve loads. The information provided will be of, but again not limited to the miles driven, time driven, and start and stop times. Finally, data will be gathered about the driver's violations received, if any. In general the overall purpose of a database is to be able to organize, store, manage and retrieve whatever information is stored within it.

4. Describe the problems and constraints. See Section 9.3.1 - The Database Initial Study in "Database Systems."

Knowing what "works" already and what does not. Knowing how what you are needing to accomplish will affect the entire company. As the designer you must also take