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

Database Mgt Essay

2471 words - 10 pages

Running head: HUFFMAN FLEET TRUCK DATABASE 1HUFFMAN FLEET TRUCK DATABASE 2Planning and Creation of a Fleet Truck Maintenance Database for Huffman TruckingPlanning and Creation of a Fleet Truck Maintenance Database for Huffman TruckingIn 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 AttributesIn 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 IDIssue DatePurchase PriceQuantityIn 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 table will contain a primary key. The creation of a table will have an added attribute; it will be the table's primary key. For instance, in the table "Part_Issues", the primary key will be "Issue_ID." The attributes "Purchase Price" and "Quantity" will be deleted since that data is present in another table and does not directly relate to part issues. The attribute "Description" will be added in order to be able to document the nature of the part issue. Additionally, the rest of the tables will also be assigned a primary key so that each table has a unique identifier. The chart below shows each table name and its corresponding attributes.
Entity

Attributes

Vehicles- a table displaying the vehicles in Huffmans 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
Days_between_rec_maint
Max_days_between_maint

Tire_Maintenance- a table...

Find Another Essay On database mgt

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

Case Study Analysis Part A ("A Power Play for Howard")

1704 words - 7 pages from University of Phoenix, rEsource, MGT-445-InterdisciplinaryCapstone Course Web site.Neiman, M. (2007). Fair game: Ethical considerations in negotiation by sports agents. Texasreview of entertainment & sports law. Vol. 9, Issue 1, pp.123-140. Retrieved July 1, 2009from EbscoHost database.

Functions of Management

1259 words - 5 pages : leading and collaborating in a competitve world, 7e. Retrieved April 25, 2008, from University of Phoenix, Week One, rEsource. MGT/330 - Management: Theory, Practice, and Application Web site.Rodacker, U. (2006). Successful managers. SuperVision, 67 (5), p. 8 . Retrieved April 25, 2008, from ProQuest database.

Non-Discriminatory Work Environment Paper

1015 words - 4 pages PAGE PAGE 3 Non-Discriminatory Work Environment Paper NON-DISCRIMINATORY WORK ENVIRONMENT PAPERNon-Discriminatory Work Environment PaperUniversity of PhoenixEmployment Law MGT/434Nondiscrimination RequirementsUnder HIPAA, individuals may not be denied eligibility or continued eligibility to enrollin a group health plan based on any health factors they may have. In addition, anindividual may not be charged more for coverage than any similarly

Strategic Quality Management and Customer Satisfaction Paper

1367 words - 5 pages /vendor management well to increase efficiency.Analysis of improvement PlanRiordan Manufacturing is in a process of improving the marketing information system. In the past, it uses the most primitive way such as in paper files and microfiche to record the business. Now, it implements CRM computer system to organize the historical sales, file past marketing plans and research, and arrange sales database electronically. This electronic system attempts

MGT 350 Critical Thinking and Decision Making: Decision Making Model

1439 words - 6 pages utilize.ReferencesBassham et al. (2002). Critical Thinking. New York: Irwin/McGraw-Hill Companies. Retrieved July 14, 2004, from University of Phoenix, Resource, MGT/350 Critical Thinking: Strategies in Decision Making Web site: https://ecampus.phoenix.edu/secure/resource/resource.aspJosephson, M. (2002). Making Ethical Decisions. Retrieved July 18, 2004, from http://www.josephsoninstitute.org/MED/MED-4sevensteppath.htmTecker, G., Bower, C. & Frankel, J. (1999). ASAE's new model of decision making. Association Management 51(8), 47. Retrieved July 21, 2004 from ProQuest database.

Ethical Issue in the Workplace and Its Moral Implication

1347 words - 5 pages , 85(10), 1,13-15.Retrieved December 2, 2008, from ABI/INFORM Global database. (Document ID: 1574323271).Yukl, G., 2006. Leadership in organizations: Ethical leadership and diversity [University ofPhoenix Custom Edition e-text]. Upper Saddle River, NJ: Prentice Hall. Retrieve November 29, 2008, from University of Phoenix, MGT 521-Management Course Web site.

Wal-Mart Management Planning and Ethics

1537 words - 6 pages Wal-Mart PAGE 1 Wal-Mart Management Planning and EthicsManagement: Theory, Practice, and Application MGT/330October 6, 2008IntroductionSam Walton founded Wal-Mart and started operations in 1962. It was in the 1980s when this company finally showed that it could succeed. In 1983, the company opened the first Sam's club, and in 1988, the company opened the first Supercenter (Frank, 2006). The company has had opposition, and some bad press

Human factors in aviation

5445 words - 22 pages Executive Park Drive Tucker, GA 30084 Phone: (770) 491-1100 Fax: (770) 491-0739 e-mail: Sonya.Meadows@GalaxyScientific.com Appendix 2: Written Responses Classified by Question Number Basic Information Section #3 Section #4 Section #5 Secti 1 Event UK Country USA Type of Organization. Government/Academic HF Experience 2 Aviation Experience 15 Outstanding sources for instructional information! Will be adding causes and corrections to database system

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

Similar Essays

How A Newly Formed Group Can Become A High Performance Team Through Proper Management Skills

1159 words - 5 pages ://EzineArticles.com/?expert=Glen_FeechanLeavitt, P. (2006) Rewarding Innovation. Retrieved April 1, 2006 from www.bettermanagement.comMSN Encarta. (2006) Team Retrieved from subscription database at www.msn.comSchermerhorn, J., Hunt, J., & Osborn, R. (2005). Organizational behavior [University of Phoenix Custom Edition e-text]. 9th ed. Hoboken, NJ: John Wiley & Sons, Inc. Retrieved March 30, 2006 from University of Phoenix, Resource, MGT

Applying Decision Making Techniques To Identify Solutions

993 words - 4 pages communication necessary to implement the decisions taken. Moreover, all stakeholders concern must be taken into account. These actions will help ensure that implementation actually occurs. (Langdon, K., 2001). References Emstthal, H. (2002, March). Deciding how to decide. Association Management. 54(3), p.42 (4). Retrieved on 05 May, 2009 form ProQuest database. E-Library, University of Phoenix. http

Management Planning Essay

670 words - 3 pages technology can be considered as an addiction to it because works demands it and not because the employee chooses to be that way (Addicted to Technology, 2007).ReferencesAddicted to Technology? There Could Be Legal Repercussions. (2007, August). HR Focus, Retrieved August 01, 2007 from the EBSCOhost database.Bateman, T.S. & Snell, S.A. (2007). Management: The New Competitive Landscape. Retrieved August 01, 2007, from University of Phoenix, rEsource, MGT/330- Management: Theory, Practice and Application Course Website.Persson,D.(2007,July). UNLOCK THE KNOWLEDGE BASE. Communications News, 44(7), 17. Retrieved August 01, 2007 from the EBSCOhost database.

Functions Of Management Essay

1058 words - 5 pages Functions of Management PAGE 1 Functions of ManagementManagement: Theory, Practice, and Application MGT/330September 22, 2008IntroductionIn order for a business to be successful in the world today, they should possess all four of the functions of management. These four functions are planning, organizing, leading, and controlling. It is important that all of these aspects of management be understood to enable a business to be successful at