Archives: Solution Manual

Sally decides that she doesn’t want to use FedEx to ship out the products that day even though the company has a contract, which saves them lots of money. She decides to use an alternate shipping service that will cost […]

PART IV Chapter 22 Transaction Management 22.1 (a) Locking-based algorithms for concurrency control can be employed to synchronize the execution of transactions. Explain what is meant by a serializable schedule and show that the following locking-based schedule is not serializable: […]

34 Case 16 Apollo Hotel This case can be used with Chapter 9, Designing and Managing Products, Chapter 10, Internal Marketing, or Chapter 13, Promoting Products: Communication and Promotion Policy and Advertising. Teaching Objectives The objectives of this case are: […]

2-12 • Gives companies the flexibility to respond rapidly to customer requests while producing and stocking only that inventory necessary to fulfill existing orders. • Increases customer satisfaction by improving product shipments, minimizing costs, and improving a firm’s performance. • […]

115 Chapter 15: Professional Sales Chapter Objectives 1. Explain the role and nature of personal selling and the role of the sales force. 2. Describe the basics of managing the sales force, and explain how to set sales force 3. […]

– Part III 6 Chapter 22 Transaction Management Review Questions 22.1 Explain what is meant by a transaction. Why are transactions important units of operation in a DBMS? 22.2 The consistency and reliability aspects of transactions are due to the […]

2-1 Chapter 2 Global E-Business and Collaboration Learning Objectives 1. What are business processes? How are they related to information systems? 2. How do systems serve the different management groups in a business? 3. How do systems that link the […]

31 Case 15 Spirit Airlines: The Lowest Possible Price At All Costs Spirit Airlines is cheap. Cheaper by far than any other airline in the U.S. It achieves such low uding a carry-on bag), the airline charges a fee for. […]

Chapter 21 Professional, Legal, and Ethical Issues in Data Management Review Questions 21.1 Define 21.2 Describe bus considered: (a) illegal and unethical; An example of this is stealing. (b) legal but unethical; Consider a lonely database administrator for DreamHome who […]

Networking technologies are pervading almost everything we do professionally, socially, and recreationally. As you can see from the opening case in the text, many companies are remodeling their businesses and information systems with the Internet in mind. It has become […]

108 Chapter 14: Promoting Products: Public Relations and Sales Promotions Chapter Objectives 1. Understand the different public relations activities: press relations, product publicity, corporate communications, lobbying, and counseling. 2. Understand the public relations process: research, establishing marketing objectives, 3. Explain […]

PART IV Part 5 Selected Database Issues Chapter 20 Security and Administration 20.1 Describe a general plan of action for initiating a security policy, elaborating on each stage that might be undertaken. First of all, the need for one must […]

Dimensions of Information Systems It Isn’t Just Technology: A Business Perspective on Information Systems Complementary Assets: Organizational Capital and the Right Business Model Copyright © 2014 Pearson Education today? 3. What exactly is an information system? How does it work? […]

– Part III 3 Chapter 20 Security and Administration Review Questions 20.1 Explain the purpose and scope of database security. The purpose is clearly concerned with the protection of the data. However, the scope is wider than 20.2 List the […]

30 Case 14 Pricing Almost Destroys and Then Saves a Local Restaurant This case brings up a good opportunity for the instructor to review what affects the pricing decision. Mr. Herrera’s mistake was that he set his prices based solely […]

– Part III Chapter 19 Methodology Monitoring and Tuning the Operational System Review Questions 19.1 Describe the purpose of the main steps in the physical design methodology presented in this chapter. Step 7 of physical database design considers denormalizing the […]

Chapter 13: Engaging Customers and Communicating Customer Value and Advertising Chapter Objectives 1. Discuss the process and advantages of integrated marketing communications in communicating customer value. 2. Define the five promotion tools and discuss the factors that must be considered […]

– Part III 24 Chapter 18 Methodology – Physical Database Design for Relational Databases Review Questions 18.1 Explain the difference between conceptual, logical, and physical database design. Why might these tasks be carried out by different people? Conceptual database design […]

27 Case 13 The Bleeding Heart Restaurant: The Finest French Restaurant In London The Bleeding Heart Restaurant and Bistro has been a favorite with Londoners (UK) for more than twenty-five years. The perennially popular restaurant and Bistro were started in […]

– Part III Chapter 17 Methodology – Logical Database Design for Relational Model Review Questions 17.1 Discuss the purpose of logical database design. For the purpose of logical database design see Section 17.1. 17.2 Describe the rules for deriving relations […]

91 Chapter 12: Distribution Channels Delivering Customer Value Chapter Objectives 1. Describe the nature of distribution channels, and tell why marketing intermediaries are used. 3. Discuss channel behavior and organization, explaining corporate, contractual, and vertical marketing systems, including franchising. 4. […]

PART IV FastCabs Sample ER Model Staff staffNo WorksAt 1..* Manager Driver Owner Office officeNo Manages 1..1 1..1 Taxi vehRegNo TaxiDriver Owns 1..* 1..1 1..* 1..* 1. .1 1..1 Has Drives 1..1 Job jobID Contract contractNo BusinessClient bClientNo PrivateClient pClientNo […]

24 Case 12 Grand Targhee This case describes how competitive the world of ski resorts and how personalized service gave Targhee the lift it needed. Targhee has an edge on size, 3,000 acres, as compared to a but accesses it […]

80 Chapter 11: Pricing: Understanding and Capturing Customer Value Chapter Objectives 1. Outline the internal factors affecting pricing decisions, especially marketing objectives, marketing mix strategy, costs, and organizational considerations. 3. Contrast the differences in general pricing approaches, and be able […]

PART IV (f) Approximately 50 new video orders are placed each week. The details of video orders are destroyed two years after the creation of the record. The types and average number of record searches (a) Searching for the details […]

Case 11 Ritz-Carlton Discussion Questions Chapter 7 1. What market segments in chapter 7 do you feel would be the best match for a Ritz Carlton hotel? Ritz-Carlton hotels are smaller luxury hotels, usually 300 rooms or less. Thus, they […]

Guide IV Part 4 Methodology Chapters 16 – 19 Methodology Conceptual, Logical, and Physical Database Design Case Study 1 – Adult Education Department An Adult Education Department runs various courses during the daytime and evenings, and at Monday evenings or […]

Chapter 10: Internal Marketing Chapter Objectives 1. Understand why internal marketing is an important part of a marketing program. 2. Explain what a service culture is and why it is important to have a company where everyone is focused on […]

– Part III Chapter 16 Methodology – Conceptual Database Design Review Questions 16.1 Describe the purpose of a design methodology. A structured approach that uses procedures, techniques, tools, and documentation aids, to support and facilitate the process of design. A […]

21 Case 10 Hawaiian Sights 1. How could Hawaiian Sights use social media to promote its business? It is unlikely that the idea of Hawaiian Sights would appeal to the majority of visitors to Hawaii. Many visitors are middle aged […]

– Part III 29 Chapter 15 Advanced Normalization Review Questions 15.1 Describe the purpose of using inference rules to identify functional dependencies for a given relation. Even if we restrict our attention to nontrivial functional dependencies with one-to-one (1:1) relationships […]

65 Chapter 9: Designing and Managing Products and Brands: Building Customer Value Chapter Objectives 2. Explain how accessibility, atmosphere, customer interaction with the service delivery system, customer interaction with other customers, and customer coproduction are all critical elements to keep […]

Guide IV Chapters 14 – 15 Normalization 14.1 Explain the purpose of data normalization and describe the main steps in the normalization process. 14.2 The table shown below displays the details of the roles played by actors/actresses in films. filmNo […]

19 Case 9 Mayo Clinic Chapter 9 1. Explain why Mayo Clinic is so good at customer service. Why has it been so successful practicing medicine differently from other hospitals? Mayo Clinic provides exceptional medical healthcare in many specialties such […]

– Part III 19 Chapter 14 Normalization Review Questions 14.1 Describe the purpose of normalizing data. The purpose of normalization is to identify a suitable set of relations that support the data requirements of an enterprise. The characteristics of a […]

58 Chapter 8: Customer-Driven Marketing Strategy: Creating Value for Target Customers Chapter Objectives 1. Define the major steps in designing a customer-driven marketing strategy: market segmentation, targeting, and positioning. Teaching Suggestions The following explanations and suggestions are outlined based on […]

– Part III 15 Chapter 13 Enhanced Entity-Relationship Modeling Review Questions 13.1 Describe what a superclass and a subclass represent. A superclass is an entity type that includes one or more distinct subgroupings of its 13.2 Describe the relationship between […]

18 Case 8 The Witchery By The Castle Andrew Lloyd Webber Chapter 4 1. From the preceding discussion above analyze and the strengths and weaknesses of The Witchery. Analysis of the case of The Witchery and of its sole owner, […]

Guide IV Chapters 12 13 (Enhanced) Entity Relationship Modeling 12.1 Represent each of the following requirements with an ER diagram: (a) A company called Perfect Pets runs a number of clinics. A clinic has many staff and a member of […]

Chapter 7: Organizational Buyer Behavior Chapter Objectives 1. Understand the organizational buying process. 2. Identify and discuss the importance of the participants in the organizational buying process. 3. Identify the major influences on organizational buyers. 4. List the eight stages […]

– Part III Chapter 12 Entity-Relationship Modeling Review Questions 12.1 Describe what entity types represent in an ER model and provide examples of entities with a physical or conceptual existence. eal world with the same properties (see Section 12.1). Examples […]

16 Case 7 The Australian Tourist Commission This case describes plans by the ATC for a survey prior to the Paul Hogan advertisements and the Paul Hogan series of highly successful films. Students should not believe that the case represents […]

– Part III Chapter 11 Database Analysis and the DreamHome Case Study Review Questions 11.1 Briefly describe what the process of fact-finding attempts to achieve for a database developer. Attempts to uncover facts about the business and the users of […]

45 Chapter 6: Consumer Markets and Consumer Buying Behavior Chapter Objectives 1. Explain the model of buyer behavior. 2. Outline the major characteristics affecting consumer behavior, and list some of the Teaching Suggestions The following explanations and suggestions are outlined […]

Guide IV Part 3 Database Analysis and Design Techniques Chapter 10 Database Planning, Design, and Administration 10.1 Explain the procedures and techniques needed to achieve a conceptual data model. The answer should discuss the different stages that might be identified, […]

13 Case 6 In-N-Out Burger: Customer Value the Old-Fashioned Way Most people have at least heard of In-N-Out. But what they may not realize is just how unique In- N-Out is. This burger chain that is now more than 60 […]

– Part III Chapter 10 Database System Development Lifecycle Review Questions 10.1 Describe the major components of an information system. Database, database software, application software, computer hardware including storage media, and people using and developing the system. 10.2 Discuss the […]

36 Chapter 5: Managing Customer Information to Gain Customer Insights Chapter Objectives 1. Explain the importance of information in gaining insights about the marketplace and customers. 3. Outline the marketing research process, including defining the problem and research objectives, developing […]

Guide IV Chapter 9 Object-Relational DBMSs 9.1 Compare and contrast the two manifestos: Object-Oriented Database System Manifesto based on the object-oriented paradigm (Atkinson et al., 1989a) and the Third Generation Database System Manifesto published by the Committee for Advanced DBMS […]

12 Case 5 The Hunt Room: Change the Concept or Just the Décor? This case can be used with Chapter 5, Marketing Information Systems, or Chapter 9, Product Policy. For Chapter 5 the instructor should focus on the research process […]