...MC0067 - 01 Marks - 40 DBMS (OBMS & ORACLE 91) 1. Write a note on File based system/ Data base system Solution: File-Based Systems: Conventionally, Before the database Systems evolved , data in the software’s Systems was stored in and represented using flats files. Drawbacks of File-Based Systems: File - Based Systems [pic] As shown in the figure, in a file-based system, different programs in the same application may be interacting with different private data files. There is no system enforcing any standardized control on the organization and structure of these data files. • Data Redundancy and Inconsistency Since data resides in different private data files, there are chances of redundancy and resulting inconsistency. For example, in the above example shown, the same customer can have a savings account as well as a mortgage loan. Here the customer details may be duplicated since the programs for the two functions store their corresponding data in two different data files. This gives rr.>e to redundancy in the customer's data. Since the same data is stored in two files, inconsistency arises if a change made in the data in one file is not reflected in the other. • Unanticipated Queries In a file-based system, handling sudden/ad-hoc queries can be difficult, since it requires changes in the existing programs. • Data Isolation Though data used by different programs in the application may be related, they reside in isolated data files. ...
Words: 4599 - Pages: 19
...8 IDEAS FOR ACCOUNTING BI SUCCESS Business Intelligence (BI)is a phrase that can mean many things. This white paper is focused on the topic of Business Intelligence for the accounting department. Your accounting department’s BI solution should serve your needs effectively. BI for accounting should be considered successful when the authorized accounting department staff have all the necessary software tools required to see the information in all necessary formats to answer all questions asked in the allocated time. Accounting departments need to have a window into the hundreds of tables of data that are stored in databases controlled by the accounting software. They also need to be able to manipulate that data for both compliance and ad-hoc purposes. Lastly, they need the ability to do this without taxing IT resources. If your organization is involved in, or considering a BI implementation, you know there are a lot of options out there. Many solutions are even providing specialized platforms for supporting line-ofbusiness applications. The promises of these BI options are shortened implementation cycles and reduced costs. Many vendors have gone a long way towards making data warehousing and BI tools more available and affordable for the mid-market. However, the mid-market accountant’s true needs are often underserved, resulting in large additional investments. These additional costs are due to the fact that you also need to spend time building on top of the platform that the...
Words: 2072 - Pages: 9
...Data Mining/Data Warehousing Matthew P Bartman Strayer University Ibrahim Elhag CIS 111– Intro to Relational Database Management June 9, 2013 Data Mining/Data Warehousing When it comes to technology especially in terms of storing data there are two ways that it can be done and that is through data mining and data warehousing. With each type of storage there are trends and benefits. In terms of data warehousing there are 5 key benefits one of them being that it enhance business intelligence. What this means is that business processes can be applied directly instead of things having to be done with limited information or on gut instinct. Another benefit of data warehousing is that it can also save time meaning that if a decision has to be made the data can be retrieved quickly instead of having to find data from multiple sources. Not only does data warehousing enhance business intelligence and save time but it can also enchance data quality and consistency.This is accomplished by converting all data into one common format and will make it consistent with all departments which ensures accuracy with the data as well. While these key benefits another one is that it can provide historical intelligence which means that analayze different time periods and trends to make future predictions. One other key benefit is that it provides a great return on investment. The reason being that a data warehouse generates more revenue...
Words: 2018 - Pages: 9
...FEDEX CASE 1. List the business processes displayed in the video: 1. Federal express currier picks up a package 2. Currier scans the box to electronically alter FedEx that the package is in their hands 3. Packages are brought to a hub (a large FedEx warehouse) 4. Packages are unloaded onto a conveyer belt that carries to a scanner that weighs the boxes and measures the size. This tells FedEx how much to charge the customer for shipping. 5. Packages go to a multidirectional scanner, with 40 cameras that scans and inputs the label. Labels tells the scanner where the box is being shipped 6. Any package that can not be scanned is sorted manually 7. Packages are then diverted automatically (or manually for packages that are not able to be scanned) and pushed down slides to their respective locations to be put into cargo containers 8. Each cargo container is weighed and then loaded onto a plane 9. FedEx air control center routes the plane and monitors flying conditions 10. Packages are still being monitored here 11. Plane lands, packages go to another sorting center 12. Packages are put on a truck and delivered to your door 2. List the types of information systems shown in the video. Can you describe how systems that were not shown might be used at FedEx? The information systems shown in the video are: * Management Information System (MIS): The FedEx system is set up to track packages at each point in their delivery process...
Words: 1696 - Pages: 7
...Running head: PROJECT PORTFOLIO Project Portfolio Project Portfolio ExxonMobil is one of the largest publicly traded petroleum and petrochemical enterprises in the world. It started out as a regional marketer of Kerosene. They have three familiar brand names which are: Exxon, Esso and Mobil. The first oil well was built in 1859 (exxonmobil.com). ExxonMobil uses different types of technology every day like surveillance, network computers, communication devices, etc. Being a big corporation like this requires an IT Department. We’ve learned these past eight weeks about the use of technology tools, Porter’s Five Forces Model, Agent based technologies, business planning, and technology in present and future. Throughout this paper I will relate the information that I have learned and talk about how these areas can help it remain a competitive business. People, Information and Information Technology play an important role when it comes to helping the company remain competitive in the industry. ExxonMobil tries to teach their employees to have the best technical and leadership capabilities. They provide their employees with formal training and a broad range of global experiences to prepare them to be the next generation of ExxonMobil leaders. Not only do they want to hire exceptional employees at the corporate headquarters, but also at all their branch locations as well. The employees throughout the organization set goals, carry out tasks, make decisions, and serve customers...
Words: 2101 - Pages: 9
...Marketing for the 21st Century Questions to be answered 1. Why is marketing important? 2. What is the scope of marketing? 3. What are some fundamental marketing concepts and new marketing realities? 4. What are the tasks necessary for successful marketing management? Reviewing important marketing concepts, tools, frameworks and issues. The Importance of marketing * Creating demand * Introduce and gain acceptance of new products * Increasing demand creates jobs * Allow firms to more engage in socially responsible activities The scope of marketing Marketing is about identifying and meeting human and social needs. 1. Meeting needs profitably Marketing is the activity, set of institutions, and processes for creating, communicating, delivering and exchanging offerings that have value for customers, clients, partners, and society at large. We see marketing management as the art and science of choosing target markets and getting, keeping and growing customers through creating, delivering and communicating superior customer value. Important part of Marketing (Peter Drucker) The aim of marketing is to know and understand the customer so well that the product of service fits him and sells itself. Ideally, marketing should result in a customer who is ready to buy. All that should be needed then is to make the product or service available. What is marketed Marketers market 10 main types of entities: * Goods physical products ...
Words: 2406 - Pages: 10
...2014 episode of Mad Men (appropriately entitled “The Monolith”, a clever nod to the iconic black monolith which provides the impetus for the evolutionary leap from beast to man in Arthur C Clarke’s novel “2001: A Space Odyssey”) Sterling Cooper & Partners, the fictional ad agency around which the show revolves, purchases and installs a brand new IBM 360 computer. While the vast majority of the office greets the massive, expensive machine with much apprehension (“What man lay on his back counting stars and thought about a number?” asks Don Draper, head of the Creative Department (played by John Hamm)) (Stevenson, 2014), Senior Partner and visionary Jim Cutler (played by Harry Hamlin) understands the power and potential of just such a machine, particularly in the field of advertising. Sterling Cooper & Partners gain an edge that their competition would not have for several more years, as well as a service they can offer their customers, one many of whom would not provide for themselves for even longer. What Jim Cutler was envisioning was a strategic idea currently referred to as Business Intelligence. A Brief History of Business Intelligence The concept of Business Intelligence (BI) began as a direct descendent of an information system called the Decision Support System (DSS), a system used for complex decision making and problem solving (Khan & Quadri, 2014). During the post war industrial and technological boom of the late 40’s and 50’s, new ideas and techniques...
Words: 2993 - Pages: 12
...of Customer Relationship Management (CRM) software. Our research has highlighted that most institutions take a rather narrow view of CRM and as such, benefits have been limited. While second generation CRM has emerged to embrace the total organisation (hence Enterprise CRM), success in general has still not been widespread. In the paper, a framework is presented which is based on incorporating ebusiness activities, channel management, relationship management and backoffice/front-office integration within a customer centric strategy. © 2000 Elsevier Science Ltd. All rights reserved Once upon a time retailers, banks, insurance companies and car dealers had a close relationship with their customers. They often knew them individually, understood what they wanted, and satisfied their needs through personal customised service. As a result, they earned loyalty and a large share of their customers’ business. This, however, was a costly and inefficient system and customers effectively subsidised this relationship by paying higher prices. Over the years, through mass marketing and increased consumerism customers traded relationships for anonymity, reduced variety and lower prices. Today, through the effective use of information and communications technology, such a tradeoff is now not necessary; organisations can offer their customers variety, lower prices and personalised service and all at the same time. An airline gate attendant whom you have never set eyes on knows you are a valuable customer...
Words: 12765 - Pages: 52
...Decision Support Systems The material has been prepared by considering the prescribed textbook, internet and assignments given by the students (BBM 2011-2014 Batch). The material can be further improved by adding more insightful examples and explanation. The material may not be exhaustive and should be taken as a guide to help in better learning of the subject. ALL THE BEST Unit – I: 1. What is DSS? Explain the Characteristics, Benefits and Limitations of DSS. Definition: A decision support systems is a system under the control of one or more decision makers that assist in the activity of decision making by providing set of tools intended to impose structure to the decision making situation and improve the effectiveness of the decision outcome. Characteristics of DSS: * Employed in semistructured or unstructured decision contexts * Intended to support decision makers rather than replace them * Supports all phases of the decision-making process * Focuses on effectiveness of the process rather than efficiency * Is under control of the DSS user * Uses underlying data and models * Facilitates learning on the part of the decision maker * Is interactive and user-friendly * Is generally developed using an evolutionary, iterative process * Can support multiple independent or interdependent decisions * Supports individual, group or team-based decision-making Situation of Certainty Structured Unstructured Situation...
Words: 15342 - Pages: 62
...DATABASE A database is an organized collection of data. The data are typically organized to model aspects of reality in a way that supports processes requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database management systems (DBMSs) are computer software applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL,Microsoft SQL Server, Oracle, SAP and IBM DB2. A database is not generally portable across different DBMSs, but different DBMSs can interoperate by using standards such asSQL and ODBC or JDBC to allow a single application to work with more than one DBMS. Database management systems are often classified according to the database modelthat they support; the most popular database systems since the 1980s have all supported the relational model as represented by the SQL language. Sometims a DBMS is loosely referred to as a "database". database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. In computing, databases are sometimes classified according to their organizational approach. The most...
Words: 4833 - Pages: 20
...IS5111:Integration of IS & Business Business Intelligence and Analytics Abhishek Kumar Singh Anbarasan Thangapalam R Deepak Chattani Naadiya Danapal Ram Vibhakar S [A0120022] [A0119959] [A0119975] [A0119961] [A0120054] A Case study on Business Intelligent and Analytics Systems in NTUC FairPrice Table of Contents Executive Summary ............................................................................................................................. 3 Acknowledgments ............................................................................................................................... 4 1. Introduction ...................................................................................................................................... 5 2. Business Intelligence in Retail Industry: ................................................................................. 6 3. Combining BI in CRM ...................................................................................................................... 7 3.1 Analytical CRM ..........................
Words: 6362 - Pages: 26
...Oracle® Business Intelligence Applications Installation Guide for Informatica PowerCenter Users Release 7.9.6.4 E35271-01 November 2012 Provides the steps to install and set up Oracle Business Intelligence Applications Release 7.9.6.4. Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users, Release 7.9.6.4 E35271-01 Copyright © 2009, 2012, Oracle and/or its affiliates. All rights reserved. Primary Author: P Brownbridge This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable: U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed...
Words: 60905 - Pages: 244
...Extract from the Book “ERP Demystified” by Alexis Leon, Publisher: Tata Mc Graw Hill Publishing Co-2008 edition ( by Dileep Kumar, Secretary, Association of Knowledge Workers, Lucknow ) Part 1: Introduction: 1. What is an Enterprise? An enterprise is a group of people with a common goal, which has certain resources at its disposal to achieve this goal. In traditional approach , the organization is divided into different nits based on the functions they perform. These departments function in isolation and have their own systems of data collection and analysis. In enterprise way the entire organization is considered a system and all departments are its sub system, each sub system knows what others are doing , why they are doing and what should be done to move the company towards common goal. If the information that is generated is accurate, timely and relevant, then the systems will go a long way in helping the organization to realize its goals What is ERP? ERP integrates the information system of an organization and automates most of the functions. The activities supported by ERP system include all core functions of an organization, including financial management, human resource management, and operations. Increasingly, ERP vendors are offering “bolt-on” products , such as business Intelligence (BI), Product Life Cycle Management (PLM), Advance Planning and Scheduling (APS),Customer Relationship Management, Supply Chain Management etc Why ERP ? Today having an ERP is not a luxury...
Words: 20066 - Pages: 81
...document is solely owned by PaGaLGuY.com. Reproduction without permission in any form or means is illegal. Special copy prepared exclusively for mustafa rokerya Get your own Free personalized copy (with your name on it) of this book from http://www.pagalguy.com/books/ What this book is about What is a real IIM interview like? What kind of questions do they ask and what judgments do applicants have to make while answering them? Since 2003, those with real Group Discussion and Personal Interview calls from India’s top bschools have been posting entire and detailed transcripts of their admission interviews immediately after they happen, so that others slotted for later interviews can learn what GDPI is going to be like this year. This book is a collection of dozens of handpicked GDPI experiences from the country’s top bschools during the admission years 2005, 2006, 2007, 2008, 2009 and 2010. In this edition, we have included over 180 GDPI experiences from the admission processes of IIM Ahmedabad, IIM Bangalore, IIM Calcutta, IIM Indore, IIM Lucknow and IIM Kozhikode. A team of 33 volunteers, who are themselves at some stage of the MBA admissions process, were asked to make the selections based on what seemed most interesting and...
Words: 178933 - Pages: 716
