Database Answers Pebble Beach
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Drivers Violation Log

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
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map