Database for Business-to Business Web Site
DBM 500, Database Concepts
Instructor: Joe Omokheyeke
University of Phoenix Online
November 1, 2010
Background and Description of Database Plan database plan capable of helping Riordan Manufacturing, Incorporated achieve their identified business goals. Riordan Manufacturing, a Fortune 1000 enterprise, is a leading global plastics manufacturer specializing in both standard injection molding and customized plastic parts with four locations both in the United States and abroad. Mark Neitzel, Vice President of Operations at Riordan Manufacturing, has requested a database for a Business-to-Business (B2B) website for its domestic plastic sales (University of Phoenix, 2007). Mark Neitzel and remaining Riordan leadership believe the ability to order materials directly from vendors via the web will bring much-needed efficiency to the current supply chain. The project team will create a database plan capable of helping Riordan Manufacturing, Incorporated achieve their identified business goals.
Database Plan Description The database plan is the first step in database creation and it will the address the following topics in details: • Database Plan Purpose • Project Plan • Entity-Relationship (E-R) Diagrams • Database Normalization Details • Unified Modeling Language (UML) Diagrams • Database Administration Plan to include Database Recovery
The desired database may include the ability to maintain data associated to the following functions: • Purchases (including sales tax and shipping) • Accounts Payable (for reconciliation with accounting department) • Accounts Receivable (for reconciliation with accounting department) • Vendors (including contact