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†¦show more content†¦For the first normal form stage to be reached, there are a few requirements that must be met. First, the database attributes will be checked to make sure that all the key attributes have been included within the entities. Second, each cell will contain only one value and not a group of values. A cell is the intersection between the columns and rows. Third, all of the key attributes that have been defined should be dependent on the primary key. The Riordan Manufacturing database entities contains all of the necessary attributes for each entity and each of these attributes are dependent on the primary key and each cell only contains one value. The Riordan Manufacturing database is in first normal form. For the second normal form stage to be reached, there are only two requirements that will need to be satisfied. One of these is that the database must already be in the first normal form. The other requirement is that the database must not include any partial dependencies. All of the attributes have to be dependent on the whole primary key. The Riordan Manufacturing database is in second normal form since there are no partial dependencies. For the third normal form stage to be reached, there are again only two requirements that must be satisfied. The first one is that the database must already be in the second normalShow MoreRelatedExecutive Summary of Business Processes1183 Words   |  5 Pagesrequirements for computer system enhancements. Riordan Manufacturing needs these enhancements to improve its inventory and manufacturing processes. Executive Summary About Riordan Manufacturing (RM) Dr. Riordan, a chemist, started Riordan Plastics in 1991 as a research and development company based on patents for creating high tensile strength plastic products. Riordan Plastics added manufacturing operations and became Riordan Manufacturing (RM) in 1992 (Apollo Group, Inc., 2006). RM employsRead MoreRiordan Manufacturing Paper2459 Words   |  10 PagesRiordan Manufacturing has grown from a small plastics research and development firm to a multinational plastics manufacturing power in the brief span of 14 years. This growth has seen Riordan expand their operation to multiple manufacturing and distribution points across North America and China. Riordan now services over 32 customers of varying size, including automotive parts manufacturers, aircraft manufacturers, the Department of Defense, appliance manufacturers, and beverage bottlers. This rapidRead MoreRiordan Manufacturing Essay1601 Words   |  7 PagesRiordan Manufacturing Executive Summary: As a Fortune 1000 enterprise, and an industry leader in the field of plastic injection molding, Riordan Manufacturing, offers state-of-the art plastics design capabilities through its facilities in San Jose, California; Albany, Georgia; Pontiac, Michigan; and Hang Zhou, China. Currently, Riordans COO, Hugh McCauley, and the executive team have requested changes to the current information system used to maintain inventory and manufacturing processesRead MoreRiordan Manufacturing Executive Summary1607 Words   |  7 PagesRiordan Manufacturing Executive Summary Ryan Schnabel The University of Phoenix CIS 319 Computer Information Processing Dave Karpinsky March 24, 2005 Executive Summary: As a Fortune 1000 enterprise, and an industry leader in the field of plastic injection molding, Riordan Manufacturing, offers state-of-the art plastics design capabilities through its facilities in San Jose, California; Albany, Georgia; Pontiac, Michigan; and Hang Zhou, China. Currently, Riordans COO, Hugh McCauley, andRead MoreRiordan Manufacturing IS Upgrade Essay1673 Words   |  7 PagesRiordan Manufacturing IS Upgrade Executive Summary IS updates at Riordan Manufacturing are necessary to meet future goals. We would like to be your partner, helping you reach the $50 million dollar revenue target. (Riordan Manufacturing Intranet, 2005) Your current information systems state will not enable Riordan to achieve this mark, especially in the finance, accounting and inventory areas. We will demonstrate how systems upgrades at your Atlanta, Georgia and Pontiac, Michigan plants willRead MoreFinal Paper Bsa/3752199 Words   |  9 Pages This proposal has been prepared for Riordan Manufacturing Company by the BSA/375 Learning Team Corporation. We are pleased to provide this proposal and look forward to working closely with members of the Riordan Manufacturing team. After careful analysis and review, we are confident that our recommendations will greatly enhance Riordan Manufacturing and place them firmly in the lead amongst other companies. In order to create a successful business plan, we first conducted a needs analysis andRead MoreAn Mrp Solution for Riordan Manufacturing5037 Words   |  21 PagesAn MRP Solution for Riordan Manufacturing Table of Contents Executive Summary †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.. 3 Scope †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦. 4 Project Feasibility †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦. 6 Current Operating State †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦ 6 Requirements †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦ 10 Future Operating State †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.. 12 System Components †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦. 14 System Architecture †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Read MoreSystem Design Project Part Ii3662 Words   |  15 Pagescurrent environment, for Riordan s departments, is requiring increased labor in order to process information. The slow consolidation of the operational processes of two divisions with different operation software has become a financial threat to Riordan Manufacturing. Each of the divisions lacks modern technology that is needed to run a highly efficient corporation. Therefore, there is not enough information being shared between customers, sales, finance, manufacturing, and management. The upgradesRead MoreMaterial Requirements Planning System4256 Words   |  18 Pagesï ¿ ½ ï ¿ ½ ï ¿ ½Material Requirements Planning ï ¿ ½ PAGE ï ¿ ½2ï ¿ ½ Material Requirements Planning (MRP) System - Riordan Manufacturing XXXX University of Phoenix BSA/375 XXXX XXXX ï ¿ ½ Abstract At the request of the Chief Operations Officer and the Vice President Operations, Riordan Manufacturing, an evaluation was requested for the development of a Material Requirements Planning (MRP) system. The system is to track and manage raw materials as well as finished product inventory throughout Riordan ManufacturingRead MoreRiordan Service Request - Supply Chain2185 Words   |  9 PagesSummary Riordan Manufacturing â€Å"is a plastics manufacturer employing 550 people with projected annual earnings of $46 million.† (Riordan, 2004) The company headquarters is located in San Jose, California and production sites within Pontiac, Michigan and Albany, Georgia. The Michigan location is responsible for the injection molding process, creating of dies, custom fabrication, design and coloring of plastics. The Georgia site creates unique plastic bottles as specified by the customer. Riordan expanded