Database Environment
The database environment refers to the type of configuration used to populate and create the application. The common definitions for database items include data which is the facts, text, images and graphics associated with a record. A database is a way to collect and organize that data. The environment to be designed is one to store and retrieve data in a way it can be easily organized. For the purpose of this assignment the database environment will be a series of tables which store customer, sales order, purchase order and various status point information. This data will then be used for a series of reports to demonstrate status of the purchase order as it flows through the system. The ultimate goal is by customer provide an accurate status of their purchase order that is submitted electronically.
Over the last 10 years our company has struggled with lost electronic orders and no visibility into status. The request has been made to create a database for customer service to access to be able to have one click access to status of a purchase order easily. Also required is a list of any potential lost orders for research to ensure customers are not calling on orders we have not yet processed. This will also help to define metrics around order processing times to set benchmarks for what is happening today and establish improvements in those processing times.
There will be seven tables in this database source system order data, customer data, corrections table data, drop ship corrections, workflow status, end system data, and comparison results table. The source system table will be comprised of columns for customer purchase order number, customer name, transmitted date, and status. The customer table will consist of columns for customer name and customer number. Corrections table will provide columns for customer