Preview

Database Plan for Riordan Manufacturing Material Ordering

Powerful Essays
Open Document
Open Document
2376 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Database Plan for Riordan Manufacturing Material Ordering
Learning Team C
Database Plan for Riordan Manufacturing Material Ordering

Kishan Bhagan

Amir Bashir

Eric Berger

Shawn Chandler

Debra Hanzlik

University of Phoenix

DBM 500

October 22, 2006

Facilitator: Dr. Gary Page

Table of Contents
Introduction
Database Plan Description
Database Plan Purpose
Project Plan
E-R Diagrams
A Description of the Normalization of the Database
UML Diagrams
Class Diagram
Use Case
Sequence Diagram
Database Administration Plan
Disaster Recovery Plan
Risk Assessment - Impact
Communication Plan – Roles and Responsibilities
Prevention Plan
Implementation Plan
Disaster Recovery Process Introduction
This manual defines the comprehensive database plan for Riordan Manufacturing material 's ordering database. Team C, consisting of Master degree-seeking students at University of Phoenix Online, has created this database plan. The assignment was completed in 6 weeks.
Riordan Manufacturing, Inc., a Fortune 1000 enterprise, provides plastic injection molding using state-of-the art design methods and tools. Already an industry leader, Riordan Manufacturing has four facilities both in the United States and abroad. A database is needed for use in a Business-to-Business Web site that will allow Riordan Manufacturing to order materials via the Web from its vendors. Team C 's purpose is to create the database plan only.
Database Plan Description
The database plan is the first step in creating a database. It includes the following items and as appropriate each will be created using Microsoft Project, Microsoft Visio, or Microsoft Office 's Word applications:
1. Database Plan Purpose
2. Project plan
3. E-R diagrams
4. Description of the normalization of the database
5. UML diagrams
6. Database administration plan
7. Database recovery plan
The database plan involves the following tasks, which are the same steps that need to be addressed regardless of the size and complexity of this database



References: Rob, Peter and Coronel, Carlos. (2005). Database Systems: Design, Implementation, and Management. United States: Thomson Course Technology. Apollo Group (2004). Riordan manufacturing network diagram. Retrieved October 1, 2006 from University Of Phoenix Virtual Organizational Web Site on the World Wide Web at: https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Riordan/IT/RioITNetwork001.htm

You May Also Find These Documents Helpful

  • Best Essays

    Riordan Manufacturing has requested that an ERP (Enterprise Resource Planning) be developed and used in the San Jose, California; Albany, Georgia; Pontiac, Michigan; and Hangzhou, China offices. The goal of this ERP project is to stream line the manufacturing, distribution, and inventory management systems across all plants and to use only one system. The newly proposed system will give Riordan Manufacturing a wealth of opportunity to grow its business and sustain the customers that it has already. The new system will assist the company in obtaining the goals that it has set forth with in its missions statement by providing solutions for its customers.…

    • 4147 Words
    • 17 Pages
    Best Essays
  • Good Essays

    University of Phoenix. (2004). Riordan manufacturing virtual organization [Computer Software]. Retrieved November 24, 2009, from University of Phoenix, rEsource, Simulation, OPS571 -Operations Management Course Web site.…

    • 932 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    The current supply chain process in place is not efficient to the Riordan Manufacturing Company. The main problem is no communication between departments, factories, and suppliers, which is causing abundance of wasted man hours and over production of products. The goal is to provide communication between departments, factories, and suppliers; thus creating an efficient and effective way of meeting customer expectations and reduce product waste.…

    • 2175 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    Cybex International

    • 503 Words
    • 3 Pages

    In the new system, customer’s orders are accepted at the corporate web site. Each order is electronically forwarded to one of the company’s two specialized manufacturing plants. The ERP uses its planning module to calculate which parts are needed for each model. The ERP’s configurator constructs in just a few seconds, a component list and bills-of-materials needed for each order.…

    • 503 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Ops 571 Week 4 Team

    • 959 Words
    • 4 Pages

    References: University of Phoenix: Riordan Manufacturing, Inc. (2012). Retrieved October 28, 2012 from University of Phoenix website: https://ecampus.phoenix.edu/secure/aapd/cist/vop/index.html…

    • 959 Words
    • 4 Pages
    Better Essays
  • Powerful Essays

    Apollo Group, Inc.. (2004). Riordan Manufacturing. Retrieved July 6, 2007, from University of Phoenix, Week Four, rEsource. BSA/310 Business Systems Web site.…

    • 3150 Words
    • 13 Pages
    Powerful Essays
  • Powerful Essays

    References: Apollo Group. (2005, 2006, 2012, 2013). Riordan Manufacturing Intranet Portal Site. Retrieved from: Virtual Organization Portal https://ecampus.phoenix.edu/secure/aapd/cist/vop/Business/Riordan/index.asp…

    • 1520 Words
    • 7 Pages
    Powerful Essays
  • Better Essays

    Database plan purpose: This step will include the discussion of the purpose of the database that will be used at Riordan.…

    • 3100 Words
    • 13 Pages
    Better Essays
  • Powerful Essays

    In reviewing the current and historical sales and marketing information for Riordan Manufacturing, Inc., it became clear that there is a need for a new streamlined system to track the past and present workings of the company. There are past marketing plans being stored in one location in a file cabinet, limiting the personnel that has access to it (Riordan Manufacturing, Inc., 2012). Sales employees are using different methods to track their numbers, in some cases using pencil and paper (Riordan Manufacturing, Inc., 2012).…

    • 2262 Words
    • 10 Pages
    Powerful Essays
  • Satisfactory Essays

    • Define database architecture. For the database systems in your workplace, identify which architecture they fall under.…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Riordan Strategic Plan

    • 731 Words
    • 3 Pages

    University of Phoenix. (2013). Riordan Manufacturing. Retrieved from University of Phoenix, MGT498 - Strategic Management website.…

    • 731 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Riordan Security Issues

    • 1371 Words
    • 6 Pages

    Riordan manufacturing is a plastic injection molding company based in San Jose. The company also has various operations in 3 other Michigan cities as well as one overseas office in China. “Riordan has a 46 million annual earning” and their major customers are automotive parts manufacturers, aircraft manufacturers, the Department of Defense, beverage makers, bottlers, and appliance manufacturers”, (UOP Virtual Organization, 2006). This company was started by a chemistry professor in 1993 and has expanded over the last 7 years. In 2006 Riordan has projected to increase their sales from 46 million to 50 million dollars but in order for Riordan to keep pace with its competitors they will need to look at choosing a better method of reporting and collecting their sales and marketing information technology system.…

    • 1371 Words
    • 6 Pages
    Powerful Essays
  • Better Essays

    Riordan Manufacturing infrastructure revolves around informal and formal power structures and like many other manufacturing organizations, its vision starts from top management. According to Riordan Manufacturing (Organizational Charts- Executive), the information displays a narrow span of control, with product base and manufacturing decisions are based solely on a centralized view. Formal power structure in Riordan is mechanistically based on a clear chain of command that processes a more managerial hierarchy. Formal power structures based on a narrow span of control negatively affects Riordan’s informal structure bases and instances including employee turnover.…

    • 1492 Words
    • 6 Pages
    Better Essays
  • Powerful Essays

    To help increase sales and decrease over allocation of goods, LTB will be implementing an inventory system which will be available to all facets of Riordan Manufacturing. Riordan executives have allocated a budget of $150,000 which is required to include all the necessary software, hardware, training and implementation necessary to bring inventory systems into current market standards. Each SDLC process plays a critical role in the successful outcome of Riordan manufacturing. Through system investigation, analysis, design, implementation and maintenance, LTB will ensure Riordan 's inventory system will continue to run efficiently into the future.…

    • 3470 Words
    • 14 Pages
    Powerful Essays
  • Best Essays

    Riordan Manufacturer is a global producer of plastics. They operate in four locations, three in the United States and one plant in the People’s Republic of China. Riordan’s United States’ plastic products include beverage containers produced in Atlanta, Georgia and custom plastic parts in Pontiac, Michigan. The Hangzhou, China plant produces plastic fan parts and corporate headquarters is in San Jose, California, (Apollo Group, 2006). Riordan Manufacturing is looking to update their Sales and Marketing Department with the newest and latest software recommendations. The following is a summary of the history, current set up of the department and a recommendation of the upgrade.…

    • 2807 Words
    • 12 Pages
    Best Essays