ERD Creation Project

• Create a detailed ERD using the Entities and Attributes for Driver's Log document found on the Huffman Trucking Intranet site.

NOTE - The "Relationship View" in Microsoft Access is NOT an ERD.

• Use Microsoft Access to create the preliminary (no keys and no relationships) database tables for the Huffman Trucking Driver Log.

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
Co Driver
Name
Co Driver
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