Dbm380 Wk2

Database Environment The database environment refers to the kind of structure used to establish and create the application. The mutual definitions for database items contain data which is the facts, text, images and graphics related to a record. A database is a way to assemble and arrange that data. The environment to be considered is one to collect and recover data in a way it can be easily structured. For the principle idea of this assignment the database environment will be a progression of tables which sales order, store customer, purchase order and various status point information. This data will then be used for a progression of reports to determine status of the purchase order as it runs through the system. The principle goal is by customer provide a precise status of a purchase order that is submitted electronically. Over the last 10 years our company has fought with lost electronic orders and no outlook into status. The appeal has been generated to produce a database for customer service to retrieve, to be able to have one click access to status of a purchase order effortlessly. Also vital is a register of any impending lost orders for research to confirm customers are not asking on orders we have not yet handled. This will also help to outline metrics around order handling times to set standards for what is occurring today and create enhancements in those processing times. There will be seven tables in this database source system customer data, order data, corrections table data, comparison results table, drop ship corrections, end system data, and workflow status. The source system table will be comprised of columns for customer name, customer purchase order number, status, and transmitted date. The customer table will comprise of columns for customer name and customer number. Corrections table will offer columns for customer purchase order number, system reference data, date received and error message. Drop ship table will consist of customer