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

    TechTarget says “Computer databases typically contain aggregations of data records or files, such as sales transactions, product catalogs and inventories, and customer profiles” (TechTarget pg. 1). This is exactly what Team A plans to accomplish for Huffman Trucking. Huffman Trucking is looking for fleet truck maintenance database to help keep track of all of their truck maintenance needs. The database began on April 1, 2013 and has a scheduled completion date on April 25, 2013. The scope of this service request is to keep track of parts, maintenance, vendors, and vehicles.…

    • 569 Words
    • 2 Pages
    Good Essays
  • Good Essays

    First our team will talk about how Microsoft Access was used to create these tables by Huffman Trucking Database. Then how we used the tables with made up information to be tested on. Then on how we used forms in the maintenance database system. While the creation of relationships and normalization is explained in the process of using queries to search the database (University of Phoenix, 2007).…

    • 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

    Smith Systems Consulting designed and developed exclusive documents for Huffman Trucking Company using the entities and attributes created by Microsoft Access. The forms were created to simplify the entry of records into the database and will streamline the method of entering the parts information, vendor information, vehicle and vehicle maintenance information, and all supplementary associated entities to the Huffman Trucking Project. It is significant the Huffman Trucking Company vehicle upkeep relational database be regularized…

    • 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

    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
  • 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
  • Good Essays

    When using a database, the most important step is knowing how to use the table elements. The table defines the structure of the database based on its entities and Attributes. The entity is the object being stored and the Attributes describe information about the entity and its reason being documented. When using this table, one needs to first know how to access the database, table and forms that need to be used. When they arrive on the database, the user will have to select the table, which will show all the information there is on the vehicles at Huffman Trucking Fleet and the maintenance these vehicles…

    • 690 Words
    • 3 Pages
    Good 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
  • 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