Preview

Huffmane

Powerful Essays
Open Document
Open Document
1401 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Huffmane
Planning and Creation of a Fleet Truck Maintenance Database for Huffman Trucking
James Adams
DBM/350
Professor Troy Tuckett
March 11, 2013

Creating a Database Design for Fleet Truck Maintenance
The planning designing and creation of the Fleet Huffman Trucking Maintenance Database will identify attributes, tables and fields for all of the service categories for the Huffman maintenance fleet Trucking Company. This database will be developed and design according to the vehicle maintenance activity and repairs to keep vehicles save on the road and save money down the line on the up keep on the vehicles. The Huffman Company will use real time data information pertaining to all the work history activities in the fleet truck maintenance facility.
The tables and entities describe in the fleet truck maintenance database will identify each attributes and a map between relationships that’s in the database, where each components interact with each other in a Query and SQL format. The table below will identify realistic data demonstrating each entity and attributes, regarding the relationship that each table brings to the database functions with populated information to support the table and entity. Entity | Attributes | Vehicles- a table displaying the vehicles in Huffman’s fleet. | * Vehicle_ID (PK) * VIN * Vehicle_detail * Put_inservice_date * Purchase_invoice * Taken_outservice_date | Vehicle_detail | * Veh_detail_ID (PK) * Vehicle_ID * Mileage * Type_ID * Capacity * Class_code * Gross_weight | Vehicle_Invoices- a table displaying invoices for all vehicles purchased. | * Veh_Invoice_ID (PK) * Vehicle_ID * Date_Purchased * Price * Shipping * Tax * FOB | Vehicle_Type- a table displaying the types of vehicles. | * Type_ID (PK) * Description | Maintenance_Descriptions- a table with general details of each maintnenace type | * Maintenance_Type_ID (PK) * Level_code * Description * Avg hours_req



References: Reference University of Phoenix (2007) Microsoft® (2011). Microsoft Access 2007 Retrieved August 11, 2011 from http://office.microsoft.com/en-us/training/CR010158283.aspx

You May Also Find These Documents Helpful

  • Good Essays

    In the file ACC 291 Week 5 Huffman Trucking you will find overview of the following parts:…

    • 686 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Service Request SR-ht-03

    • 569 Words
    • 2 Pages

    Next is the explanation of what are in the tables and the entity relationship between them. Table Tire Maintenance, this table has a relationship with Table Vehicle Maintenance. Their relationship is when the maintenance type ID is entered into the database it is automatically connected to the Table Maintenance work order section of the database. Table Maintenance work order has a relationship with Table Vehicle Types for type of vehicle. Part ID relates to Table parts Inventory Issues to link any kind of parts inventory subjects. Table Parts Inventory Issues has a relationship with Table Parts Inventory Purchases for any type of purchase information. Table Parts Catalogue has relationship with Table…

    • 569 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    As one of its goals, Huffman Trucking would like to be the industry leader in using its technology to the maximum efficiencies when providing their customer service and doing their day to day business. They are the first major freight carrier to outsource its information systems support. Their Finance and Accounting System applications are supported by Smith Systems Consulting and are integrated with the Flight Maintenance System and the Enterprise Transportation Application. These systems are tailored to capture the financial and accounting data and information related to the trucking business. Their system also allows them to maintain their customer data along with their historical sales. Marketing is able to make their plans and budgets electronically available to their management and present them as needed at sale meetings. The Sales Department has established a detailed database of its customers that can be shared with other team members. The Human Resource Department uses an HRIS system that was developed by in-house programmers that tracks employees operationally and financially. Smith Consulting has developed a system for Huffman Trucking and recommends that they convert over in order to further standardize their system.…

    • 474 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Huffman Trucking is a large company and has been around since the early 1900’s. When the company started there was one tractor trailer and now the corporation has seen quite an extensive progression throughout the years. With several types of trailers and large employee base the company has spread out and has facilities located all across the country from New Jersey to California. Huffman Trucking Company consulted with another company known as Smith Systems Consulting to develop entities and attributes for a database for the fleet truck maintenance, but was unable to complete the job successfully.…

    • 699 Words
    • 3 Pages
    Good Essays
  • Good Essays

    DBM380 Week 2

    • 837 Words
    • 3 Pages

    There will be seven tables in this database source system order data, customer data, corrections table data, drop ship corrections, workflow status, end system data, and comparison results table. The source system table will be comprised of columns for customer purchase order number, customer name, transmitted date, and status. The customer table will consist of columns for customer name and customer number. Corrections table will provide columns for customer purchase order number, system reference data, date received and error message. Drop ship table…

    • 837 Words
    • 3 Pages
    Good Essays
  • Good Essays

    BSA 310 Week 1 Assignment

    • 768 Words
    • 5 Pages

    Capture individual truck information showing: times to destination, stop times, driving safety (i.e. stops and starts), speed limit monitoring, etc. to enable Safety guidelines and compliance.…

    • 768 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Dbm380 Wk2

    • 772 Words
    • 3 Pages

    There will be seven tables in this database source system customer data, order data, corrections table data, comparison results table, drop ship corrections, end system data, and workflow status. The source system table will be comprised of columns for customer name, customer purchase order number, status, and transmitted date. The customer table will comprise of columns for customer name and customer number. Corrections table will offer columns for customer purchase order number, system reference data, date received and error message. Drop ship table will consist of customer…

    • 772 Words
    • 3 Pages
    Good Essays
  • Good Essays

    It2640 Week 5 Appendix B

    • 632 Words
    • 3 Pages

    Entities for this database application will include a Customer, Products, Orders, Sales Rep and Shipping table. The attributes for the following tables are as follows:…

    • 632 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    AIS CHAPTERS

    • 371 Words
    • 10 Pages

    shown below. The data are now in first normal form because they can be stored in…

    • 371 Words
    • 10 Pages
    Satisfactory Essays
  • Good Essays

    AIS sample project

    • 554 Words
    • 3 Pages

    specify the primary key, the foreign key (if any), and at least 2 other attributes.…

    • 554 Words
    • 3 Pages
    Good Essays
  • Good Essays

    2. Switch to Datasheet view, enter the records shown in Table 1 below into the Coach table, and then close the Coach table.…

    • 2671 Words
    • 11 Pages
    Good Essays
  • Good Essays

    Ddm/380 Normaliziation

    • 699 Words
    • 3 Pages

    Co-driver name has been removed from the table “Driving Log” because from the Co_Driver_EmpID one can find the driver’s details. In the “Violations” table State/Municipality_Issuing_Citation is removed and “StateID” has been added. A new table “State” has been created to hold StateID, State/Municipality_Issuing_Citation.…

    • 699 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Assignment 1 CS 275

    • 597 Words
    • 3 Pages

    22b) Customer, Payment, Order, Invoice, Order Line, Product (all entities) will be needed for the SQL query.Assignment #1, 11th Edition…

    • 597 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Data Warehousing Failures

    • 5385 Words
    • 22 Pages

    Auto Guys initiated a data warehousing project four years ago but it never achieved full usage. After initial support for the project eroded, management revisited their motives for the warehouse and…

    • 5385 Words
    • 22 Pages
    Powerful Essays
  • Satisfactory Essays

    The main Use-case diagram for “VowCabs Passenger app” shows how the user can access different modules of the application. The user has to first login. Later user can use the different operation of the application.…

    • 1585 Words
    • 7 Pages
    Satisfactory Essays