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