Premium Essay

Entities and Attributes for Fleet Truck Maintenance

In: Computers and Technology

Submitted By sammyd25
Words 1514
Pages 7
Proposed Purpose for the Database

Huffman trucking utilizes this database to maintain and access important data about Huffman Trucking’s fleet vehicles such as vehicle and tire maintenance services, work orders, and unique vehicle identification information. Additional information that can be found in the database is vendor contact, parts inventory, and purchasing history. This database provides an efficient way to track and schedule routine maintenance, track parts inventory which helps prevent slowdowns in production.

Parts Inventory Purchases
Transaction ID Auto Number Primary Key
Purchase Date Date/Time
Purchase Price Currency
Quantity Numeric Value

Rationale of primary key –
The Transaction ID should be a unique number which can be tracked back to the parts inventory purchase table and will make a perfect Primary Key.

Rationale for foreign key 1 –
There will be no foreign keys in this table as no other table for the Fleet Truck Maintenance will be using one of the values as a Primary Key.

Rationale for foreign key 2 –
There will be no foreign keys in this table as no other table for the Fleet Truck Maintenance will be using one of the values as a Primary Key

Parts Inventory Issues
Transaction ID Auto Number Foreign Key 1
Issue Date Date/Time
Purchase Price Currency
Quantity Numeric Value
Parts Inventory ID Auto Number Primary Key

Rationale of primary key –
The parts inventory ID will be used as the primary key for the Parts inventory issues as it will be an auto number. The transaction ID can’t be used as it is already a Primary Key for another Table.

Rationale for foreign key 1 –
The Transaction ID will be Foreign Key 1 as it is being used as a Primary Key for the parts inventory table.

Rationale for foreign key 2 –
There will be no foreign key2 in this table as no other table for the Fleet Truck Maintenance

Similar Documents

Free Essay

Huffman Fleet Truck Database

...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 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 Attributes In the Entities and Attributes for Fleet Truck Maintenance document, the entities and their attributes are clearly defined. The entities are listed in all capital letters. The entity’s respective attributes are listed below the entity. For example, for the entity “Parts_Inventory_Issues”, the attributes listed in the document are: * Transaction ID * Issue Date * Purchase Price * Quantity In creating the table, the attributes must be examined to ensure that the table is organized logically and contains no chances of redundancy. Because of this, the entities and attributes used in the actual database will be modified from the attributes listed in the document. Repeating attributes will be deleted or reorganized to ensure logical structure...

Words: 2654 - Pages: 11

Premium Essay

Huffman Truck

...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 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 Attributes In the Entities and Attributes for Fleet Truck Maintenance document, the entities and their attributes are clearly defined. The entities are listed in all capital letters. The entity’s respective attributes are listed below the entity. For example, for the entity “Parts_Inventory_Issues”, the attributes listed in the document are: • Transaction ID • Issue Date • Purchase Price • Quantity In creating the table, the attributes must be examined to ensure that the table is organized logically and contains no chances of redundancy. Because of this, the entities and attributes used in the actual database will be modified from the attributes listed in the document. Repeating attributes will be deleted or reorganized to ensure logical structure. Each...

Words: 968 - Pages: 4

Premium Essay

Dbm 380 Week 4 Huffington

...disposal. Although Huffman has been extremely successful, the need to remain competitive by use of information technology has been a challenge. It is the first company that has been recognized to outsource 100% of its information systems support. Due to the large fleet in use by Huffman Trucking through-out its many locations, the need arose for an equipment maintenance tracking system which could be accessed globally. Service Request Requirements Huffman initiated a service request for the development and design of a fleet truck maintenance database with Smith Systems Consulting. Though Smith Systems Consulting developed entities and attributes for the Fleet Truck Maintenance database, the company did not develop the database itself. According to service request SR-HT-003, the expected result of the service request is the creation of Entity-Relationship Diagrams for the Fleet Truck Maintenance database. Change Request No. 2 Change Request 2 was submitted by the IT Project Manager. This request is for the creation of the database tables for the Fleet Truck Maintenance database. These tables were created using the entities and attributes developed by Smith Systems Consulting. Process of Using Entities and Attributes The process for...

Words: 1864 - Pages: 8

Free Essay

Database Concepts

...years. The company has grown into a multi million-dollar company with over 1,400 employees and hundreds of vehicles. Huffman Trucking needs a better way to track the maintenance on their fleet of tractors, trailer and the roll-on/roll-offs. The fleet has to undergo periodic maintenance. Plan Putting the equipment's maintenance history, the parts used and vendor information into one database will save Huffman Trucking time and money. The database can include parts inventory information, parts catalogue information, the vendors used and their associated information, and parts purchasing history. The database will include all the maintenance history on each piece of equipment, such as the maintenance of the equipment itself, tire maintenance, the type of maintenance and the maintenance work orders. Conclusion Building a database saves money on maintenance by reducing redundant information and improving record keeping. Both the service and accounting departments will be able to utilize this database to keep track of parts purchases and costs. Having all the information in one central database would allow the diverse facilities to use the database. This type of centralization would bring more accuracy in Huffman Trucking's record keeping and would save money, time and manpower. 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...

Words: 1795 - Pages: 8

Free Essay

Dbm/380 Learning Team Week Final Project

...(Huffman Trucking, 2012). Learning team D’s project is to develop database design documentation for Huffman Trucking for their fleet truck maintenance. Huffman trucking interviewed members of their staff from different departments and proposed entities and attributes for their database. Entities proposed are numerous: Parts Inventory Purchases, Parts Inventory Issues, Parts Catalogue, Vendors, Parts Purchasing History, Vehicle Maintenance, Tire Maintenance, Maintenance Descriptions, Vehicle Types, Vehicles, and Maintenance Work Order. (Apollo Group, 2007). The expected end result from Huffman trucking is documentation showing entity relationship diagrams with referential integrity, data entry forms, SQL table join query code with results, and a normalized database that observes the business rules proposed by Huffman Trucking. Stages of Development In the first stage of development, we took the list of entities and their attributes proposed by our client and acquainted ourselves with their business and processes. The entities proposed by Huffman Trucking were numerous: Parts Inventory Purchases, Parts Inventory Issues, Parts Catalogue, Vendors, Parts Purchasing History, Vehicle Maintenance, Tire Maintenance, Maintenance Descriptions, Vehicle Types, Vehicles, and Maintenance Work Order. Initially we organized these entities along with their attributes according...

Words: 2177 - Pages: 9

Premium Essay

Week 5 Summary

...sectioned the work off and kept in touch this has served us well. We followed the link to Entities and Attributes for the Fleet Truck Maintenance page and have been working on how we are going to incorporate them all into our design. We will use relational links where applicable to tie all the tables together and select appropriate primary keys for our tables. We have also gone through the process of assigning appropriate data types for your fields. All in all, I think that we are off to a good start and are looking forward to adding to our project over the coming weeks. Week 3 Summary Report Our team was required to create documentation that explains the process of creating the entity-relationship diagram (ERD) in the change request for our project. We have three parts for our ERD: Vehicles, Parts, and Maintenance. Part One: Vehicles Our entities for the first part of our ERD are Vehicles, Vehicle Types, and Vehicle Maintenance. Our attributes for the entity Vehicle consist of VIN, Type ID, Class Code, Put into service date, Gross Weight, Mileage, Purchase Price, Accumulated Depreciation, Taken out of service Date, and capacity. The attributes for entity Vehicle Types are Type ID, Description, and VIN. The attributes for the entity Vehicle Maintenance are listed as Vehicle Serial Number, Vehicle Part ID, Maintenance Type ID, Put in service date, Last maintenance data,...

Words: 1227 - Pages: 5

Premium Essay

Computer

...Week One: Database Architecture | | Details | Due | Points | Objectives | 1.1 Explain database architectures. 1.2 Define database systems. 1.3 Define relational database architecture. | | | Reading | Read Ch. 1, “Database Systems,” of Database Systems: Design, Implementation, and Management. | 9/24 | | Reading | Read Ch. 2, “Data Models,” of Database Systems: Design, Implementation, and Management. | 9/24 | | Reading | Read Ch. 3, “The Relational Database Model,” of Database Systems: Design, Implementation, and Management. | 9/24 | | Reading | Reference Ch. 1, “Getting Started,” of Database Concepts as a supplemental reading. | 9/24 | | Reading | Read Ch. 1, “Introduction to Access,” of Exploring Microsoft® Office Access 2010 Comprehensive. | 9/24 | | Reading | Read this week’s Electronic Reserve Readings. | 9/24 | | Participation | Participate in class discussion. | All week | 2 | Nongraded Activities and Preparation SkillSoft® Registration | The first time you access SkillSoft®, you need to register.Do the following to register for SkillSoft®: Go to https://uopx.skillport.com Register by clicking on Register. The Register button is in the lower right corner, below the login boxes.Leave the Organization Code field blank.Use your phoenix.edu e-mail address.Use your student website login name as your user ID (the name before the @email.phoenix.edu).Click Submit. | 9/24 | ...

Words: 2242 - Pages: 9

Premium Essay

Bsa 375

... | | |Database Concepts | | |July 16, 2012 to August 13, 2012 | | |Group KM11BIT13 | Copyright © 2012, 2010, 2008, 2007, 2006, 2005, 2003 by University of Phoenix. All rights reserved. Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged into the student website to view this document. • Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality. Course Materials...

Words: 3236 - Pages: 13

Premium Essay

Chichi

...relatively easily understood bird's-eye view of the data environment. Since the conceptual model focuses on the main data objects and avoids detail, it exhibits both software and hardware independence. The most widely used conceptual model is the Entity Relationship (E-R) model, which yields the basic database blueprint. Internal The internal model represents the adaptation of the conceptual model to a specific DBMS. Basically, the internal model requires the database designer to match the conceptual model's characteristics and constraints to those of the selected hierarchical, network, or relational DBMS. Therefore, although it is still hardware-independent, it is software-dependent. External The external model represents the applications programmer's view of the data environment. Its use requires that the modeler subdivide a universal set of requirements and constraints into functional modules, each represented by its own external model. (The modules correspond to business units such as production, sales, personnel, and so on.) Each external model is represented by its own external schema. Each business unit is thus represented by an external model that includes that unit's entities, the relationships between the entities, and its constraints. Since external models are defined for a specific DBMS, they are DBMS (software)-dependent, but hardware-independent. The use of external schemas has several important advantages: □ Using database subsets makes it...

Words: 11031 - Pages: 45

Premium Essay

Ford Motor

...PART I. ITEM 1. Business Ford Motor Company (referred to herein as "Ford", the "Company", "we", "our" or "us") was incorporated in Delaware in 1919.  We acquired the business of a Michigan company, also known as Ford Motor Company, which had been incorporated in 1903 to produce and sell automobiles designed and engineered by Henry Ford.  We are one of the world’s largest producers of cars and trucks.  We and our subsidiaries also engage in other businesses, including financing vehicles. In addition to the information about Ford and our subsidiaries contained in this Annual Report on Form 10-K for the year ended December 31, 2011 ("2011 Form 10-K Report" or "Report"), extensive information about our Company can be found at www.corporate.ford.com, including information about our management team, our brands and products, and our corporate governance principles. The corporate governance information on our website includes our Corporate Governance Principles, Code of Ethics for Senior Financial Personnel, Code of Ethics for the Board of Directors, Standards of Corporate Conduct for all employees, and the Charters for each of the Committees of our Board of Directors.  In addition, any amendments to our Code of Ethics or waivers granted to our directors and executive officers will be posted in this area of our website.  All of these documents may be accessed by going to our corporate website and clicking on "Our Company," then "Corporate Governance," and then "Corporate Governance...

Words: 16716 - Pages: 67

Free Essay

Online Files

...Chapter Eleven: Order Fulfillment Along the Supply Chain and Other EC Support Services 11-1 Online File W11.1 What Services Do Customers Need? Insights on online customer services: ◗ Customer preferences. Customers tend not to do much self-service in terms of getting information from companies (e.g., only 19% use FAQs), so they require attention. As more companies offer online self-service, though, this situation is changing. When contacting companies for information, customers use e-mail more than the telephone (71% versus 51%). ◗ Types of service. Four types of service exist, based on where the customer is in the purchase experience: during shopping (search products, compare, find product attributes); during buying (questions on warranties, billing, receipt, payment); after placing the order (checking status in processing and in shipping); and after receiving the item (checking return procedures, how to use the item). ◗ Problem resolution. Customers expect quick resolutions to problems, and expect problems to be resolved to their satisfaction. Therefore, easy returns and order tracking are desirable. ◗ Shipping options. Several shipping options are usually needed to make customers happy. ◗ Fraud protection. Customers need to make sure that sellers or others are not going to cheat them (Chapters 9 and 14). ◗ Order status and updates. Customers want to have some way to check on the status of their order, which involves tracking either by phone or online. These services...

Words: 7887 - Pages: 32

Free Essay

Discrete Event System

...PART ONE Introduction to Discrete-Event System Simulation 1 Introduction to Simulation A simulation is the imitation of the operation of a real-world process or system over time. Whether done by hand or on a computer, simulation involves the generation of an artificial history of a system, and the observation of that artificial history to draw inferences concerning the operating characteristics of the real system. The behavior of a system as it evolves over time is studied by developing a simulation model. This model usually takes the form of a set of assumptions concerning the operation of the system. These assumptions are expressed in mathematical, logical, and symbolic relationships between the entities, or objects of interest, of the system. Once developed and validated, a model can be used to investigate a wide variety of “what-if” questions about the realworld system. Potential changes to the system can first be simulated in order to predict their impact on system performance. Simulation can also be used to study systems in the design stage, before such systems are built. Thus, simulation modeling can be used both as an analysis tool for predicting the effect of changes to existing systems, and as a design tool to predict the performance of new systems under varying sets of circumstances. In some instances, a model can be developed which is simple enough to be “solved” by mathematical methods. Such solutions may be found by the use of differential calculus, probability...

Words: 33852 - Pages: 136

Premium Essay

Waste Mangement

...Waste Management, Inc. Strategic Case Analysis Submitted for Approval to: Dr. Jifu Wang LEADING EDGE CONSULTING Houston, TX The Leaders in Waste Management Group 1 Consultants Jason Cummings Correen Harrell Deanna Lewis Jim Upchurch David Woods Page 3 of 163 Table of Contents 1.0 2.0 2.1. 2.2. Executive Summary..........................................................................8 Background Information on Waste Management ..........................9 Brief History of Company............................................................................... 9 Historical Timeline of Important Events...................................................... 11 3.0 External Analysis ............................................................................13 3.1. General Environmental Analysis ................................................................. 13 3.1.1. Political/Legal Factors.............................................................................. 13 3.1.2. Economic Factors .................................................................................... 16 3.1.3. Sociocultural Factors ............................................................................... 20 3.1.4. Demographic Factors............................................................................... 21 3.1.5. Technological Factors.............................................................................. 25 3.1.6. Global Factors ...............................................

Words: 39684 - Pages: 159

Premium Essay

Smart Phones Use in Business

...Smart Phones Use In Business Smart phones are utilized in business and personal use. Smart phones are being used personally to keep in contact with families and friends and to assist in school work. The purpose of this report is to show how smart phones have advanced from a personal device to a device utilized by businesses to increase their efficiency and profitability. Today’s smart phones are powerful enough to deliver 95 percent of the functionality of typical information a worker needs during the course of a workday. The need to be tethered to a PC could become a thing of the past sooner than you think. The demand from customers and suppliers will push corporations toward adopting smart phone technology strategies. Today’s rapidly growing rate of technology is a main factor of the overall productivity rate of companies in the United States. These technologies range in many ways from computer systems to the smart phones carried by many executives and their employees every day. These mobile devices are being used to be able to stay on top of personal and business needs through e-mails, reports, appointments, and phone calls. One of the most known and commonly seen examples of this rapidly growing technology we all see every day is the smart phone. The smart phones are becoming a standard accessory that is carried everywhere by people of all ages. Smart phones are even being used more today than laptop computers. They are also being used more than office phones...

Words: 3172 - Pages: 13

Premium Essay

Ups : Strategic Analysis

...UPS: Strategic Analysis United Parcel Service, Inc. (“UPS”) was founded in 1907 as a private messenger and delivery service in Seattle, Washington. Today, UPS is the world’s largest package delivery company and the premier provider of global supply chain management solutions. They deliver packages each business day for 1.1 million shipping customers to 7.7 million consignees in over 220 countries and territories. In 2011, they delivered an average of 15.8 million pieces per day worldwide, or a total of 4.01 billion packages. Total revenue in 2011 was $53.1 billion (UPS, 2011). UPS serves the global market for logistics services, which include transportation, distribution, forwarding, ground, ocean and air freight, brokerage and financing. Their technology seamlessly binds their service portfolio. They have three reportable segments: U.S. Domestic Package, International Package and Supply Chain & Freight. An in-depth SWOT analysis was performed in order to develop new strategies for the company. External Analysis: Customer Analysis According to the UPS website (Datamonitor, 2011), the company does well in providing a diversified set of services through its three business segments of the end markets: UPS’ US domestic package business segment; UPS’ international package business segment; and the supply chain and freight business segment. UPS’ US domestic package business segment is engaged in air and ground delivery of small packages up to 150 pounds in weight and letters...

Words: 6529 - Pages: 27