OPPapers.com

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...