Free Essay

Database Analyse

In: Computers and Technology

Submitted By lance8427
Words 469
Pages 2
Database Analysis
Lance Washington
CIS/207
October 17, 2011
Andrew Nash

Database Analysis A group of logically related files that stores data and the association among them is called database. To be able to analysis these files, software must be provided. For an operation management major, they must be allowed to access organizational data to determine optimum inventory, knowledge of scheduling their employees, access to ordering product for the store needs, and access to reports to obtain labor and cost control (Rainer Jr. 2011).
There are many organizations that use database to operate their business. Microsoft, Access, DB2, and Oracle are a few database applications available to effectively absorb data. Microsoft is user friendly. It provides the user with the necessary tools to run a successful business. One organization that uses Microsoft is Arby’s. The operational manager at Arby’s organization is responsible for many positions in this company. They must be able to make a schedule, order product, provide reports, and control operations. With Microsoft application, the operational manager is capable of performing his or her duties.
Microsoft provide applications for Arby’s organization called menu link and aloha. Menu link is an application to help the operational manager provide cost and labor reports. The labor management uses POS data to store sales in order to make a schedule. The operation manager inputs the amount of sales use for each day to receive a guideline for how much labor to use for the week. This information is saved and sent to the schedule spread sheet. The spread sheet use is Microsoft excel software. This chart is an example of a schedule. Arby’s takes the daily labor cost and the total hours to achieve the store need for staff on day-to-day bases. The ending results reflect how much labor used for the sales produce on that day.
Once the employee is the schedule and has work a shift; the operational manager can use the Aloha application to look him or her up. Example: if an employee forgot to clock out, the manager can access the employee and adjust their time accurate. Aloha can be used to edit employee’s job codes and the access level as well as pay rate. In conclusion, to improve the database for schedules, Arby’s organization can consider using the Oracle database. This database is much faster and can save the company some cost on IT technology. Installed an Oracle business edition to effectively report and analyze data. Oracle can compress files need to input a schedule so the operational manager do not have to apply the sales for each day. The data can be store for each week and provide the necessary labor guideline to help reduce the labor cost.

References
Rainer Jr, R. (2011). Introduction to Information Systems. Retrieved from https://ecampus.phoenix.edu

Similar Documents

Premium Essay

Big Data

...BUS211f(2) ANALYZING BIG DATA I1 Spring 2014—MW 8:00–9:20 am Location: Sachar 116 (International Hall) Prof. Bharatendra Rai 313-282-8309 (mobile) brai@brandeis.edu Office: Sachar 1C Hours: MW, 9:30 – 10:15 and by appointment TA: TBD This is a two credit module that examines the opportunities and industry disruption in an era of massive, high velocity, unstructured data and new developments in data analytic. We treat some strategic, ethical, and technical dimensions of big data. The technical foci of the course include data structures, data warehousing, Structured Query Language (SQL), and high-impact visual displays. The principal objective of the course is to help students build understanding of data as an essential competitive resource, and acquire advanced computer skills through cases and hands-on applications. Assignments and classroom time will be devoted to both to analysis of current developments in analytics and to gaining experience with current tools.  Davenport , Thomas H. and Harris, Jeanne G. Competing on Analytics: The New Science of Winning. Cambridge: Harvard Business School Press, 2007. ISBN 978-1422103326. Available for purchase at the bookstore.  There is a required on-line course pack available for purchase at the Harvard Business Publishing website at this URL: https://cb.hbsp.harvard.edu/cbmp/access/23455671 This link is also available on LATTE . See last page of Syllabus for course pack contents.  Other readings as posted on LATTE site. Learning Goals...

Words: 2130 - Pages: 9

Premium Essay

Database Theories

...Modern Database Applications | [Type the document title] | | | Contents 1. Gray, J. (2009). Jim Gray on eScience: A transformed scientific method. The Fourth Paradigm: Data-intensive scientific discovery 2 2. Rowley, J. (2007). Wisdom hierarchy: Representations of the DIKW hierarchy. Journal of Information Science 3 3. Goldman, N. (2013). Towards practical, high-capacity, low-maintenance information storage in synthesized DNA. 4 4. Gray, J. (1981). The transaction concept: virtues and limitations. In: VLDB '81: Proceedings of the seventh international conference on Very Large Data Bases 5 5. Codd, E. F. (1970). A Relational Model of Data for Large Shared Data Banks. Communications of the ACM 7 6. Chen, P. (1976). The entity-relationship model: Toward a unified view of data. ACM Transactions on Database Systems 8 1. Gray, J. (2009). Jim Gray on eScience: A transformed scientific method. The Fourth Paradigm: Data-intensive scientific discovery Gray states that there is need to distinguish data-intensive science from computational science; he defines an emerging fourth paradigm for scientific exploration. This paradigm is derived from the deluge of data being produced within scientific research fields, and the necessity for tools which can be utilised within the whole research cycle; data capture, curation, analysis and visualisation. He identified that currently the data being produced is not being organised, or published in a systematic...

Words: 3050 - Pages: 13

Premium Essay

Strategy

...WORLD VISION POSITION DESCRIPTION |KEY POSITION INFORMATION | |Job Title |DM&E Coordinator | |13 | |Reports To |Program Team Leader | |Department/Group |Quality Team |Location |Sarajevo | WORK CONTEXT / BACKGROUND: World Vision’s earliest involvement in Bosnia-Herzegovina (BiH) was in 1994. Over the years, WV BiH has re-shaped its ministry from a largely return-focused program to one in alignment with the country’s basic development needs. WV BiH strategic intent is to contribute towards CWB in BiH (child wellbeing). To date, WV BiH works in partnership with communities, local and national government, faith-based institutions and civil society for the well-being of children. WV BiH makes no distinction of faith, ethnicity or gender when delivering its assistance to children and their families. Currently WV BiH employs 80 staff across the country. The overall annual budget for World Vision Bosnia and Herzegovina is around $4.6 million. PURPOSE OF POSITION: To lead the DM&E processes of intentional design and gathering of evidence of programs. This will be done through the...

Words: 1594 - Pages: 7

Premium Essay

Big Data

...BUS211f(2) ANALYZING BIG DATA I1 Spring 2014—MW 8:00–9:20 am Location: Sachar 116 (International Hall) Prof. Bharatendra Rai 313-282-8309 (mobile) brai@brandeis.edu Office: Sachar 1C Hours: MW, 9:30 – 10:15 and by appointment TA: TBD This is a two credit module that examines the opportunities and industry disruption in an era of massive, high velocity, unstructured data and new developments in data analytic. We treat some strategic, ethical, and technical dimensions of big data. The technical foci of the course include data structures, data warehousing, Structured Query Language (SQL), and high-impact visual displays. The principal objective of the course is to help students build understanding of data as an essential competitive resource, and acquire advanced computer skills through cases and hands-on applications. Assignments and classroom time will be devoted to both to analysis of current developments in analytics and to gaining experience with current tools.  Davenport , Thomas H. and Harris, Jeanne G. Competing on Analytics: The New Science of Winning. Cambridge: Harvard Business School Press, 2007. ISBN 978-1422103326. Available for purchase at the bookstore.  There is a required on-line course pack available for purchase at the Harvard Business Publishing website at this URL: https://cb.hbsp.harvard.edu/cbmp/access/23455671 This link is also available on LATTE . See last page of Syllabus for course pack contents.  Other readings as posted on LATTE site. Learning Goals...

Words: 2130 - Pages: 9

Premium Essay

Sylabiss

...Syllabus School of Business ACC/340 Version 4 Accounting Information Systems I ACC/340 Schedule 10/10/2013 – 11/07/2013 Campus: Puerto Rico Campus Group ID: BA0913RE 3 Credits 36 Hours Copyright © 2009, 2007, 2005, 2004, 2003, 2001 by University of Phoenix. All rights reserved. Course Description This course is designed to provide accounting students with the proper mix of technical information and real-world applications. Areas of study include fundamental concepts and technologies (what computers can do for business), the Internet, intranets, electronic commerce, information systems development, basic project management principles, decision support systems, and the benefits of computer and human synergy. Policies Faculty and students/learners 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 the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality. Course Materials Bagranoff, N. A., Simkin, M. G., & Strand, C. S. (2008). Core concepts of accounting information systems (10th ed.)....

Words: 2552 - Pages: 11

Premium Essay

Lundberg

...KAROLINSKA INSTITUTET a medical university Development of a new tool for healthcare company analysis CMI Corporate Database Jonas Lundberg Supervisor Associate Professor Carl Johan Sundberg Stockholm 2001 Master thesis in medical science with a major in biomedicine Centre for Medical Innovations Karolinska Institutet Sweden Contents SUMMARY....................................................................................................................................3 ABBREVIATIONS........................................................................................................................4 DEFINITIONS ...............................................................................................................................5 PURPOSE OF THE THESIS .......................................................................................................8 INTRODUCTION .........................................................................................................................9 The biotechnology industry in Sweden ...............................................................................9 Technology Transfer at Universities ...................................................................................9 A corporate database as an analytical tool.........................................................................10 Thesis disposition ...........................................................................................

Words: 14471 - Pages: 58

Premium Essay

Information System

...increases profitability. Reengineering is also a trend that organizations adopt in order to stay competitive and to gain competitive advantage. Reengineering means radical design of business processes, organizational structure, information systems and values of the organizations. This process in expensive and requires lot of time but the result can be increase in profitability through streamlining of operations. After implementation of information system businesses organize themselves to improve profitability by providing training and support to employees. By doing so employees will be able to attempt to use the new system at its fully potential. Question 1c): In order to optimize its information management system a company has to analyse and plan an information system. In order to do so the value chain of the organization should be analysed. The business has to look into activities that include inbound logistics, storages, production and manufacturing, finished product storage, outbound logistics, marketing...

Words: 1149 - Pages: 5

Premium Essay

"Enterprise Level Data Work Flows and Data Warehouse

...whom this project would have been a distant reality. We also extend our heartfelt thanks to our family and well wishers. I would like to take this occasion to specially thank University of Northern Virginia to provide us with excellent faculty and also in supporting us getting quality education remotely. Contents SL No Title Page no 1 Abstract 5 2 Introduction to Databases 6 3 OLTP and OLAP Systems 7 4 Difference between OLTP and OLAP 9 5 Data Modeling 13 6 Workflows in Enterprise level Data warehousing 18 7 Business Intelligence tools used in Data flow and Data Warehousing 21 8 Analysis in Data warehousing 24 9 Conclusion 28 10 Foot Note 30 11 References 31 ABSTRACT These days majority of the applications, may it be web applications or windows applications or mobile applications, are completely database dependent. Most of the application developments are becoming database driven environments, hence rendering databases as one of the most key elements in a software environment. This dependency on databases can attributed to the increasing number of data requirements from the...

Words: 6349 - Pages: 26

Premium Essay

Test

...Module 5 Database Management using OpenOffice Base Module Overview Welcome to Module 5 - Database Management using OpenOffice Base. This module explores the building of a database using the OpenOffice 3.0 Base software application. The module is intended to be very hands-on and focus upon two primary areas: the how and why of designing and implementing a database, and to develop a basic understanding of relational database theory. This balance of practice and theory is intended to bring greater design strength and data integrity to your database applications. | Upon completion of this module you will be able to: * Describe a database and how it can be utilised * Discuss the difference between a database and the other applications * Understand how databases are organised and operated * Create a simple database and view database content in various modes * Create a table, define and modify fields and their properties; enter and edit data in a table * Sort and filter a table or form: create, modify and run queries to retrieve specific information from a database * Understand what a form is and create a form to enter, modify and delete records and data in records * Build queries to retrieve and sort data * Create routine reports * Build and print reports for regular and ad hoc reporting of data Terminology | | Database | A database is a collection of related information which is organised into a series of rows (called records) and columns (called...

Words: 20896 - Pages: 84

Premium Essay

4tq4g

...Business Information Systems Elizabeth Hardcastle Download free books at Elizabeth Hardcastle Business Information Systems Download free eBooks at bookboon.com 2 Business Information Systems © 2011 Elizabeth Hardcastle & bookboon.com ISBN 978-87-7681-463-2 Download free eBooks at bookboon.com 3 Business Information Systems Contents Contents 1 Defining Information Systems 7 1.1 Defining Data and Information 7 1.2 Defining Systems 8 1.3 Defining Information Systems 8 1.4 Business Information Systems 8 1.5 Types of business information system 9 2 Hardware 10 2.1 Input devices 10 2.2 Central Processing Unit (CPU) 10 2.3 Internal and External Memory 10 2.4 Output devices 10 2.5 Major categories of computers 11 3 Software 12 3.1 Systems software 12 3.2 Application software 13 The next step for top-performing graduates Masters in Management Designed for high-achieving graduates across all disciplines, London Business School’s Masters in Management provides specific and tangible foundations for a successful career in business. This 12-month, full-time programme is a business qualification with impact. In 2010, our MiM employment rate was 95% within 3 months of graduation*; the majority of graduates choosing to work in consulting or financial services. As well as a renowned qualification...

Words: 20690 - Pages: 83

Premium Essay

Business Information Systems

...owners and entrepreneurs use IS to reach customers throughout the globe. Manager’s use IS to make large investment decisions, like research on a cancer drug or construct a manufacturing plant. Sales representatives utilize in order to advertise products, analyze sales trends and communicate with the customers. Financial planners use information systems in order to advice their customers to help their children's education or them save for the retirement. From a small store to large multinational companies, and various sizes and types of business organizations cannot survive without the business information systems in order perform finance and accounting task. The business information system covers various things such as software, hardware, databases, E-commerce, m-commerce, telecommunications, enterprise resource planning, transaction processing decision and information support, special purpose systems, societal and ethical issues, and systems development. QUESTION ONE 1.1 A system and an information system both use interrelated parts that...

Words: 6879 - Pages: 28

Premium Essay

Syaran

...MEC/CEC, CA/CWA, B.Com & B.Sc. Master Minds 4. Data Storage, Retrieval & DBMS Q.No.1. Write about different coding schemes. BCD: » » » » » » » » » » » » » » » » » » BCD stands for binary Coded Decimal system. This is a 6 bit code i.e. each character is expressed in terms of a 6 bit code. There will be 64 ways of representing digits, alphabets and special symbols. There is no parity bit in this coding scheme. ASCII: ASCII stands for American Standard Code for Information Interchange. This code is extensively used in small computers, peripherals, instruments and communication devices. It is a seven-bit code and has replaced many of the special codes that were previously used. Microcomputers using 8-bit word length use 7 bits to represent the basic code. The 8th bit is used for parity or it may be permanently 1 or 0. With 7 bits, up to 128 characters can be coded. A letter, digit or special symbol is called a character. It includes upper and lower case alphabets, numbers, punctuation marks, special and control characters. Here the first 3 bits are zone bits and the remaining 4 bits represent digit values. ASCII-8: A newer version of ASCII is ASCII-8 code, which is an 8-bit code. With 8 bits, the code capacity is extended to 256 characters. EBCDIC: EBCDIC stands for Extended Binary Coded Decimal Interchange Code. It is a standard character code for large computers. It is a 8-bit code without parity and 9th bit can be used as parity bit. Using 8 bits 256 characters...

Words: 14549 - Pages: 59

Premium Essay

Hands on Database

...HANDS-ON DATABASE AN INTRODUCTION TO DATABASE DESIGN AND DEVELOPMENT Steve Conger Seattle Central Community College Prentice Hall Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Product Development Manager: Ashley Santora Editorial Project Manager: Kelly Loftus Editorial Assistant: Jason Calcaño Director of Marketing: Patrice Lumumba Jones Senior Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Production Project Manager: Renata Butera Creative Art Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Kheng Guan Toh/Fotolia, Inc Media Editor: Denise Vaughn Media Project Manager: Lisa Rinaldi Full-Service Project Management: Chitra Sundarajan/Integra Software Services Pvt. Ltd. Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: Palatino 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 © 2012 Pearson Education, Inc., publishing as Prentice Hall, One Lake Street, Upper Saddle...

Words: 70521 - Pages: 283

Free Essay

Hibernate

...Hibernate allows us to do object relational mapping. Simply this mean, conversion of objects derived from java classes inside the application, directly to tables in the database. This will reduce the effort utilized in drawing ER diagrams, normalization (conceptual design) as well as physically writing SQL coding to complete the physical design inside the RDBMS. Hibernate will prevent getting your java code dirty via writing SQL within it. If you use hibernate, no sql within your java application at all. Also hibernate provides:- • Caching of frequently used data record. Its several times efficient than retrieving from the database. • Needn’t opening and closing database connections. This will prevent memory leakage problems • Allow the java application to work with multiple DBMSes. • Small change in the java code will alter the table in the DB. Needn’t dropping the table. • 80% of code reduction in the application program When the required operation was initiated from the application, hibernate is versatile enough to auto generate the required SQL coding Go to this site called www.hibernate.org/downloads After going into the site .. notice some changes Look at the release bundles .. under the release bundle , download the latest version Add those into the library.. all those jar files to the library And then add a xml file and name as hibernate.cfg And then go to project file and search for a file in the name of hibernate.cfg.xml And from that get the...

Words: 309 - Pages: 2

Premium Essay

Efficiency and Collaboration

...beneficial to switch to a more relational database like Microsoft Access. In turn, this will help improve internal communication and help streamline some of the work processes for the sales department. Currently the Party Plates Company uses Microsoft Excel to track personnel data in a spreadsheet inputting small amounts of repetitious data each time a record is created. Although Microsoft Excel and Microsoft Access offer some of the same tools such as applying filters, sorting table data, and extracting information, Microsoft Access a relational database, has features to track actions and events in multiple related tables. It offers more built in tools better to organize, track, and to make a relational structure between the tables by using a common field for the purpose of creating queries, forms, and reports large amounts of data than Microsoft Excel. The Party Plates Company would benefit from the use of converting their personnel data from single Microsoft Excel spreadsheets into a relational database, such as Microsoft Access (2012 Microsoft Corporation). There are many benefits that Party Plates would get from using Microsoft Access. The cost is reasonable to the other databases available; this system permits customization of databases making it possible to manage other functions together in the same area and not have to use more than one database. Microsoft Access prevents the duplication of the same information entered into the database. This will help save time entering...

Words: 720 - Pages: 3