Environment Case

Database Environment

DBM/380

May 21, 2014

Dennis Sage

Database environment is the configuration type used to create and populate the application. Some definitions of databases consist of items of data which are the facts, images, graphics and text associated with a particular record. Database allows for the organization of collected data.

The environment to be designed is one to store and retrieve data in a way it can be easily organized with the intentions of storing tables with customers purchasing and sales ordering individual information. With this structured organization of information within the database it allows reports to be generated directly relating to each customers history. The history of the customers’ information will consist of purchasing, sales, returns and pending orders and where an order is in the processing process. This will allow the company to provide their customers with accurate electronic information, being their ultimate goal.

After reviewing an audit report it came to their intentions that the company found themselves losing customers records and orders with no ability to provide their customers with a status report of their orders which was a great negative relating to customer service. This will help outline metrics of their ordering process times relating to benchmarks. This review also allows for improvement of the current process based upon areas with low percentage of customer services remarks.

The database will consist of several tables and columns, customer name, transmitted date, current status date, order date, closed date, workflow status, data shipped, and a customer’s order number. The workflow table also simplifies the location and viewing of customers’ individual information.

These customer tables will contain columns a costumers