Riordan Manufacturing Business-To-Business Database System

Abstract

Riordan Manufacturing is seeking a database system to facilitate web-based communication between employees and vendors to increase the efficiency of the materials purchasing process. Preliminary design estimates indicate that the application will include functions for current inventory management, automated and manual ordering, and order status tracking. The users of the database and website will include specified vendors, purchasing managers and personnel, and production managers. When this database project is completed, the application will provide the users with a real-time picture of the company's inventory and orders as well as orders which are being shipped. This database will greatly enhance the efficiency and effectiveness of Riordan Manufacturing's procurement processes.

Abstract 2

Project Plan 3

Project Risks 5

Project Resources 6

Communication Plan 7

Implementation Plan 8

Training Plan 10

Support Plan 11

Database Project Plan Summary 12

Riordan Business-to-Business Database Normalization 13

Normalizing the Riordan Database 13

Advantages and Disadvantages 15

Riordan ERD Overview 16

Entity Descriptions 17

Normalization Summary 18

Riordan Manufacturing UML Diagrams 19

Riordan Manufacturing Use Case Diagram 19

Riordan Manufacturing UML Sequence Diagram 20

Riordan Manufacturing UML Class Diagram 20

Riordan Manufacturing UML Modeling Summary 20

Database Management / Administration Plan 20

Database and Location Selection 21

Maintenance 22

Disaster Recovery 23

Appendix A - Riordan Manufacturing BtoB E-R Diagram 25

Appendix B - UML Use Case Diagram 26

Appendix C - UML Sequence Diagram 27

Appendix D - UML Class Diagram 28

Reference 29

Project Plan

The project's planned purpose is to provide Riordan Manufacturing with the necessary requirements for the successful implementation and maintenance of a database solution.

Riordan Mansion, Flagstaff

Riordan Mansion, Flagstaff

Riordan Mansion, Flagstaff

This database solution is intended to provide the company with better management and control of the company's inventory. Additionally the management and control will include a database plan to develop a Business-to-Business (B-to-B) website that will...