Create an ERD

Entities and Attributes for Driver's Log
This document was created by Smith Systems Consulting at the request of the Operations
department of Huffman Trucking. The descriptions provided are based on interviews
with administrative personnel who maintain the Drivers' Log records. The creator of the
database was not available.


DRIVER
This table represents information about the drivers employed by the company.

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

DRIVING LOG
This table represents information contained in the paper Driver's Daily Log that each
driver maintains.

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


VIOLATIONS
The data in this table relates to moving violation citations the driver has received.

Name
Employee ID Number
Citation Number
Date of Citation
State / Municipality Issuing Citation
Description of Violation
Status of Citation
Disposition of Citation
Comments