...DSS 630 Database Management Systems Theory and Practice COURSE EXPECTATION FORM Course Description: The implementation of technology such as bar codes and scanners enable organizations to accumulate large volumes of data. Further, as the technology to collect data gets cheaper and more simplified, business organizations gather and process a huge amount of data and information. Thus, data management has become a key function for many organizations. Managers need high-quality information to manage change in a turbulent, global environment. Business organizations use information systems to store and retrieve data, the raw material in knowledge-based economies. This repository of data is organizational memory. Databases are an important component of the organizational memory. Thus, information systems professionals should develop a comprehensive understanding of data management principles to fully utilize the organizational role of information technology. This course provides core skills of data management for the relational database management systems. This course will review the theoretical concepts and applications of a modern relational database management system. In addition to a basic theoretical presentation of the database design concepts, students will be required to design and develop a database application using a modern fourth generation language system. This course teaches students data modeling and design...
Words: 1374 - Pages: 6
...| | | | | | | | | Course Project ReportEnterprise Resource Planning (Spring 2015) | | | | | | | | | | | | | | | | | | | | | | | | 58821 Ayesha, 58205 Lt Col Saad | Course Project Report Enterprise Resource Planning (Spring 2015) TABLE OF CONTENTS | Ser | Content | Page | 1. | Acknowledgement & Introduction | 2 | 2. | Planning, Implementation, Cost | 3 | 3. | Oracle e-businesssuite R/12 | 4 | 4. | Core HRMS | 5 | 5. | Financials | 6 | 6. | EAM, Inventory Management, MRP | 7 | 7. | Orde Management, Manufacturing | 8 | 8. | Purchasing | 9 | 9. | Conclusion | 16 | 10. | Questionnaire | 17 | 11. | Hiearchical Representation of Business Processes | 18 | 12. | Endnotes | 19 | ENTERPRISE RESOURCE PLANNING SYSTEM ATLAS BATTERY LIMITED Acknowledgement: This project would not have been possible if not for our esteemed faculty Mr. Ahsan Ul Haq, his motivation has made this project possible. The Reason behind this project: This project was given to us inorder to understand how different companies use ERP’s in there everyday work and what kind of advantages does it provide to the company, we choose Atlas Battery LTD because most of their operations are done through the ERP’s they used the tier3i before but now they have shifted to ORACLE Business suite. This project provided us with the oportunity to actually understand the ERP system and the business processes that have been made possible by...
Words: 3689 - Pages: 15
...DMV Case Study Purpose of this Assignment (The information below is excerpted from the Virginia Department of Motor Vehicles’ RFP 154:7-061, DMV CSI Systems Redesign Project, available from under Content>Course Resources>DMV_CSI_RFP_083107_Final_Release. Corresponding page numbers from the RFP are given in parentheses at the end of each lettered section heading.) A. DMV Organizational Overview (p. 2) The Department of Motor Vehicles (DMV) is a governmental agency in the Executive Branch of Virginia state government. Under the direction of the Secretary of Transportation, DMV administers motor vehicle and tax related laws for the continued benefit of all citizens of the Commonwealth of Virginia. Specifically, DMV administers motor vehicle titling and licensing laws, driver’s licensing laws, transportation safety laws, tax laws, and other motor vehiclerelated laws and regulations as directed by the Code of Virginia and Federal laws, as amended. DMV employs nearly 2000 full and part-time employees to meet its daily mission of providing transportation services to customers in Virginia. These employees provide services via one centralized administrative Headquarters located in Richmond, Virginia as well as 74 Customer Service Centers (CSC’s) and 13 Motor Carrier Service Centers/Weigh Stations (MCSC’s) dispersed throughout the state. In addition, some services are provided at more than 40 DMV Select offices located throughout the state. DMV Selects are a service alternative...
Words: 2630 - Pages: 11
...enterprise-wide/ERP projects M ARY SUM NER School of Business, Southern Illinois University, Campus Box 1106, Edwardsville, IL 62026, USA The purpose of this study was to identify the risk factors in implementing traditional management information systems projects, describe the risk factors associated with enterprise-wide/ERP (enterprise resource planning) projects and identify the risk factors in ERP projects which are unique to these projects. Some of the unique challenges in managing enterprise-wide projects which were highlighted through the ndings included the challenge of re-engineering business processes to ‘ t’ the process which the ERP software supports, investment in recruiting and reskilling technology professionals, the challenge of using external consultants and integrating their application-speci c knowledge and technical expertise with existing teams, the risk of technological bottlenecks through client-server implementation and the challenge of recruiting and retaining business analysts who combine technology and business skills. Introduction In the past few years many organizations have initiated enterprise-wide/ERP (enterprise resource planning) projects using such packages as SAP, Peoplesoft and Oracle. These projects often represent the single largest investment in an information systems (IS) project in the histories of these companies and, in many cases, the largest single investment in any corporatewide project. These enterprise-wide/ERP projects bring about...
Words: 6286 - Pages: 26
...Upgrade of Oracle Business Intelligence Edition Enterprise (OBIEE 10G) Reporting Tool to OBIEE 11G at Econet Wireless (PVT) LTD Paddy Mutimusakwa Managerial Applications of Information Technology DeVry University - Keller Graduate School of Management February, 2015 Table of Contents Abstract 3 Brief Company background 4 Discussion of business problem(s) 5 Business/Technical Approach 6 Benefits of solving the problem 7 Business process changes 8 Technology or business practices used to augment the solution 8 - 9 High-level implementation plan 9-10 Conclusions and overall recommendations 11 References 12 Abstract With technology changing so rapidly, it is important that companies stay abreast of these changes to remain competitive. Econet Wireless, with its global presence cannot afford to ignore this fact hence the need for an upgrade to its current systems. With the utilization of the older version of OBIEE, Econet is not able to process most of its requests thereby affecting overall business performance and productivity. It is with this realization that an upgrade be done on the current software to satisfy company needs. Econet has been using OBIEE 10G as its reporting tool since the company started operating...
Words: 2308 - Pages: 10
...application modules for the finance, accounting and human resources aspects of a business. Enterprise Resource Planning systems (ERPs) integrate (or attempt to integrate) all data and processes of an organization into a unified system. A typical ERP system will use multiple components of computer software and hardware to achieve the integration. A key ingredient of most ERP systems is the use of a unified database to store data for the various system modules. ERP is an amalgamation of a company's information systems designed to bind more closely a variety of company functions including human resources, inventories and financials while simultaneously linking the company to customers and vendors. The Aim of an ERP System - The aim of ERP is to advance and modernize inner business processes, which characteristically requires reengineering of current business processes. The Components of an ERP System - The components of an ERP system are the common components of a Management Information System (MIS). * ERP Software - Module based ERP software is the core of an ERP system. Each software module automates business activities of a functional area within an organization. Common ERP software modules include product planning, parts purchasing, inventory control, product distribution, order tracking, finance, accounting and human resources aspects of an organization. * Business Processes - Business processes within an...
Words: 2779 - Pages: 12
...SCHOOL OF INFORMATION TECHNOLOGY MASTER OF INFORMATION TECHNOLOGY [pic] INDIVIDUAL ASSIGNMENT COVER PAGE |Name of Student |PETER J. MAKIWA | |Student Number |14299896 | |Name of Module |CORPORATE I.T SYSTEMS | |Module Code |MIT853 | |Name of Lecturer |DR. PATRICIA E.N. LUTU | |Date of Submission |24 AUGUST 2014 | |Contact telephone number |+263712501179 | |E-mail address |pmakiwa@gmail.com | |Declaration: |I declare that this assignment, submitted by me, is my own work and that I have | | |referenced all the sources that I have used. | |Signature...
Words: 2878 - Pages: 12
...Business process re-engineering is a business management strategy, originally pioneered in the early 1990s, focusing on the analysis and design of workflows and processes within an organization. BPR aimed to help organizations fundamentally rethink how they do their work in order to dramatically improve customer service, cut operational costs, and become world-class competitors.[1] In the mid-1990s, as many as 60% of the Fortune 500 companies claimed to either have initiated reengineering efforts, or to have plans to do so.[2] BPR seeks to help companies radically restructure their organizations by focusing on the ground-up design of their business processes. According to Davenport (1990) a business process is a set of logically related tasks performed to achieve a defined business outcome. Re-engineering emphasized a holistic focus on business objectives and how processes related to them, encouraging full-scale recreation of processes rather than iterative optimization of subprocesses.[1] Business process re-engineering is also known as business process redesign, business transformation, or business process change management. Contents [hide] • 1 Overview • 2 History o 2.1 Reengineering Work: Don't Automate, Obliterate, 1990 o 2.2 Development after 1995 • 3 Business process reengineering topics o 3.1 The role of information technology o 3.2 Research and methodology • 4 BPR success & failure factors o 4.1 Organization wide commitment o 4.2 BPR team composition ...
Words: 3755 - Pages: 16
...trends……………………….2 1.1 Competitors……………………………………………………………………3 1.2 Customers………………………………………………………………………4 2.0 Marketing environment analysis-Macro trends………………………5 2.1 Demographic………………………………………………………………....5 2.2 Technological…………………….……………………………………………5 3.0 Marketing Mix-Evaluation and Critique……………………………………6 3.1 Overview of current marketing approach……………………….6 3.2 Evaluation of Effectiveness……………………………………………..6 4.0 Marketing Mix-Redesign…………………………………………………………7 4.1 Product…………………………………………………………………………..7 4.2 Price……………………………………………………………………………....7 4.3 Place……………………………………………………………………………....8 4.4 Promotion………………………………………………………………….…..8 4.5 Physical evidence……………………………………………………………8 4.6 Processes……………………………………………………………………..…9 4.7 People……………………………………………………………………….……9 5.0 Recommendations…………………………………………………………………10 5.1 Recommendation one…………………………………………………..10 5.2 Recommendation two…………………………………………………..10 Reference List In this day and age, business is a vital element in modern society. Marketing plays an important position in business strategic. The aim of marketing is to create value for customer and capture value from customer in return (Kotler & Armstrong, 2012, p.26).The first foundation stone was laid in 1913 with the opening of a small food store in the German town of Essen. It didn't take long for this little 'service store' to become a popular place to shop. In 1954, a celebration was held for the opening of the 50th store in Germany. 'Self-service' was...
Words: 2826 - Pages: 12
...August 31, 2007 Dear Potential Offeror, You are invited to submit a proposal in accordance with the requirements set forth in the attached Request for Proposal, (RFP 154:7-061) using Best Value Acquisition procedures. This RFP is being issued by the Virginia Department of Motor Vehicles (DMV) for the purpose of seeking solutions to address the requirements of the DMV CSI Systems Redesign effort as identified in the attached RFP. An original proposal, signed by your contractually binding authority, with 7 full copies and 2 redacted copies, must be received by DMV Contracts and Procurement Department no later than 3:00 p.m. local time on Tuesday, December 4, 2007. An optional pre-proposal conference will be held at DMV Headquarters, 2300 West Broad Street, Richmond, Virginia, Room 702, on Tuesday, October 2, 2007 at 10:00 a.m. local time. Please refer to RFP Section VII for additional information. All questions or inquiries regarding this RFP must be received by Wednesday, October 31, 2007 at 5:00 p.m. local time and must be submitted in writing exclusively to: Nancy M. Davis, CPPB, CPPO, VCO Contracts and Procurement Manager Department of Motor Vehicles Room 319 2300 West Broad Street Richmond, VA 23220 E-mail: nancy.davis@dmv.virginia.gov Fax: (804) 367-0046 All inquiries must be submitted electronically as indicated in the RFP. Please refer to RFP Section VII for additional information. No verbal inquiries will be accepted. From the date of issuance of this RFP until the...
Words: 37401 - Pages: 150
...Business Process Modeling e-Framework Workshop Balbir Barn 12th February 2007 Agenda • • • • • Why we construct Business Process Models A historical context Approaches to business process modelling Business Process Modelling Notation Tools and standards summary 2 What is a Business Process? • Davenport & Short (1990) define business process as – "a set of logically related tasks performed to achieve a defined business outcome." A process is "a structured, measured set of activities designed to produce a specified output for a particular customer or market. • Business processes as transformations of inputs to outputs input output • Other models available: – Language-Action-Perspective (LAP) (Winograd and Flores 1986) • Production, coordination tasks using language for communication 3 Purposes of Business Process Modeling: Organization Design • • • • • • Process Documentation Process Reorganization Process Monitoring and Controlling Continuous Improvement Quality Management: ISO 9000 Benchmarking: Compare with best practice • Knowledge Management: 4 Purposes of Business Process Modeling: Information Systems Design • • • • • Selection of ERP software Model based Customizing Software Development Workflow Management Simulation 5 What to model of a business process • Tasks • Coordination between tasks – synchronization – decisions – parallel work – repetition –… • • • • Organizational responsibilities Required resources and constraints...
Words: 1550 - Pages: 7
...on manufacturing related industries which gave them the chance to generate revenue by licensing the product and pricing on the Licenses was according to the usage of the client. * Main aim was to make their product the de facto industry standard so that they had large number of users and hence high revenue. Market Forces: * R/3 was way ahead in technology than any product in the market at that time. It gave clients the option to tailor the product according to their needs without changing any code. * The scope of R/3’s reach was massive, it was open architecturally thus giving a lot freedom to the client in terms of database, hardware etc. * The timing of the product release was perfect because re-engineering and process redesign was on the rise. Organizational Factors: * Sales force was better organized and were given autonomy so that they could close deals faster. * Every step of the implementation was worked out to minute details thus giving companies the needed assistance and resources for the successful transition. Challenges faced because of the explosive growth: * Because of the growth a lot of staff was recruited but the administrative systems were not properly in place. * SAP in house consultants were leaving because the growth had become stagnant and also because SAP had taken a stand...
Words: 1346 - Pages: 6
...Explaining a concept: Website migration project Name Course Instructor Date Website Migration Project In this current era, every business is going online, and most of the selling and buying of goods and services is being done n online. That is why Tony chips should also have a website where it can be able to advertize its business and reach many customers. This paper will cover the steps and requirements on how Tony chips will transfer web hosting from an external source to internal as well as how to make their website redundant. In the efforts to build that redundant and scalable website, the key principles of availability, performance, reliability, scalability, manageability and cost require much attention (Matsudaira, 2012). Also, the SDLC must be duly followed as it is the requirement of any system. These are systems planning, system analysis, system design, system implementation, and lastly system support/security (Shelly & Rosenblatt, 2012). System Planning In this phase, the familiarization of the processes involved and objectives of the business must be well highlighted. A formal business plan needs to be in place to show which operations the company will undertake. There is a need to know all participants in the whole migration process and the time when they will you require then in the migration process. As the one of the requirements is that the website needs to be hosting should be internal, it means that a server there is a server requirement. Besides that...
Words: 3258 - Pages: 14
...------------------------------------------------- Business process reengineering From Wikipedia, the free encyclopedia Business Process Reengineering Cycle Business process re-engineering is a business management strategy, originally pioneered in the early 1990s, focusing on the analysis and design of workflows andbusiness processes within an organization. BPR aimed to help organizations fundamentally rethink how they do their work in order to dramatically improve customer service, cut operational costs, and become world-class competitors.[1] In the mid-1990s, as many as 60% of the Fortune 500 companies claimed to either have initiated reengineering efforts, or to have plans to do so.[2] BPR seeks to help companies radically restructure their organizations by focusing on the ground-up design of their business processes. According to Davenport (1990) a business process is a set of logically related tasks performed to achieve a defined business outcome. Re-engineering emphasized a holistic focus on business objectives and how processes related to them, encouraging full-scale recreation of processes rather than iterative optimization of subprocesses.[1] Business process re-engineering is also known as business process redesign, business transformation, or business process change management. Contents [hide] * 1 Overview * 2 History * 2.1 Reengineering Work: Don't Automate, Obliterate, 1990 * 2.2 Development after 1995 * 3 Business process reengineering topics ...
Words: 5633 - Pages: 23
...TOTAL QUALITY MANAGEMENT RAPELANG MAKHETHA BCom 3 Finance Contents Contents Introduction ............................................................................................................................................ 2 1.1 What is quality .................................................................................................................................. 2 1.2 Dimensions of quality ....................................................................................................................... 2 2. Business Process Reengineering Cycle ................................................................................................ 4 3. Cost of quality ..................................................................................................................................... 6 Introduction TQM is an enhancement to traditional way of doing business. It is the art of managing the whole to achieve excellence. It is defined both a philosophy and a set of guiding principles that represent the foundation of a continuously improving organization. It is the application of quantitative methods of human resources to improve all the processes within an organization and exceed customer needs now and in the future. Question 1 – 1.1 What is quality 1.1 (According to Steve Jobs late CEO of apple inc. 2010 ) Quality is the degree to which a commodity meets the expectations of the customer and even goes beyond the quality of similar commodities in the...
Words: 2121 - Pages: 9