Preview

Database Management System Implementation Plan

Powerful Essays
Open Document
Open Document
1954 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Database Management System Implementation Plan
Learning Team Assignment: DBMS Implementation Plan
Resource: Virtual Organization for Huffman Trucking
Write a 10-12 page plan for the implementation of an enterprise DBMS for Huffman Trucking. Assume that the Microsoft® Access Fleet Truck Maintenance Database listed on the Huffman Trucking intranet site has been implemented. Assume other departments within Huffman Trucking have stand-alone databases, at least one of which uses database software other than Microsoft® Access. Identify all of your assumptions. Your plan should discuss the details and features of the DBMS that would be implemented, problems that would be addressed by the system implementation, and issues that might be incurred during the system’s implementation.

Introduction

With increasingly more data requiring to be saved, arranged, and accessed in an organization, the requirement to apply and use a good Database Management System (DBMS) has become essential. DBMS systems vary from an easy system for example Microsoft® Access to more complicated systems for example Structured Query Language (SQL) and Oracle. The aim of this analysis is to look into the existing procedures being utilized in Huffman Trucking since they relate with data storing, organization, and accessibility and then to suggest what DBMS system might meet the requirements of the organization.

This evaluation will start looking at the existing DBMS system being used by Huffman Trucking and determine the weaknesses and strengths of the existing process(s). After the research into the existing system is finished, our team will look at different DBMS systems to determine which system would be much better suited to Huffman Trucking. As soon as the DBMS system is determined, our team will show the details and characteristics of the suggested DBMS system which Huffman Trucking must look into to buy and implement. Finally, our team will suggest an agenda for applying the suggested DBMS system, determine which issues in the

You May Also Find These Documents Helpful

  • Good Essays

    There are two different types of requirements for this project. One is the technical requirements of the chosen database system and another is the business requirements of the Huffman Trucking.…

    • 686 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Service Request SR-ht-03

    • 569 Words
    • 2 Pages

    First our team decided on what to incorporate into our database to complete everything needed for Huffman Trucking’s truck maintenance needs. When a part is purchased a record is inserted into Parts Inventory Purchases and Parts Purchasing History adding to the quantity in Parts Catalogue. When a part is issued a record is inserted into Parts Inventory Issues and a quantity is decreased in Parts Catalogue. When a vehicle has maintenance a record is inserted into Maintenance Work Order and Vehicle Maintenance and a quantity is deducted from Parts Catalogue. When there is tire maintenance a record is inserted into Maintenance Work Order and Tire Maintenance is updated.…

    • 569 Words
    • 2 Pages
    Good Essays
  • Good Essays

    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. This paper will talk about how our team completed the Change Request that was on the Huffman Trucking Service Request.…

    • 820 Words
    • 4 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

    A dependable database is required to provide tracking of the scheduled and unscheduled maintenance for their fleet. The development will contain a database with forms, tables, queries, and reports which track maintenance records, inventory of parts, and any purchases from vendors. The entity relationship diagram (ERD) project will reduce down time of each truck in the fleet and guarantee parts availability. The project will also minimize profits loss due to accessibility of trucks, and each hub will be able to access this database. The overall objective is to bring that proposed database to life and allow Huffman Trucking Company to use that database across all of their various locations.…

    • 699 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Huffman Trucking is a trucking company that was established in 1936. Throughout this paper, we will discuss the company’s mission and vision statement. It will also identify the type of organizational structure and how each of those roles supports the company’s goals. The collaboration process among the functional areas must also be established to support the goals. Finally, the stakeholders will be reviewed and how the company plans to protect them and how their communication is vital to the success of Huffman Trucking.…

    • 1443 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    DBM 380 (Data Base Management) Complete Course Material Click on The Link Below to Purchase A+ Work http://hwminute.com/downloads/dbm-380-data-base-management-complete-course-material/ DBM 380 Week 1 DQ 2.docx DBM 380 Week 1 DQ 1.docx DBM 380 Week 1 Individual Assignment Database Design Paper.docx DBM 380 Week 2 DQ 2.docx DBM 380 Week 2 Individual Assignment; Database Management Systems Paper.docx DBM 380 Week 2 DQ 1.docx DBM 380 Week 3 DQ 1.docx DBM 380 Week 3 DQ 2.docx DBM 380 Week 3 Individual Assignment Driving Log.accdb DBM 380 Week 3 Individual Assignment Driving Log.zip DBM 380 Week 3 Individual Assignment ERD.pdf DBM 380 Week 3 Individual Assignment ERD.zip DBM 380 Week 3 Individual Assignment.zip DBM 380 Week 3 Individual Assignment ERD.pdf DBM 380 Week 3 Individual Assignment ERD.zip DBM 380 Week 4 DQ 1.docx DBM 380 Week 4 DQ 2.docx DBM 380 Week 4 Explaination Of Normalization.docx DBM 380 Week 4 Individual Assignment ERD.zip DBM 380 Week 4 Indiviual Assignment Driving Log Relationships.accdb DBM 380 Week 4 Indiviual Assignment Driving Log Relationships.zip DBM 380 Week 4 Individual Assignment ERD.pdf DBM 380 Week 5 DQ 1.docx DBM 380 Week 5 DQ 2.docx DBM 380 Week 5 LT Database FINAL.accdb DBM 380 Week 5 LT Database FINAL.zip DBM 380 Week 5 LT Huffman PowerPoint REVISED.pptx DBM 380 Week 5 LT Huffman Trucking SR-ht-003.docx DBM 380 Week 5 LT Huffman Trucking SR-ht-003.docx $30.00 – Purchase DBM 380 (Data Base Management) Complete Course Material Click on The Link Below to Purchase A+ Work http://hwminute.com/downloads/dbm-380-data-base-management-complete-course-material/ DBM 380 Week 1 DQ 2.docx DBM 380 Week 1 DQ 1.docx DBM 380 Week 1 Individual Assignment Database Design Paper.docx DBM 380 Week 2 DQ 2.docx DBM 380 Week 2 Individual Assignment; Database Management Systems Paper.docx DBM 380 Week 2 DQ 1.docx DBM 380 Week 3 DQ 1.docx DBM 380 Week 3 DQ 2.docx DBM 380 Week 3 Individual Assignment Driving…

    • 395 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Huffman Trucking, a major national freight carrier has encountered tremendous growth over the past few years. The company now has over 1300 employees, 800 road tractors and 2100 trailers. The company has a diverse customer base and shipping ability. Management has realized that the company’s automated information systems infrastructure is lagging. To solve this problem management has decided to implement an Enterprise Resource Planning (ERP) system. Customer sales, orders, tracking, delivery, Maintenance, scheduling and accounting will all be integrated by the ERP.…

    • 1151 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Dbm 380 Week 1

    • 1191 Words
    • 5 Pages

    Database environments are very important in today’s industries. In selecting an organization that will need a database, I choose Smith Consulting. Smith Consulting will need a database to track their consulting staff, each staff member’s skill sets, and what projects they will be working on. This document will provide information on the following area’s listed below:…

    • 1191 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    CMGT 400 Week 1 DQs

    • 676 Words
    • 3 Pages

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    The author of this review, Philip Stieg, is a neurosurgeon-in-chief of New York-Presbyterian/Weill Cornell Medical Center. He has expertise in skull-base surgery and is a known published author as well as an international lecturer. He sees first hand the violence that takes place during the NFL games because he is a neuro-trauma consultant that stands on the sidelines of games. This article discovers the story of concussion incidents in the NFL over the past four decades. It gives an in depth background of the case of Mike Webster, former center for the Steelers. His death in 2002 was found to be linked to chronic traumatic encephalopathy (CTE), making him the first professional football player with a case of this kind. Stieg then goes on to…

    • 167 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    employees who will use the new database some extensive seminars, or other form of training to ensure that users have the knowledge on how the system will work. This will decrease redundancy and decrease data entry errors. I look forward to hearing from you regarding your thoughts, and concerns, with the database.…

    • 329 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Huffman Trucking

    • 1004 Words
    • 5 Pages

    Huffman Trucking is a major transportation company that has four facilities around the country. The organization anticipated that knowledge worker information systems infrastructure requires improvement and to solve this problem, organization implemented enterprise resource planning (ERP) system. The infrastructure of Huffman Trucking is as follows:…

    • 1004 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    New Services provided by Huffman Trucking in order to keep up with the competition will need a budget in marketing, hiring, and new ERP system. Allocations will be necessary to increase competition and overcome economic slowdown. Providing the following services same day delivery, warehousing, and the ERP communications were you can track and place orders online and over the phone. Same day deliveries can be placed with a 12 hour window time. Customers will be willing to pay a little more to receive the items they need for their customers. Warehousing will provide inventory tracking and consultation with its customers’ needs. The warehouse will have access to data on pick-ups and deliveries. A with assumptions on cost will have to be made in order to analyze further inquires of the new strategy. Consider will you will spend on expenses of new strategy will inflate too. Current operating cost fuel expenses, taxes, insurance, employee benefits and depreciation of equipment including new equipment has to be considered. The warehouse is a separate cost and running it will need new employees which will add to the Human resources budget. Training and drug testing for specialize division will also be needed. In increase of the marketing budget which will help with promoting the new service and picking the message including the frequency the message will be delivered. The existing sales force will need information on the service to target new customers; an increase of commission will be added to their salary. The ERP will be installed thru the IT department which will save $200,000 in expenses and efficiency. The new strategy can see increases thru the warehousing and consulting programs.…

    • 294 Words
    • 1 Page
    Satisfactory Essays
  • Powerful Essays

    First of all I would like to thank a lot to my teacher who is an excellent lecturer. Under his guidance, I learnt a lot about DBMS concepts. And as a result, I become able to complete this assignment with confidence.…

    • 737 Words
    • 3 Pages
    Powerful Essays