 |
|
 |
The User Requirements have been established as follows :-
1. DRIVER
This table represents information about the drivers employed by the company.
Fields include :-
Name
Employee ID Number
Home Address
Home Telephone Number
Mobile Telephone Number
License Number
License Expiration Date
Emergency Contact Name
Emergency Contact Telephone Number 1
Emergency Contact Telephone Number 2
Date of Last Physical Examination
Date of Last Annual Drug Test
Date of Last Random Drug Test
2. DRIVING LOG
This table represents information contained in the paper Driver’s Daily Log that each driver maintains.
Fields include :-
Name
Employee ID Number
Date (Month, Day, Year)
Tractor ID Number
Trailer 1 ID Number
Trailer 2 ID Number
Trailer 3 ID Number
CoDriver Name
CoDriver Employee ID Number
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
Driving Stop Time 1
Driving Start Time 2
Driving Stop Time 2
Total Hours Driving On Duty (Not Driving)
Start Time 1 On Duty (Not Driving)
Stop Time 1 On Duty (Not Driving)
Start Time 2 On Duty (Not Driving)
Stop Time 2 Total Hours On Duty (Not Driving)
Odometer Start 1
Odometer Stop 1
Odometer Start 2
Odometer Stop 2
Total Miles Driving
Comments
3. VIOLATIONS
The data in this table relates to moving violation citations the driver has received. Name
Fields include :-
Employee ID Number
Citation Number
Date of Citation
State / Municipality Issuing Citation
Description of Violation
Status of Citation
Disposition of Citation
Comments
|
|   |
Barry Williams
1st. January 2009
Principal Consultant
Database Answers
|
|
 |
 |
|