Premium Essay

Database Processing Ch 1 and Part of Ch 2

In:

Submitted By marvbushi
Words 1418
Pages 6
Chapter 1 – Review Questions
1.1 What is the purpose of a database? - The purpose of a database is to help people keep track of things.
1.2 What is the most commonly used type of database? - The relational database is the most commonly used type of database. 1.7 Define the terms data and information. Explain how the two terms differ. - Data are facts and figures. Information is defined as knowledge derived from data, or as data presented in a meaningful context. Data is simply recorded in the database, but the data must be manipulated in some way to produce information.

1.12 What is the purpose of the largest databases used by e-commerce companies such as Amazon.com? - The largest databases used by e-commerce companies are Web-activity databases used to track customer behavior.
1.13 How do the e-commerce companies use these databases? - The e-commerce companies’ Web-activity databases are used to determine which Web page items are popular and successful, and to test if certain variations in Web page design will generate more orders.
1.14 How do digital dashboard and data mining applications differ from transaction processing applications? - Digital dashboard and data mining applications do not generate new data, but instead are used to summarize existing data to provide information to management.
1.15 Explain why a small database is not necessarily simpler than a large one. - While small databases vary from large databases in terms of the amount of data they store, they can still have the same structures and components (types of data, number of tables, and complexity of data relationships) as a large database. A small database is not necessarily a simple database.
1.17 What are the functions of application programs? * Create and process forms * Process end user queries * Create and process reports

Similar Documents

Premium Essay

Paper

...INSTRUCTIONS: YOU MUST ANSWER QUESTIONS 1, 2, AND 3. THEN CHOOSE TWO QUESTIONS FROM 4, 5, 6, AND 7. IN TOTAL, YOU WILL ANSWER FIVE QUESTIONS. EACH QUESTION SHOULD BE ANSWERED THOROUGHLY TO SHOW YOUR UNDERSTANDING IN DETAIL. CLEARLY LABLE THE QUESTIONS YOU ARE ANSWERING. Question #1 (Ch.1) Your friend Karen, knowing that you are a diligent student studying in the MPAc program, has asked that you enlighten her about Sarbanes-Oxley. a) Describe to Karen the key points of the section 404 of the Sarbanes-Oxley Act. b) Section 404 requires management to make a statement identifying the control framework used to conduct their assessment of internal controls. Describe to Karen the options in selecting a control framework. c) Karen was wondering, if the auditors give a qualified opinion on management’s assessment of internal controls over the financial reporting system, does it mean that the auditor must also give a qualified opinion on the financial statements? Explain how it works. d) In this age of high technology and computer based information systems, Karen was wondering why accountants are concerned about physical (human) controls. Explain. e) Internal control in a computerized environment can be divided into two broad categories. Explain to Karen what they are. Question #2 (Ch.2) You are being interviewed for a job as an internal auditor, and it is the...

Words: 820 - Pages: 4

Premium Essay

Dbm460Syllabus

...Course Design Guide DBM/460 Version 2 Syllabus College of Information Systems & Technology DBM/460 Version 2 Enterprise Database Management Systems Copyright © 2012, 2009 by University of Phoenix. All rights reserved. Course Description This course covers distributed computing, middleware, and industry standards as relating to the enterprise data repository. Data warehousing, data mining, and data marts are covered from an enterprise perspective. 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 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 Coronel, C., Morris, S., & Rob, P. (2011). Database systems: Design, implementation and management (9th ed.). Mason, OH: Cengage Learning. Eckerson, W. W. (2011). Performance dashboards: Measuring, monitoring, and managing your business (2nd ed.). Hoboken, NJ: John Wiley & Sons, Inc. Hoffer, J. A., Ramesh, V., & Topi, H. (2011). Modern database management (10th ed.). Upper Saddle River, NJ:...

Words: 2603 - Pages: 11

Premium Essay

Management Leadership

...MANAGEMENT INFORMATION SYSTEMS (MIS) Term 1; ECTS: 10 (July 2-22, 2015) Prof. D P Goyal, Ph.D. Management Development Institute Gurgaon-122001, New Delhi, INDIA dpgoyal@mdi.ac.in;dpgoyal23@gmail.com 1 INFORMATION ABOUT THE PROFESSOR Dr. D P Goyal is Professor at Management Development Institute, Gurgaon, New Delhi, India (www.mdi.ac.in/faculty/detail/28-d-p-goyal/). • • • • • • • • Post Graduate in Business Management; Doctorate in MIS Over 29 years of experience in teaching, research, consulting & executive training Published more than hundred research papers in national / international journals of repute Published 18 books including three well acclaimed text books one each on MIS from Macmillan; ERP from McGraw-Hill; and IT project Management from Macmillan Have supervised 13 Ph.D. research scholars Completed many sponsored research projects On the Board of Governors; Advisory Board; Academic Council; Board of Studies of many business Schools/Universities Member of editorial board and review panel of several referred journals OBJECTIVES OF THE COURSE The main objectives of the course are to provide the management student a broad understanding of: • • • • • Information Systems (such as Transaction Processing Systems, Management Information Systems, Decision Support systems, etc) from a Business Perspective Information Systems Planning Key IT Technologies, and the implications of these technologies for managers Identifying...

Words: 2915 - Pages: 12

Free Essay

What Is the Difference Between a “Dashboard” and a “Scorecard”? Why Is It Important That Managers Know the Difference Between the Two? What Can They Learn from Each of Them?

... | MISY 3310 Management Information Systems Section W01: Online Course; 2013 Spring Semester Instructor: Dr. Tim Klaus Office: OCNR 385 Telephone: Office: (361) 825-2379 Cell Phone: (361) 248-8495 – feel free to call Mon-Sat between 9AM-10PM (I’ll be able to receive or return your call quicker than if you call the office) E-mail: tim.klaus@tamucc.edu Office Hours: Monday 8:30-8:55 AM, 9:55-10:55 AM, 12:00-3:10 PM Wednesday 8:30-8:55 AM, 9:55-10:55 AM Other days and times by appointment Course Website (Blackboard): http://iol.tamucc.edu/ Course Materials 1. Required Text: O’Brien, James and George Marakas, Introduction to Information Systems: Essentials for the E-Business Enterprise, 16th ed., Irwin/McGraw-Hill. Print - ISBN: 0073376884 eText – ISBN: 0077506413 2. Course material through http://iol.tamucc.edu/ Optional Materials None Prerequisites MISY 2305 or equivalent and Junior standing or above. Course Description: Provides an understanding of the importance of computer-based information in the success of the firm. Illustrates ways in which companies utilize computer systems to strategically compete within certain industries. Emphasis is on the role of information systems within each of the functional areas of business. Major concepts include data management, decision support, and management information systems. Relationship to Other Coursework: Where MISY 2305 provides...

Words: 2297 - Pages: 10

Free Essay

Simulation and Research on Data Fusion Algorithm of the Wireless Sensor Network Based on Ns2

...terminals by means of random selforganization wireless communication network through multi-hop relay. Thus it authentically achieves the purpose of ‘monitor anywhere and anytime’. The basic function of sensor network is gathering and sending back the information of the monitoring areas which the relevant sensor nodes are set in. But the sensor network node resources are very limited, which mainly embodies in battery capacity, processing ability, storage capacity, communication bandwidth and so on. Because of the limited monitoring range and reliability of each sensor, we have to make the monitoring areas of the sensor nodes overlapped when they are placed in order to enhance the robustness and accuracy of the information gathered by the entire network. In this case, certain redundancy in the gathered data will be inevitable. On the way of sending monitoring data by multi-hop relay to the sink nodes (or base stations) which are responsible to gather the data. It is necessary to reduce the redundant information by fusion processing. Data fusion is generally defined as a process that lots of data gathered from multiple sources or information are processed and combined in order to achieve more efficient data and ones that can better meet the requirements of the users. In most applications of wireless sensor network, sometimes we only concern about the monitoring results rather than gathering a lot of original data. Data fusion technology is an efficient method...

Words: 3532 - Pages: 15

Premium Essay

Dsc340

...Ch. 5. Moore's Law and More: Fast, Cheap Computing, Disruptive Innovation, and What This Moore's Law definition: Chip performance per dollar doubles every eighteen months. Moore’s Law applies to chips—broadly speaking, to processors and chip-based storage. Microprocessor is the brain of a computing device. It’s the part of the computer that executes the instructions of a computer program. For processors, Moore’s Law means that next generation chips should be twice as fast in about eighteen months, but cost the same as today’s models. Random-access memory (RAM ) Fast, chip-based volatile storage in a computing device Flash memory Nonvolatile, chip-based storage Volatile memory: Storage that is wiped clean when power is cut off from a device Nonvolatile memory: Storage that retains data even when powered down. Solid state electronics: Semiconductor-based devices Semiconductors: Substance such as silicon dioxide used inside most computer chips that is capable of enabling and inhibiting the flow of electricity Optical fiber line: High-speed glass or plastic-lined networking cable used in telecommunications ...

Words: 2104 - Pages: 9

Premium Essay

Psychology Approach

...Module Study Guide Research Methods in Psychology 2 Deadlines: 1st Report Week 6, Thurs 6th March 12noon 2nd Report Week 10, Thurs 17th April 12noon Lectures: Fridays 1pm-2pm TC102 Workshops: Mondays in Paragon NB – check for changes to this in weeks 10, 11 and 13 due to the Bank Holidays. School of Psychology, Social Work and Human Sciences School of Psychology, Social Work and Human Sciences Research Methods in Psychology 2 Module Study Guide |Module Code |SS40003E | |Level |4 | |Credits |20 | 2014 Version No 01 © UWL 2013 Research Methods in Psychology 2 Module Study Guide Contents | |Page No. | |Module Leader and Teaching Team Details |3 | | | | |Facts and figures |5 | | | | |Section A Overview and Content...

Words: 5677 - Pages: 23

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

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

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

Warehouse Improvement

...Date: 07/7/11 Chapter Page# 1. Introduction 3 2. Review of Previous Studies 3. Approaches 4. Expected Results 5. References CH-1 Introduction A warehouse management system, or WMS, is a key part of the supply chain and primarily aims to control the movement and storage of materials within a warehouse and process the associated transactions, including shipping, receiving, put-away and picking. The systems also direct and optimize stock put-away based on real-time information about the status of bin utilization. Warehouse management systems often utilize Auto ID Data Capture (AIDC) technology, such as barcode scanners, mobile computers, wireless LANs and potentially Radio-frequency identification (RFID) to efficiently monitor the flow of products. Once data has been collected, there is either one batch synchronization with, or a real-time wireless transmission to a central database. The database can then provide useful reports about the status of goods in the warehouse. The objective of a warehouse management system is to provide a set of computerized procedures to handle the receipt of stock and returns into a warehouse facility, model and manage the logical representation of the physical storage facilities (e.g. racking etc), manage the stock within the facility and enable a seamless link to order processing and logistics management in order to pick, pack and ship product out of the facility. Warehouse...

Words: 2618 - Pages: 11

Premium Essay

Amazon Evolution

...Amazon Evolution ± Team B Outline (Week 2) Begin working on the Amazon.com® Evolution paper by reading Amazon: From Book Seller to Service Provider in Ch. 1 of Introduction to Information Systems. 1. Discuss whether the company is moving away from its core competency of being a leading online retailer. Evaluate the offerings of GoogleŒ and Microsoft®, identify in which areas Amazon.com® is competing, and discuss whether this is a wise strategy Although Amazon is the largest leading online retailer, according to the Amazon.com case study, they are utilizing only 10% of their processing capacity. Therefore, they have decided to enhance their profit margin by encompassing the utilization of the remaining infrastructure already put into place, to increase their profit margin. By offering services to smaller companies that they are already paying for, and using the unutilized infrastructure space to do so. Therefore, they are not moving away from their core competency they are enhancing it. As a matter of fact, it seems as though they are capitalizing on two things: The infrastructure they have that is already bought and paid for and their superior data management expertise. Although expanding your business always entails risk, I think they are moving in a direction in which they have considerable expertise. Google is in direct competition with Amazon but they are not an online retailer. They are a B2B operating as an online referral service. Microsoft, also is a services support business...

Words: 1406 - Pages: 6

Premium Essay

Amazon Evolution

...1. Amazon Evolution Ruth A Whaley XBIS/219 April 14, 2013 Caryl Rahn 2. A Princeton graduate’s idea, in July 1995, introducing the World Wide Web launched Amazon.com. Amazon.com was originally to offer a larger array of books over the Internet. As of today, Amazon is still one of the companies who offer online reading materials. After remaining near the top of online sales for so long, there now seems to be a question of whether or not Amazon is steering in a different direction from what its core competency was. Amazon has seen their operating cost margins to be less than that of Wal-Mart. Amazon has watched its profits dwindle away. With seeing the losses in revenue Amazon has started moving away from its core they are becoming an E-commerce titan by renting out their infrastructure. Amazon is going forth in a way to make more profit for the company by using only ten percent of its total capability at any one-time. Amazon has decided to offer a variety of services from computing and storage to other companies for a price. Providing these services will bring revenue into the company while helping other companies who do not have this type of capabilities. Amazon.com has three components which make up their database. Simple Storage Services (S3) Amazon set a price of fifteen cents per gig per month for companies to store their data and apps on the Amazon disk drives. The second component is the Elastic Compute Cloud (EC2) and they rent processing...

Words: 536 - Pages: 3

Premium Essay

Pt2520

...BCIS / CH. 5 Study online at quizlet.com/_6dnkk 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. data entry forms The _____ data model is a tool for constructing data models. entityrelationship A _____ is a self-describing collection of integrated records. database 21. _____ is an example of a personal DBMS. access 22. _____ is the process of converting a data model into tables, relationships, and data constraints. database design 23. The _____ problem is unique to a multiuser database environment. lost-update _____ show data in a structured context. reports A ______ is a collection of forms, reports, queries, and programs that process a database. database application ______ is a popular enterprise DBMS. DB2 ______ is the most popular diagramming tool for database applications. E-R 27. ______ is the process of converting a poorly structured table into two or more well-structured tables. normalization 28. ______ process logic that is specific to a given business record. application programs ______ softwares assist in creating, maintaining, and manipulating databases. DBMS A(n) _____ DBMS is designed to process large organizational and workgroup databases. enterprise A(n) _____ is a column or group of columns that identifies a unique row in a table. key All the following steps involved in transforming a data model into a relational database design except _____. each attribute of the entity becomes a row of the table Applications...

Words: 1054 - Pages: 5

Premium Essay

Essay

...no: MCS-2010-23 June 2010 Principles for Distributed Databases in Telecom Environment Imran Ashraf Amir Shahzed Khokhar School of Computing School of Computing Blekinge Institute of Technology Blekinge Institute of Technology Box 520520 Box SE – 372372 Ronneby SE – 25 25 Ronneby Sweden Sweden This thesis is submitted to the School of Computing at Blekinge Institute of Technology in partial fulfillment of the requirements for the degree of Master of Science in Computer Science. The thesis is equivalent to 20 weeks of full time studies. Contact Information: Author(s): Imran Ashraf Address: c/o Gulfam Abbas, Älgbacken 4 LGH 081, 37234 Ronneby, Sweden E-mail: im_qamar@yahoo.com Phone: +46 700746734 Amir Shahzed Khokhar Address: c/o Gulfam Abbas, Älgbacken 4 LGH 081, 37234 Ronneby, Sweden E-mail: amir_ask@yahoo.com Phone: +46 760811926 University advisor(s): Professor Lars Lundbarg School of Computing Blekinge Institute of Technology, Sweden External advisor(s): Magnus Vigerlöf Ericsson AB Address: Ölandsgatan 1, 371 23 Karlskrona Phone: +46 10 7140404 School of Computing Blekinge Institute of Technology Box 520 SE – 372 25 Ronneby Sweden Internet Phone Fax : www.bth.se/com : +46 457 38 50 00 : + 46 457 102 45 2 Abstract Centralized databases are becoming bottleneck for organizations that are physically distributed and access data remotely. Data management is easy in centralized databases. However, it carries high communication cost and most importantly...

Words: 17534 - Pages: 71