Create an ERD using Microsoft Access

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

Using Microsoft Access, create the preliminary (no keys and no
relationships) database tables for the Huffman Trucking Driver Log.

HUFFMAN INTRANET

Home

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Huffman/Inter
Site1/HuffmanInterPort.htm" Internet Site

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Huffman/Finan
ce/HuffmanFA005.htm" Finance & Accounting

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Huffman/Sales
/HuffmanSalesMarkOver001.htm" Sales & Marketing

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Huffman/HR/Hu
ffmanAdminOrgChrt001.htm" Human Resources

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Huffman/Labor
Rel/HuffmanHRLabor001.htm" Labor Relations

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Huffman/Opera
tions/HuffmanOps001.htm" Operations

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Huffman/Legal
/HuffmanLeg001.htm" Legal

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Huffman/IT/Hu
ffmanIT001.htm" Information Technology

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/PortBus.htm"
Virtual Organizations



Huffman Trucking

Huffman trucking is a national transportation company. The company's
1,400 employees work in its logistical hubs located in Los Angeles,
California, St. Louis, Missouri, and Bayonne, New Jersey; its central
maintenance facility is in Cleveland, Ohio; and as drivers of its 800
road tractors. The company expects to earn revenues during fiscal year
2004 in excess of $600,000,000.

Mission

Our mission is to be a profitable, growing, adaptive company in an
intensively competitive logistical services business environment.

We will accomplish this by:

Stockholders - every action and decision will be questioned/measured to
assure it is in the best interest of our stockholders.

Customers - provide efficient, reasonably priced, responsive and
competitive services in a customer friendly environment.

Regulatory - we will meet and exceed all safety and environmental
standards for our employees and our equipment.

Employees - we will be foremost in our industry in assuring that our
employees are compensated fairly, are adequately trained and are truly
team members in our business processes.

Stakeholders - we will maintain continuous awareness of our stakeholders
and apply the test of reasonableness to assure our business practices
are commensurate with stakeholder expectations.

Technology - we will be the industry leader in leveraging technology to
the maximum to provide customer service and business efficiencies.

History

Our company had its beginnings in 1936 as "H. Huffman Trucking" and
consisted of one tractor-trailer doing contract haul in and around
Cleveland, Ohio.

World War II created significant demand for carrier services between the
factories of the mid-west and from the factories to the ports on the
East Coast. Our founder, H. Huffman, was able to acquire sufficient
capital during this period to increase the fleet size of Huffman
Trucking to 16 tractors and 36 trailers by 1945. A significant amount of
the tonnage was for the US Government and established a business
relationship that exists to this day. After the end of the war, K.
Huffman joined his father and Huffman Trucking was incorporated in Ohio.

From 1948 through 1976 Huffman continued to experience significant
growth both from internally generated sales and from the acquisition of
5 Eastern regional carriers. With the Motor Carrier Act of 1980
deregulating the trucking industry, we were enabled to become a National
carrier.

 

Copyright 2003, 2005 © by Apollo Group, Inc.

 





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