Riordan Manufacturing Database Plan
Riordan Manufacturing (Riordan) is an industry leader in using polymer materials to produce plastic products with projected annual earnings of $46 millions. Riordan has plastic manufacturing plants in Albany, Georgia, and a custom plastic plant in Pontiac, Michigan. Also, there is a plastic fan manufacturing plant in Hangzhou, China. Riordan also conducts research and development at the headquarters in San Jose, California, (Apollo, 2006). The high demand for materials used in producing plastic products is very important towards Riordan’s development. To develop the current materials ordering system, a database plan is necessary for the use in Business-to-Business websites that will allow Riordan to order materials via the web from its vendors. This database plan will assist Riordan with ordering materials online from its vendors, increase its annual revenue and stay competitive.
Database Plan Description
The database plan is the first step in creating a database for the tracking of purchasing, materials and inventory data while doing business online with Riordan’s vendors. This database will integrate with other databases, such as human resources, sales and marketing, and financial databases to make Riordan operate more efficiently. The database plan includes the following components:
1. Database plan purpose: This step will include the discussion of the purpose of the database that will be used at Riordan.
2. Project plan: The process of building the database is a project. The team will create a detailed project plan that provides tasks, resources, schedules, and a budget that is required to complete the project. In this step, Microsoft Project is used for representing the details of the project. Included in this step are communications and scope change management discussions for managing the database plan effectively.
3. Normalization of the database: This is a critical step for making the database. Normalization will help create table structures as well
Database Plan Description
The database plan is the first step in creating a database for the tracking of purchasing, materials and inventory data while doing business online with Riordan’s vendors. This database will integrate with other databases, such as human resources, sales and marketing, and financial databases to make Riordan operate more efficiently. The database plan includes the following components:
1. Database plan purpose: This step will include the discussion of the purpose of the database that will be used at Riordan.
2. Project plan: The process of building the database is a project. The team will create a detailed project plan that provides tasks, resources, schedules, and a budget that is required to complete the project. In this step, Microsoft Project is used for representing the details of the project. Included in this step are communications and scope change management discussions for managing the database plan effectively.
3. Normalization of the database: This is a critical step for making the database. Normalization will help create table structures as well
References: Apollo (2006). Riordan Manufacturing. Retrieved from https://ecampus.phoenix.edu/secure/aapd/cist/vop/Business/Riordan/RioMfgHome002.htm Database administration (n. d). Retrieved from http://www.siue.edu/~dbock/cmis450/databaseadministration.htm Developing a database plan (n. d). Retrieved from http://msdn.microsoft.com/en-us/library/ms177460.aspx Nemati, H. (n. d). Normalization of database tables. Retrieve from http://www.uncg.edu/ism/ism318/normalization.pdf