DBM 500 Database Concepts - Riordan Manufacturing,Plan for Business to Business Web Site

Running Head: PLAN FOR BUSINESS TO BUSINESS WEB SITE

Plan for Business to Business Web Site

Roger A. Godsey-Bell, Brad Mecha, Matthew Price, and Paul Unger

University of Phoenix

DBM 500 Database Concepts

Instructor: Laura Smith

August 27th, 2007

�

Plan for Business to Business Web Site

Riordan Manufacturing, Inc. is a subsidiary of Riordan Industries, a Fortune 1000 company. Riordan Manufacturing Incorporated, a Fortune 1000 company, is an industry leader in the field of plastic injection molding technology. Founded in 1991 by Dr. Riordan, the company has expanded operations in both the United States and China. The company has projected annual earning of $46 million and has revenues in excess of $1 billion. This paper outlines a database plan to be used in the construction of a Business-to-Business web site that will allow Riordan Manufacturing to order materials via the Internet from its vendors.

Riordan Mansion, Flagstaff

Figure 1

Figure 2

The actual interfaces between Riordan's database and its vendors' systems are outside of the scope of this paper.

Overview of the Database Plan

For each item in Riordan's materials ordering system there will be one or more vendors for the item, including a history of previous orders of that item from that vendor. These histories will include a rating of the quality of materials, cost at quantity, speed of delivery and similar factors necessary for a making a decision regarding which vendor to rely upon. Once a selection is made a link takes the buyer to the vendor's website and depending on the interface, may log onto the vendor's site and take the buyer directly to the page to complete the order. Note that the purpose of this database is to facilitate Riordan's ordering of materials from other companies. The database does not contain the products that...