Database Plan for Riordan Manufacturing Material Ordering

2368 Words10 Pages
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 normal

More about Database Plan for Riordan Manufacturing Material Ordering

Open Document