This website uses cookies to ensure you have the best experience. Learn more

Huffman Trucking Database Essay

761 words - 3 pages

Huffman Trucking Database

The driving log was broken up into 11 tables. The database is in the third normal form or Boyce Codd Normal Form (BCNF) (Pratt & Adamski, 2005, p. 153). This level of normalization ensures no repeating groups, no key column is dependent on only a portion of the primary key, and the only determinants that are contained are candidate keys. The company has four locations in the United States and services 925 drivers. Normalization to the third normal form is sufficient due to the relatively small database, the number of daily updates and the nature of the information. The database is searchable, and due to the naming methodology, is platform independent. Care was taken to omit reserved words from the major databases: Oracle, Sybase, MySQL, PostgreSQL, and DB2 (Box, 2004). An Entity Relationship Diagram for the database is shown in Figure 1.

Figure 1. Driving Log ERD
The state table was created to make a drop down list field to select a state from a list while entering data to the database. The state field is pre-populated with all the states of the union and is connected to the violations table and the driver tables.
The violations table was created to document driving violations to local and state laws. The date of the citation, nature of the offense, state of the occurrence (linked with the state table), municipality where committed, status of the citation, and the disposition and driving points deducted from the driver’s record are kept here. The restrictions field was added to allow the employer to be alerted when a driver exceeds the allowed points to their record and may be suspended from driving.
The employees table has the name, employee ID license number, state (linked with the state table) and emergency contact (linked with the emergency table).
The emergency contact table contains emergency information for two possible contacts. Name, phone, and addresses of each contact are the fiends for this table.
The driver table contains fields concerning the driver only and has their home address, home state (linked with the state field), license number, home telephone and mobile telephone.
The berth table contains fields concerning the times and dates when the driver was in the berth and not driving. The driver can...

Find Another Essay On Huffman Trucking Database

Huffman Trucking Essay

2882 words - 12 pages receipts, and misfiled maintenance documentation, senior management has finally made the decision to take action. “Pen and paper” record keeping is no longer making the grade here at Huffman Trucking. The maintenance facility located in Cleveland OH needs to adopt automation and the need for a Fleet Truck Maintenance Database Management System has now become “top priority.” Our recommended solution for the manually managed maintenance issue

Constitutional Rights Essay

1051 words - 4 pages The Constitution of the United States, or Bill of Rights, was developed to protect individuals by enforcing certain laws throughout the land and is bound under the federal government and each state. The rights of individuals expand out to businesses, employees, and consumers. This paper will discuss two specific constitutional rights that may impact the employees of Huffman Trucking. Huffman Trucking will be doing an analysis of the search and

database mgt

2471 words - 10 pages . In a table, or relation, the entities and attributes of a table define the structure of a database. An entity is an object of importance about which data can be captured. An attribute is the information that describes the entity. When creating the tables for the Huffman Trucking Fleet Truck Maintenance, entities and their relationships must be taken into consideration (Koenke & Auer, 2010).Selection of Entities and AttributesIn the Entities

Enterprise DBMS Implementation

2694 words - 11 pages The implementation of a database management system (DBMS) solution for Huffman Trucking will provide the company with better management and control of the company's inventory. Integrated into this solution is an online management and control system, which will include a website that will allow Huffman Trucking to complete transactions. The system implementation process has many inherent risks and the project team will attempt to limit risk from

A Review of Huffman Trucking Telephone and Data Networks

6563 words - 26 pages enhancements will not only meet the current needs of the company as a whole, but will also allow for growth into the future. The IT Department will accomplish these tasks by upgrading and documenting the current communications systems. In addition to system recommendations, proposed costs estimates will also be provided.Upon reviewing the current Huffman Trucking communication systems, the IT Department observed many issues and hardware items to

When the Bubble Burst

1539 words - 6 pages By the time I arrived state side from my second tour in the Middle East the housing bubble had already burst. I noticed a drastic change in the way that many of my friends and family were living. Several of my friends that worked in real estate had sold their boats and seconds houses. My own stock portfolio had lost a third of its value. My sister and her husband had defaulted on their home mortgage leaving them scrambling for a place to live. I

phase diagram

4456 words - 18 pages Introduction: Chemical equilibrium is a crucial topic in Chemistry. To represent and model equilibrium, the thermodynamic concept of Free energy is usually used. For a multi-component system the Gibbs free energy is a function of Pressure, Temperature and quantity (mass, moles) of each component. If one of these parameters is changed, a state change to a more energetically favorable state will occur. This state has the lowest free energy

Revolutionary Work of Art

1890 words - 8 pages Walter Benjamin emphasizes in his essay, “The Work of Art in the Age of its Technological Reproducibility” that technology used to make an artwork has changed the way it was received, and its “aura”. Aura represents the originality and authenticity of a work of art that has not been reproduced. The Sistine Chapel in the Vatican is an example of a work that has been and truly a beacon of art. It has brought a benefit and enlightenment to the art

Enlightenment Thought in New Zealand Schools

1594 words - 6 pages In this essay I will be looking at how the political and intellectual ideas of the enlightenment have shaped New Zealand Education. I will also be discussing the perennial tension of local control versus central control of education, and how this has been affected by the political and intellectual ideas of the enlightenment. The enlightenment was an intellectual movement, which beginnings of were marked by the Glorious Revolution in Britain

Psychological Egoism Theory

2240 words - 9 pages The theory of psychological egoism is indeed plausible. The meaning of plausible in the context of this paper refers to the validity or the conceivability of the theory in question, to explain the nature and motivation of human behavior (Hinman, 2007). Human actions are motivated by the satisfaction obtained after completing a task that they are involved in. For example, Mother Teresa was satisfied by her benevolent actions and

How Celtic Folkore has Influenced My Family

1587 words - 6 pages Every family has a unique background that influences the way they live and interact with other people. My parents, who emigrated from Ireland to the States with my three brothers in 1989, brought over their own Celtic folklore and traditions that have helped shaped the way our family operates and lives. One aspect of folklore that has helped shape my family dynamic is the Celtic cross—both its background and what role it has played in our lives

Similar Essays

Huffman Trucking: Database Implementation Essay

714 words - 3 pages IntroductionHuffman Trucking, a Cleveland, Ohio logistics firm that recently acquired five regional carriers (Huffman Trucking, 2005) contracted American Success Consulting (ASC) to develop an enterprise-level information system solution to enable the company to meet established business goals. ASC is beginning this effort by conducting an investigation and feasibility study for building a relational database. In this study we will address the

Huffman Trucking Company: Database Management System Request For Proposal: Description Of Team Red Consulting, Inc

1005 words - 4 pages termination.TRCI afforded the opportunity to propose an enterprise investigation and feasibility study on the development of database management system for the Huffman Trucking Company (HTC), per their service request SR-ht-002. The database is designed for the transportation department, specifically their vehicle maintenance scheduling system.The TRCI members that will complete HTC's service request SR-ht-002 are the following:- Project Manager: Laine

Huffman Trucking Intranet Essay

571 words - 2 pages The Huffman Trucking Intranet critical to the business of Huffman Trucking. An intranet is a private computer network that uses internet technology to share an organization's information or operational systems securely with its employees. Huffman trucking is a national transportation company with 1,400 employees at logistical hubs located in Los Angeles, California, St. Louis, Missouri, and Bayonne, New Jersey. Its central maintenance facility

Virtual Organization Staffing Strategies Case Study Huffman Trucking

968 words - 4 pages requires that HRM proactively stay ahead of the ever-changing legal landscape.The United States does not have specific legislation to protect employee information like that found in many European countries, but one should not assume or dismiss US privacy protections as inadequate. Huffman Trucking takes the privacy of the organizations employees very seriously. The employment database is, "Integrated to track employees from an operational and