DBM380 Week 2
Week 2 Individual
Wendell Taylor
DBM/380
Sanford Schram
The database environment refers to the type of configuration used to populate and create the application. A database includes items such as text, images and graphics associated with a record. The main purpose of a database is 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 overall goal is to be able to provide the customer an accurate status of their purchase order that is submitted electronically. This company has struggled with lost electronic orders and no visibility into status for over the last 5 years. The request has been made to create a database for customer service to access to status of a purchase order in just one click. This database will also create a list of any potential lost orders for research to ensure customers do not call on orders that have not been processed yet. 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 purchase order number, system reference data, date received and error message. Drop ship table
Wendell Taylor
DBM/380
Sanford Schram
The database environment refers to the type of configuration used to populate and create the application. A database includes items such as text, images and graphics associated with a record. The main purpose of a database is 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 overall goal is to be able to provide the customer an accurate status of their purchase order that is submitted electronically. This company has struggled with lost electronic orders and no visibility into status for over the last 5 years. The request has been made to create a database for customer service to access to status of a purchase order in just one click. This database will also create a list of any potential lost orders for research to ensure customers do not call on orders that have not been processed yet. 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 purchase order number, system reference data, date received and error message. Drop ship table