Principles of Information Systems 9th edition Ralph M. Stair, George W. Reynolds - Solutions

Discover comprehensive resources for the "Principles of Information Systems 9th edition" by Ralph M. Stair and George W. Reynolds. Explore our online platform offering a complete answers key and detailed solutions pdf. Dive into solved problems and access step-by-step answers to enrich your understanding. Our test bank and instructor manual provide thorough chapter solutions, ensuring you grasp every concept. Perfect for students and educators alike, our textbook solutions are available for free download. Enhance your learning experience with our expertly crafted questions and answers, designed to meet your academic needs.

Answer the following questions 1. Prove that the algorithm shown in Figure 19.4 correctly computes the attribute closure of the input attribute set X. 2. Describe a linear-time (in the size of the set of FDs, where the size of each FD is the number of attributes involved) algorithm for finding the
Let R be a relation schema with a set F of FDs. Prove that the decomposition of R into R1 and R2 is lossless-join if and only if F+ contains R1 ∩ R2 → R1 or R1 ∩ R2 → R2.
Prove that, if R is in 3NF and every key is simple, then R is in BCNF. Explain
Give an algorithm for testing whether a relation scheme is in BCNF. The algorithm should be polynomial in the size of the set of given FDs. (The size is the sum over all FDs of the number of attributes that appear in the FD.) Is there a polynomial algorithm for testing whether a relation scheme is
Consider the following collection of relations and dependencies. Assume that each relation is obtained through decomposition from a relation with attributes ABCDEFGHI and that all the known dependencies over relation ABCDEFGHI are listed for each question. (The questions are independent of each
Suppose you are given a relation R with four attributes ABCD. For each of the following sets of FDs, assuming those are the only dependencies that hold for R, do the following: (a) Identify the candidate key(s) for R. (b) Identify the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF).
Let R be decomposed into R1, R2, . . ., Rn. Let F be a set of FDs on R. 1. Define what it means for F to be preserved in the set of decomposed relations. 2. Describe a polynomial-time algorithm to test dependency-preservation. 3. Projecting the FDs stated over a set of attributes X onto a subset of
Consider the following BCNF schema for a portion of a simple corporate database (type information is not relevant to this question and is omitted): Emp (eid, ename, addr, sal, age, yrs, deptid) Dept (did, dname, floor, budget) Suppose you know that the following queries are the six most common
Consider the following BCNF relational schema for a portion of a company database (type information is not relevant to this question and is omitted): Project(pno, proj name, proj base dept, proj mgr, topic, budget) Manager(mid, mgr name, mgr dept, salary, age, sex) Note that each project is based
Consider the following BCNF relation, which lists the ids, types (e.g., nuts or bolts), and costs of various parts, along with the number available or in stock: Parts (pid, pname, cost, num avail) You are told that the following two queries are extremely important: • Find the total number
Consider the following BCNF relations, which describe departments in a company and employees: Dept(did, dname, location, managerid) Emp(eid, sal) You are told that the following queries are extremely important: • List the names and ids of managers for each department in a user-specified location,
Consider two ways to compute the names of employees who earn more than $100,000 and whose age is equal to their manager's age. First, a nested query:Second, a query that uses a view definition: SELECT E1.ename FROM Emp E1, MgrAge A WHERE E1.dname = A.dname AND E1.sal > 100 AND E1.age =
Briefly answer the following questions: 1. Explain the intuition behind the two rules in the Bell-LaPadula model for mandatory access control. 2. Give an example of how covert channels can be used to defeat the Bell-LaPadula model. 3. Give an example of polyinstantiation. 4. Describe a scenario in
You are a painter and have an Internet store where you sell your paintings directly to the public. You would like customers to pay for their purchases with credit cards, and wish to ensure that these electronic transactions are secure. Assume that Mary wants to purchase your recent painting of the
Consider Exercises 7.7 to 7.9 from Chapter 7. For each exercise, discuss where encryption, SSL, and digital signatures are appropriate.
What is an information system? What are some of the ways information systems are changing our lives?
Identify the functions of a transaction processing system.
What is the difference between an intranet and an extranet?
What is m-commerce? Describe how it can be used.
What are the most common types of computer-based information systems used in business organizations today? Give an example of each.
Describe three applications of virtual reality.
What are computer literacy and information systems literacy? Why are they important?
What are some of the benefits organizations seek to achieve through using information systems?
Identify the steps in the systems development process and state the goal of each.
How would you distinguish data and information? Information and knowledge?
Identify at least six characteristics of valuable information.
What is the difference between efficiency and effectiveness?
What are the components of any information system?
What is feedback? What are possible consequences of inadequate feedback?
How is system performance measured?
What is a knowledge management system? Give an example.
What is a computer-based information system? What are its components?
Why is the study of information systems important to you? What do you hope to learn from this course to make it worthwhile?
Discuss how information systems are linked to the business objectives of an organization.
What are your career goals and how can a computer-based information system be used to achieve them?
Describe how information systems are used at school or work.
What is the value of software? Give several examples of software you use at school or home.
Why is a database an important part of a computer-based information system?
What is the difference between e-commerce and m-commerce?
What is the difference between DSS and knowledge management?
Suppose that you are a teacher assigned the task of describing the learning processes of preschool children. Why would you want to build a model of their learning processes? What kinds of models would you create? Why might you create more than one type of model?
Describe the "ideal" automated vehicle license plate renewal system for the drivers in your state. Describe the input, processing, output, and feedback associated with this system.
New York City's Taxi & Limousine Commission has mandated that all licensed city cab owners install new information systems in their cabs. The new state-of-the-art system connects the cabs to a wireless data network. The new system will not be used for dispatching cabs (most New York City cabs are
More than ever before, Chinese retailers are facing local competition from foreign companies. China's highly regulated economy has insulated businesses from competition. Now that China is loosening its regulations in an effort to benefit from international trade, its own businesses must work harder
See the Web site for this book to read about the Whitmann Price Consulting case for this chapter. The following questions cover this Web case. Discussion Questions 1. What advantages would the proposed Advanced Mobile Communications and Information System provide for Whitmann Price Consulting? What
What is the value chain?
List and define the basic organizational structures.
Sketch and briefly describe the three-stage organizational change model.
What is downsizing? How is it different from outsourcing?
What are some general strategies employed by organizations to achieve competitive advantage?
What are several common justifications for implementing an information system?
Define the term productivity. How can a company best use productivity measurements?
What is on-demand computing? What two advantages does it offer to a company?
What is the total cost of ownership?
Describe the role of the CIO.
What is supply chain management?
What role does an information system play in today's organizations?
What is reengineering? What are the potential benefits of performing a process redesign?
What is user satisfaction?
What is the difference between reengineering and continuous improvement?
What is the difference between technology infusion and technology diffusion?
What is quality? What is total quality management (TQM)?
What are organizational change and organizational learning?
You have been hired to work in the IS area of a manufacturing company that is starting to use the Internet to order parts from its suppliers and offer sales and support to its customers. What types of Internet positions would you expect to see at the company?
You have decided to open an Internet site to buy and sell used music CDs to other students. Describe the supply chain for your new business.
What are the advantages of using a virtual organizational structure? What are the disadvantages?
How would you measure user satisfaction with a registration program at a college or university? What are the important features that would make students and faculty satisfied with the system?
You have been asked to participate in preparing your company's strategic plan. Specifically, your task is to analyze the competitive marketplace using Porter's five-forces model. Prepare your analysis, using your knowledge of a business you have worked for or have an interest in working for.
Based on the analysis you performed in Discussion Question 6, what possible strategies could your organization adopt to address these challenges? What role could information systems play in these strategies? Use Porter's strategies as a guide.
There are many ways to evaluate the effectiveness of an information system. Discuss each method and describe when one method would be preferred over another method.
Assume you are the manager of a retail store and need to hire a CIO to run your new computer system. What characteristics would you want in a new CIO?
A new IS project has been proposed that will produce not only cost savings but also an increase in revenue. The initial costs to establish the system are estimated to be $500,000. The remaining cash flow data is presented in the following table.a. Using a spreadsheet program, calculate the return
Using a word processing program, write a detailed job description of a CIO for a medium-sized manufacturing company. Use a graphics program to make a presentation on the requirements for the new CIO.
You can often gauge the role of information systems within a business by evaluating how the chief information officer (CIO), or head of information systems, interacts professionally with the president, chief executive officer (CEO), and other highranking decision makers. At Volvo Cars Belgium, the
Johnson & Johnson is the world's most "comprehensive and broadly based manufacturer of health care products, as well as a provider of related services, for the consumer, pharmaceutical, and medical devices and diagnostic markets" according to its Web site. Consider what it must be like to be
See the Web site for this book to read about the Whitmann Price Consulting case for this chapter. The following questions concern this Web case. Discussion Questions 1. Compare and contrast the benefits and shortcomings of notebook PCs and handheld PCs in accessing information on the road. 2. If
When determining the appropriate hardware components of a new information system, what role must the end user of the system play?
Why are the components of all information systems described as interdependent?
Identify the three components of the CPU and explain the role of each.
What is the difference between sequential and direct access of data?
Identify several types of secondary storage media in terms of access method, capacity, portability, and cost per GB of storage.
Identify and briefly describe the various classes of personal computers.
What is the difference between cloud computing and grid computing?
What is source data automation?
What is the overall trend in secondary storage devices?
What is a blade server? What advantages does it offer over an ordinary server?
Identify three basic characteristics of RAM and ROM.
What is RFID technology? Identify three practical uses for this technology.
What issues can arise when the CPU runs at a very fast rate?
What advantages do fuel cells offer over batteries for use in portable electronic devices? Do they have any disadvantages?
What is the difference between data entry and data input?
What is RAID storage technology?
Explain the two-phase process for executing instructions.
Briefly describe how RFID technology works. Why is RFID technology being used to track product inventory in retail stores?
How should organizations allocate grid computing resources so they address only important research projects?
What would be the advantages for a university computer lab to install thin clients rather than standard desktop personal computers? Can you identify any disadvantages?
What is a quad-core processor? What advantages does it offer users?
Briefly describe Moore's Law. What are the implications of this law? Are there any practical limitations to Moore's Law?
Identify and briefly describe the three fundamental approaches to data storage.
Briefly discuss several data-storage issues that face the modern organization.

Showing 2500 - 2600 of 3228

First
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33

Principles of Information Systems 9th edition Ralph M. Stair, George W. Reynolds - Solutions

Step by Step Answers