One is the technical requirements of the chosen database system and another is the business requirements of the huffman trucking the business requirements define the boundaries in which the project team has room to operate in huffman requires that the new system be relatively inexpensive with little ongoing maintenance required. Database management systems 3rd edition 3rd third edition by ramakrishnan raghu gehrke johannes published by mcgraw hill 2002 convoy trucking police test answers diving and hyperbaric medicine course description predictive maintenance strategy. The 33 revised full papers and 16 short papers are organized in topical sections on safety cases, impact of security on safety, fault tree analysis, safety analysis, security aspects, verification and validation, platform reliability, reliability evaluation, formal methods, static code analysis, safety-related architectures.
Team red consulting, inc (trci) began their consulting firm with over 20 plus years of information technology experience trci has five years of successful development and deployment of database management systems specializing in the areas of fleet maintenance for transportation companies. Huffman trucking has turned to our company to examine their existing database procedures, determine the weaknesses and strengths of their existing database system, and suggest both an improved database system as well as methods the system may be applied in the organization. Huffman trucking needs a reliable database system to store all of their vehicle maintenance scheduling requirements (wwwadvantrackcom)the purpose of the database is to provide the htc with a system for tracking scheduled maintenance for their vehicles. The central maintenance facility for huffman trucking is presently sited in cleveland, ohio and at the moment has facility locations in california, st louis, los angeles, bayonne, missouri, and new jersey.
Maintenance of the hr database, payroll, intranet and all employee records preparation of hr reports and other reports as required by management undertaking general hr administrative functions including preparation of employee contracts and letters of engagement and updating the organisational chart. Huffman trucking is a trucking company that purchase and absorb other smaller trucking company with over 1,400 employees, 925 drivers, 425 support personnel and having a fleet of vehicles, cars and service trucks, by having a databases that can track large group of information. The huffman fleet maintenance database was created using microsoft access which is a database management system team d accessed the huffman trucking intranet site to gather all information required to create the database. Huffman trucking the analysis team has reviewed the numbers from the income statement and balance sheet for 2010 and 2011 using horizontal, vertical, and ratio analysis to determine huffman trucking’s financial position and trends over the past two years.
The cost of huffman trucking project includes, but is not limited to programmers, personnel for implementation, training personnel, project analysis, yearly analysis, and support personnel for a three-year period. Planning and creation of a fleet truck maintenance database for huffman trucking in creating a database, the most vital steps are identifying the table elements upon analysis of the entities and attributes for fleet truck maintenance form, the elements of the database tables can be identified in a. Huffman trucking and the modern maintenance database essay sample huffman trucking is a virtual organization that was founded in 1936 by k huffman with a single truck and a trailer the company grew during world war 2 and forged a relationship with the united states government hauling cargo for them and continues to do so today.
Huffman trucking fleet maintenance database solution introduction huffman trucking is a privately held national transportation company with just under 1,400 employees and facilities across the united states. View dbm 380 week 5 huffman fleet truck maintenance database from cmgt 431 at university of phoenix running head: fleet truck maintenance database huffman fleet truck maintenance find study resources. The places change, the numbers change, but the choice of weapon remains the same in the united states, people who want to kill a lot of other people most often do it with guns.
At the request of the huffman trucking maintenance department, smith consulting developed entities and attributes for their fleet trucking maintenance database. Huffman trucking essay sample smith consulting was hired by huffman trucking maintenance to develop entities and attributes in order to develop a truck maintenance database the b team has been asked to take on this project by taking the completed documentation and creating a database. Huffman trucking operating systems university of phoenix css561 huffman trucking operating systems huffman trucking is a national trucking firm with offices in california, missouri, new jersey and ohio.
Smith systems consulting has done an analysis of huffman trucking to develop a basic plan for integrating information into a database entities and attributes have been defined by smith systems, but the relationships and tables of the database still need to be defined. 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. The report is among the most comprehensive reviews of the global petrochemicals sector and follows other reports in the series, including the impact of air conditioners on electricity demand, the impact of trucking on oil demand, or the role of modern bioenergy in the renewables sector. Open document below is an essay on huffman trucking maintenance database design and development from anti essays, your source for research papers, essays, and term paper examples.
According to service request sr-ht-003, we were to develop a design for a fleet truck maintenance database, located on the huffman trucking it service requests site. Entities and attributes for fleet truck maintenance this document was created by smith systems consulting at the request of huffman trucking maintenance department the descriptions provided are based on interviews with maintenance personnel who use the fleet truck maintenance database. Database creation huffman trucking essays and term papers search results for 'database creation huffman trucking' cmgt/410 huffman trucking training project huffman trucking training project huffman trucking is a nationwide transportation company that employs more than 1300 people at their facilities in ohio, california. This erp will facilitate full integration of huffman trucking processes the erp will integrate all major business components to include linkage to: the customer sales order, tracking service and bill of lading signature (delivery), preventative maintenance and overhaul requirements, hr and driver scheduling, general ledger, accounts payable.