Free Essay

Database Environment Dbm 380

In: Computers and Technology

Submitted By skds
Words 880
Pages 4
Database Environment
Stephen K.D. Sylvester
DBM/380
15 October 2014
Gary Teed

Today I will be taking to you about the database environment, the term database environment refers to a type of configuration used to create and populate an application. The most commonly used definitions for databases, are items, which include data, which are text, images, graphics and facts associated to something.
A database is a collection of well-organized data, the environment that is to be designed is one that stores and retrieves data that easily maintained and organized. For the purpose of this assignment of the database environment, I have chosen will be a series of tables that store customer information, purchase orders, sales orders and various status point information. The data will be used for a series of reports that will show the status of the purchase orders as it goes through the database system. The goal of this system is to provide an accountable and accurate status of the items purchased that have been logged in the system. Over the last decade our company has had a hard time and struggled with lost records and documentation of purchase orders, with limited visibility on the status of those orders. W have submitted a request to create a well working database for our customer service to access, and be able to quickly and accurately find the status of that purchase order. Also we would like to implement a list of potential orders that may have dropped off, and gone missing and not have been processed. This will provide a metrics for order processing times and to set strides in helping our company. The system will consist of seven tables within the database environment, those seven include customer data, source system data, corrections data tables, workflow, drop ship corrections, comparison results, and end system data. Customer data table will be comprised of columns for customer numbers and names. The source system will be made up of columns for customer purchases for order numbers, names of customers, status and transmitted data. Corrections data tables will be comprised of columns for our customers purchase orders, date received, and any error messages. Drop ship data tables will be comprised of some data from the corrections section table such as purchase orders and error messages. The workflow sections will contain order number and status of those orders. The end system table will be comprised of sales orders, ordering dates, order status, and order numbers.
Finally the comparison table will be the output results of comparing all the tables together against the source system table to end with a complied list of all orders by date range with each status point.
Since customer purchase order number is the common join point from each table it will be the primary connection point. Some of the data contains additional data in the same field as the purchase order number so it will be required to have logic that addresses this to prevent duplication of rows. The data format will be text or numeric based on the type of data to ensure joins work properly. This database will include macros allowing user to import all the data easily without having to key each record manually, as well as allow for manual entry of data. It will also contain macros that complete the necessary reports so the users can perform one click reporting where possible. This will ensure consistency in the output data. The data as it is imported will be appended to the primary tables instead of creating new ones each time so that over time there is a complete database going back far enough to ensure users have enough data to provide status on any purchase order received electronically.
The initial scope of the database is orders placed by EDI or electronic data interchange between customers and supplier. The long-term goal is to also include outbound invoice and advance shipping notice data to be able to do same comparisons by customer or date range with status of those documents as well. The benefit of this database is to provide better control over our data management and be able to provide quicker responses to our customers when inquiring about inbound purchase order documents. Today the data is disjointed and not available in one location making it hard to track the full status of a specific purchase order.
In conclusion the database to be used by customer service and information system support personnel to provide status reports to customers on electronic orders. Having the reports for any orders that have not created a sales order with one click response will allow customer service to be more proactive on potential lost order data. Having this information before the customer calls to get the order into the system and provide fulfillment updates when the customer’s call will improve the relationship between supplier and customer.

References:
The Database Environment Retrieved Oct 15, 2014 from http://www.omputing.surrey.ac.uk/personal/st/A.Browne/CS263/Lecture1Notes.PPT
Managing customer orders with a database Retrieved Oct 15, 2014 from http://office.microsoft.com/en-us/access-help/managing-customer-orders-in-access-HA001034557.aspx
Work order template for database Retrieved Oct 15, 2014 from http://www.blueclaw-db.com/work_order_software_db.htm

Similar Documents

Premium Essay

Senior Systrem Engineer

...College of Information Systems & Technology Bachelor of Science in Information Technology with a Concentration in Information Management The Bachelor of Science in Information Technology (BSIT) degree program is focused on the acquisition of theory and the application of technical competencies associated with the information technology profession. The courses prepare students with fundamental knowledge in core technologies, such as systems analysis and design; programming; database design; network architecture and administration; web technologies; and application development, implementation, and maintenance. This undergraduate degree program includes 45 credits in the required course of study and 15 credits in the concentration. Some courses have prerequisites. In addition, students must satisfy general education and elective requirements to meet the 120-credit minimum, including a minimum of 48 upper-division credits required for completion of the degree. At the time of enrollment, students must choose a concentration. The Information Management concentration is designed to provide coverage of the collection, architecture, modeling, retrieval and management of data for meaningful presentation to the organization. This concentration prepares students to develop, deploy, manage, and integrate data and information systems to support the organization. Note: The diploma awarded for this program will read: Bachelor of Science in Information Technology and will not reflect the......

Words: 1892 - Pages: 8

Premium Essay

Is 380 Assignment 1

...IS 380 Assignment 1 Chapter 1 1. A database stores: a. End-user data: raw facts of interest to end user b. Metadata: data about data, which the end-user data are integrated and managed) 2. A collection of programs that manages the database structure and controls access to the data stored in the database: Database management system (DBMS) 3. This is when you can change the file structure without affecting the application’s ability to access the data: structural independence 4. This occurs when not all of the required changes in the redundant data are made successfully: data anomaly 5. These are the functions of a DBMS: c. Intermediary between user and database d. Enables data to be shared e. Presents the end user with an integrated view of the data f. Receives & translates application requests into operations required to fulfill requests. g. Hides database’s internal complexity from the application programs and users 6. This is the de facto query language and data access standard supported by the majority of DBMS vendors: structured query language (SQL) 7. People naturally have an integrated view of the data in their environment. This leads to a new problem that has evolved with the use of spreadsheets and desktop databases. This problem is users lack proper data-modeling and database design skills. Chapter 2 8. This type of data model was developed in the 1960’s to......

Words: 738 - Pages: 3

Premium Essay

Database Systems and How They Are Used

...Database Systems and How They are Used DBM/380 Week 1 Individual Assignment Craig Gruenbaum Instructor: Kevin Judge Database Systems and How They are used Database systems are utilized in basically every business every day. Businesses use data to perform a multitude of functions, such as sales transactions, customer queries, and the viewing of key performance indicators. Database systems are the management tool that aids in accessing this data. “In a sense, a database resembles a very well-organized electronic filing cabinet in which powerful software (the DBMS) helps manage the cabinet’s contents”(Rob, P., Coronel, C., & Morris, S, 2013). Database Architecture Database Architecture refers to the design of the database. For example, databases can be designed for a single site or multiple sites, have lots of generic data or data designed for a specific purpose, or be transactional or analytical. Take Oracle database architecture for example. “Oracle9i, Oracle8i, and Oracle8 databases are powerful, flexible, and scalable relational database management system (RDBMS) servers that run on a range of computer systems, from personal computers to largest mainframes. Oracle is designed to run effectively in a client/server environment and supports hundreds to thousands of users” (Oracle, "Migration Process", 1998). Summary Without database systems, companies would have no means by which to access the information stored in their databases. This......

Words: 497 - Pages: 2

Premium Essay

Database Environment

...Database Environment DBM/380 The Historic Art Museum of Buffalo, NY needs to keep track of an abundance of information. Such as the artwork, artists, and locations of where the art is displayed or stored within the museum. Unfortunately, the museum is currently using only a Microsoft Office Excel spreadsheet to keep track of the artists, artwork, and their locations. This is not good practice and generally causes hardships for end-users. Therefore, a database will be implemented in order to make the information more readily available and accurate. Objectives of the Database First and foremost, is the objective of the database system - which is to store the following information: which art is owned/possessed, which artists, and the location of the art within the museum. By having this information readily available in a managed database, it can help the museum prepare for showings, buy/sell/trade/acquire artwork, and maintain an accurate inventory. The Database’ Environment The database’ environment shall consist of metadata & data, software, hardware, people to operate the equipment, and the appropriate procedures for the individuals to follow. Within the museum, the following devices (iMac 21.5 inch model) will be used as workstations by employees and networked together in order to access the server of which the database will be stored. The iMac devices are expensive, but have the capability of running Boot Camp for employees that desire to use Windows. And...

Words: 857 - Pages: 4

Premium Essay

Database Design

...Database Design Paper John Hancock DBM/380 April 23, 2013 April Johnson Database Design Paper Database systems are an organized collection of data. The data is normally organized by a couple different methods; structured and unstructured. Database systems make working in a company a lot easier when an employee is looking for information. By having a database management system in the work place the employees will have improved data sharing, data security, data access and better data integration. A couple examples of databases would be Oracle, Microsoft Access and Microsoft SQL Server. Oracle’s primary function is to store and retrieve data as it is requested. Database architecture not only focuses on the design, development, implementation and maintenance of computer programs that store and organize database information for any business or company big or small. Also a database architect my use a vast array of different languages to create a database, one language is called the structured query language or SQL. When I was in the Navy at first I didn’t realize how structured all of the information was and how much information was actually kept on file. Every duty station has a database system that is used which is Oracle. This database in particular is a very great database for the Navy to use because as information is needed a service member can access the information on the Oracle database cloud at any given time. Also the service member will know that the......

Words: 464 - Pages: 2

Free Essay

Smith Consulting Database Environment

...Smith Consulting Database Environment Student Name DBM/380 Date: Instructor name: Smith Consulting Database Environment Smith Consulting’s current employee management system is inefficient involving a one table database, which produces duplication of many attributes throughout the system. The first iteration of database design provided a new version consisting of various one-to-many relationships to link its various modules. There are currently four modules that consist of an employees, jobs, skills, and projects tables. Smith Consulting has many employees filling many jobs descriptions. Furthermore, each job position may encompass many skills. Finally, many employees may be working on many projects. This first iteration of database design provided a database model that is inadequate and requires a return to the database development life cycle (DDLC) to incorporate the needed many-to-many relationships among tables for efficient allocation of human resources in order to better meet company customer needs. An analysis of the database environment has surfaced the various problems and constraints with the current system. This in turn has determined the scope and boundaries for the new system version. An overall objective and supporting objectives provided the needed data specifications, which is depicted in a logical model table and database schema. Database Environment Analysis The current database environment involves a one table database. This current system has......

Words: 2475 - Pages: 10

Premium Essay

Synopsis of Hostel

...tricky task. In the existing system, it is very difficult and time intense process to manage stocks and stores information. The planned system will keep the information of stock and daily sail purchase. This system will also keep the record of employ salaries and other expenses of store. It will reduce the chances of errors and repetition of records and make it trouble-free to get the information of any medicine in the stock. The planned system will facilitate the users for swift and rapid access to the required data. It will provide facility to create eliminate and update the sales and purchase records of the medicines. This computerized system will be implemented for automation of management system by using SQL 2008r as back-end for database and .Net as front end. UNIVERSITY OF AGRICULTURE, FAISALABAD Department of Computer Science (Synopsis for M.Sc. Degree in Computer Sciences) Title: COMPUTERISED MANAGEMENT SYSTEM FOR SHAHEEN CHEMIST SATYANA ROAD, FAISALABAD II. Date of admission : 19thNovember, 2009 Data of initiation (Research) : After approval Probable duration (Research) : 4 Months III. Personal...

Words: 2913 - Pages: 12

Premium Essay

Bsa 375

... |Course Syllabus | | |College of Information Systems & Technology | | |DBM/380 Version 9 | | |Database Concepts | | |July 16, 2012 to August 13, 2012 | | |Group KM11BIT13 | Copyright © 2012, 2010, 2008, 2007, 2006, 2005, 2003 by University of Phoenix. All rights reserved. Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged into the student website to view this document. • Instructor policies: This document is posted in......

Words: 3236 - Pages: 13

Free Essay

Disney World Case Study

...characteristic or quality describing an entity is called a(n): 1. _______ A) attribute. B) key field. C) tuple. D) field. Answer: A Diff: 1 Page Ref: 230 2. The data hierarchy goes from bits and bytes to: 2. _______ A) fields, records, files, and databases. B) entities, attributes, fields, and records. C) records, entities, fields, and databases. D) fields, attributes, entities, and records. Answer: A Diff: 1 Page Ref: 230 3. In a ________ database, parts of the database are stored and maintained physically in one location and other parts are stored and maintained in other locations. 3. _______ A) fragmented B) contiguous C) split D) partitioned Answer: D Diff: 1 Page Ref: 242 4. The type of logical database model that treats data as if they were stored in two-dimensional tables is the: 4. _______ A) network DBMS. B) hybrid DBMS. C) relational DBMS. D) hierarchical DBMS. Answer: C Diff: 1 Page Ref: 236 5. Activities for detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant are called: 5. _______ A) data cleansing. B) data auditing. C) data fragmentating. D) data verifying. Answer: A Diff: 1 Page Ref: 244 6. The popular......

Words: 7242 - Pages: 29

Premium Essay

Database Management System

...DATABASE S YSTEMS DESIGN, IMPLEMENTATION, AND MANAGEMENT CARLOS CORONEL • STEVEN MORRIS • PETER ROB Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Database Systems: Design, Implementation, and Management, Ninth Edition Carlos Coronel, Steven Morris, and Peter Rob Vice President of Editorial, Business: Jack W. Calhoun Publisher: Joe Sabatino Senior Acquisitions Editor: Charles McCormick, Jr. Senior Product Manager: Kate Mason Development Editor: Deb Kaufmann Editorial Assistant: Nora Heink Senior Marketing Communications Manager: Libby Shipp Marketing Coordinator: Suellen Ruttkay Content Product Manager: Matthew Hutchinson Senior Art Director: Stacy Jenkins Shirley Cover Designer: Itzhack Shelomi Cover Image: iStock Images Media Editor: Chris Valentine Manufacturing Coordinator: Julio Esperas Copyeditor: Andrea Schein Proofreader: Foxxe Editorial Indexer: Elizabeth Cunningham Composition: GEX Publishing Services © 2011 Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be reproduced, transmitted, stored or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval systems, except as......

Words: 189848 - Pages: 760

Premium Essay

Application of Mis on Statistical Analysis

...systems 2. Understand how information systems are developed 3. Understand the computer revolution and its impact on the way business is conducted 4. Become familiar with critical-thinking skills in identifying information systems problems and how to investigate existing literature about hardware and software solutions to problems. 5. Know the components and functions of computer systems, both hardware and software. 6. Become familiar with the advances in networking, data communications and the Internet and how they affect the way business is conducted. 7. Identify which information technology tools are used to solve various business problems. 8. Develop proficiency solving business problems using modern productivity tools (e.g., spreadsheet, database) or creating custom programs.   MIS 301: Statistical Analysis for Business At the end of this course students should be able to: 1. Use data from a sample to make inferences about a population. 2. Apply probability theory in decision making situations. 3. Formulate hypotheses for decision making and research. 4. Analyze data using appropriate statistical techniques. 5. Interpret the results of statistical analysis. 6. Present statistical results using graphics, text, and the spoken word. MIS 302: Introduction to Operations Management At the end of this course students should be able to: 1. Define the role of operations and supply chain in an organization and its interactions with business functions such as accounting,......

Words: 3623 - Pages: 15

Premium Essay

Databasse Management

...Fundamentals of Database Systems Preface....................................................................................................................................................12 Contents of This Edition.....................................................................................................................13 Guidelines for Using This Book.........................................................................................................14 Acknowledgments ..............................................................................................................................15 Contents of This Edition.........................................................................................................................17 Guidelines for Using This Book.............................................................................................................19 Acknowledgments ..................................................................................................................................21 About the Authors ..................................................................................................................................22 Part 1: Basic Concepts............................................................................................................................23 Chapter 1: Databases and Database......

Words: 229471 - Pages: 918

Premium Essay

B2B Advantages and Disadvantages

...This page intentionally left blank Te n t h E d i t i o n MODERN DATABASE MANAGEMENT Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Editorial Project Manager: Kelly Loftus Editorial Assistant: Jason Calcano Director of Marketing: Patrice Lumumba Jones Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Senior Managing Editor: Judy Leale Project Manager: Becca Richter Senior Operations Supervisor: Arnold Vila Operations Specialist: Ilene Kahn Senior Art Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Fotolia © vuifah Manager, Visual Research: Karen Sanatar Permissions Project Manager: Shannon Barbe Media Project Manager, Editorial: Denise Vaughn Media Project Manager, Production: Lisa Rinaldi Supplements Editor: Kelly Loftus Full-Service Project Management: PreMediaGlobal Composition: PreMediaGlobal Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: Palatino Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on appropriate page within text. Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation. Copyright © 2011, 2009, 2007, 2005, 2002...

Words: 193467 - Pages: 774

Premium Essay

Statistical Databases

...Statistical Databases Jaideep Srivastava and Hung Q. Ngo, Department of Computer Science, University of Minnesota, 200 Union street, EE/CS Building, room 4-192, Minneapolis, MN 55455 e-mail: srivasta, hngo @cs.umn.edu, ¡   1 Introduction A statistical database management system (SDBMS) is a database management system that can model, store and manipulate data in a manner well suited to the needs of users who want to perform statistical analyses on the data. Statistical databases have some special characteristics and requirements that are not supported by existing commercial database management systems. For example, while basic aggregation operations like SUM and AVG are part of SQL, there is no support for other commonly used operations like variance and co-variance. Such computations, as well as more advanced ones like regression and principal component analysis, are usually performed using statistical packages and libraries, such as SAS [1] and SPSS [2]. From the end user’s perspective, whether the statistical calculations are being performed in the database or in a statistical package can be quite transparent, especially from a functionality viewpoint. However, once the datasets to be analyzed grow beyond a certain size, the statistical package approach becomes infeasible, either due to its inability to handle large volumes of data, or the unacceptable computation times which make interactive analysis impossible. With the increasing sophistication of data collection......

Words: 11702 - Pages: 47

Premium Essay

The Electoral System in United Kingdom

...The electoral system in United Kingdom The electoral system in United Kingdom After the examination of Canadian national institution, it has been nominated that a few reforms are intensely needed in the Canadian institutions for the due management of the regional and the inter-governmental issues (Loiacono, 2010). The three suggested reforms are the reforms in the Supreme Courts, the reforms in the senate, the reforms in the House of Commons Supreme Court The need for the reform is elevated by considering the fact that is it logical to consider Supreme Court as a general court of appeal and are their any specialized needs of constitutional tribunals. The scope of judicial proceedings and judgments needs to be institutionalized in the context. Quebec is indeed the province that responds assertively to the importance of a pure judiciary. Quebec highlights that the existing Supreme Courts are totally appointed in the conformance of federal executives, and it does not differentiate the difference between civil law and the British common law. Additionally the decisions of the Supreme Court are confirmed to be biased against the Quebecers. The debate since 1950s still needs a re-modification in the form of a pure Canadian Supreme Court, where the law holds every Canadian equal in the court of law (Sherman, 1999, p. 68). Senate The second modification proposed is the modification in the senate. The Canadian federation has long been considered to seek the reform in the...

Words: 3665 - Pages: 15