Archives: Solution Manual
Chapter 21 Homework Web keyword search systems depend critically on relative ranking of pages. Earlier IR approaches were based on number of occurrences of each query
C H A P T E R 2 1 I n f o r m a t i o n R e t r i e v a l E x e r c i s e s 21.1 Web […]
Chapter 20 Homework Consider the schema r(A, B, C), where C is the class to which the tuple belongs, and A and B are attributes that can be used for classification
49 values are single letters, and there are only 2 classes T and F . Give an example with 4 “training instances” (tuples) and a partitioning con– dition that improves the “purity” (the exact definition of purity doesn’t mat- ter). […]
Chapter 16 Homework Copying the page table in shadow paging can be quite expensive for very large databases. Suggest an implementation of page tables that can reduce
C H A P T E R 1 6 R e c o v e r y E x e r c i s e s 16.1 What information do undo log records contain, and what are they used for? […]
Chapter 15 Homework Briefly explain what is recoverability and what is cascade freedom. Mention a protocol that ensures both properties, and explain why it ensures
39 b. What are the minimal changes to two-phase locking to guarantee i. recoverability (and explain why it works) . . .2 ii. cascade freedom (and explain why it works) . . .2 C H A P T E R […]
Chapter 14 Homework Give an example of a schedule that is view serializable but not conflict serializable. What is the essential feature of such schedules
37 C H A P T E R 1 4 T r a n s a c t i o n s E x e r c i s e s 14.1 Show a sequence of updates (withdrawal of money […]
Chapter 11 Homework Suppose I store two dimensional points as the location attribute of a relation, and queries ask for tuples whose location is at exactly a given point
27 C H A P T E R 1 1 I nd e x i n g and H a s h i n g E x e r c i s e s 11.1 Why are B-trees, which have […]
Chapter 10 Homework In disks in the past, the number of sectors per track was the same across all tracks. These days, disks have more sectors per track on outer tracks
25 C H A P T E R 1 0 S t o r ag e and F il e S t r u c t u r e E x e r c i s e s 10.1 If […]
Chapter 9 Homework Is there a security risk with the above snippet? If no, explain why, and if yes, explain why and how to fix it. Consider the following snippet of a program using
23 C H A P T E R 9 A pp li c a t i o n D e s i g n and D e v e l o p m e n t Currently we have just […]
Journalism Teaching Note Homework This decision appears to have been driven by the decision by Gateway to change its positioning and image from folksy to hip
1 Teaching Note Gateway: Searching for the Right Agency Case Overview This case examines Gateway, one of the major competitors in the personal computer industry, and its search to find the right advertising agency and positioning platform for the company. […]
Chapter 8 Homework of the decomposed relations gives the original relations back, and such that super key, foreign key and domain constraints on the decom- posed relations
C H A P T E R 8 R e l a t i o n a l – D a t a b a s e D e s i g n E x e r c i s […]
Journalism Teaching Note Homework The Real California Cheese certification mark was created for the industry as a unifying symbol that provided synergy for all promotional efforts
California Milk Advisory Board Teaching Note This case examines the integrated marketing communications program developed by the California Milk Advisory Board on behalf of the California Cheese industry. It focuses on the “Happy Cows” campaign created by the Deutsch LA […]
Chapter 7 Homework Considering the increasing number of accidents on campus, the security section wishes to automate its accident recording section
C H A P T E R 7 E n t i t y – R e l a t i o n s h i p M o d e l E x e r c i s e […]
Journalism Teaching Note Homework Are there any other sampling or promotional programs that XM should pursue to attract new subscribers and retain them
1 XM Satellite Radio: Competing in the New Digital World Teaching Note Case Overview This case examines XM Satellite Radio Inc., the leader in the satellite-delivered radio market. XM’s founding was promoted by the radio industry’s first major technological development […]
Chapter 6 Homework Suppose the course DBIS has two quizzes, and you want to find the maximum of the two quiz marks for each student of the course
C H A P T E R 6 Formal R e l a t i o n a l Q u e r y L a n g u ag e s Note: Exercises mentioning QBE and Datalog may be […]
Journalism Teaching Note Homework Evaluate the creative strategy used by the Partnership for a Drug Free America in its advertising campaign, particularly with respect to the use of strong fear appeals
1 Using Advertising to Fight the War on Drugs: The Power of Social Marketing or a Waste of Money? Teaching Note Case Overview This case examines the advertising efforts that have been used by the Partnership for a Drug Free […]
Chapter 5 Homework What are authentication, authorization, non-repudiation, and non-duplicatability and why are they important in secure electronic transactions
C H A P T E R 5 A d v a n c e d S Q L E x e r c i s e s 5.1 The following example shows how difficult it is to do some […]
Journalism Teaching Note Homework Do you agree with the decision to use a more mature and less playful approach to advertising for the MAZDA6
1 MAZDA – POSITIONING A PRODUCT LINE TEACHING NOTE Case Overview This case examines Mazda North American Operations and the efforts of the automobile company and its advertising agency, Doner, to its position its vehicles in the highly competitive U.S. […]
Journalism Teaching Note Homework Are the intended branding messages being communicated clearly and do the ads speak equally well to users, as well as non-users, of IBM products and services
1 Development and Implementation and the development of advertising campaigns. The case allows students to analyze the creative strategy and executions used by IBM for the various campaigns. It also provides insight into how each campaign was developed in response […]
Journalism Teaching Note Homework Discuss the consumer decision making process for a product such as canned tuna and the response hierarchy model that is most likely to applicable in the purchase of this product
1 Chicken of the Sea International The Jessica Simpson Spokesperson Decision Teaching Note Case Overview This case examines Chicken of the Sea International (COSI), one of the major competitors in the canned/packaged tuna and seafood industry, and the decision facing […]
Journalism Teaching Note Homework Do you agree with Benetton’s decision to drop the use of shock ads and return to the use of more conventional ads
1 Teaching Note Benetton Group: Evolution of Communication Strategy Case Overview This case examines the controversial “shock advertising” campaign that was used by Benetton, the Italian-based clothing manufacturer and retailer for nearly two decades. Thanks to its unusual Benetton has […]
Journalism Teaching Note Homework Evaluate the strategy used by Under Armour to enter the basketball shoe market and compete against Nike as well as adidas and Reebok
1 Case Teaching Note Under Armour Enters The Basketball Shoe Market Case Overview This case examines Under Armour (UA), the highly successful athletic apparel and footwear company that was founded in 1996 and is now approaching $1 billion in sales. […]
Journalism Chapter 22 Homework Personal selling will take on a more or less important role depending upon the characteristics of the firm and the marketplace in which it is competing
Chapter 22 – Personal Selling (online) 22-1 CHAPTER 22 PERSONAL SELLING (ONLINE) Chapter Overview While certainly an integral part of the promotional mix, personal selling is generally the responsibility of the sales department rather than the advertising or promotional departments. […]
Journalism Chapter 21 Homework They argue that children, especially young ones, are vulnerable to advertising because they lack the necessary experience and knowledge to understand
Chapter 21 – Evaluating the Social, Ethical, and Economic Aspects of Advertising and Promotion 21–12 There are numerous arguments that are offered by those individuals or groups opposed to advertising to children. They argue that children, especially young ones, are […]
Journalism Chapter 21 Homework Advertising is a part of life and children must learn to deal with it as part of the consumer socialization process of acquiring the skills needed to function in the marketplace
Chapter 21 – Evaluating the Social, Ethical, and Economic Aspects of Advertising and Promotion 21-1 CHAPTER 21 EVALUATING THE SOCIAL, ETHICAL, AND ECONOMIC ASPECTS OF ADVERTISING AND PROMOTION Chapter Overview The purpose of this final chapter is to evaluate the […]
Journalism Chapter 20 Homework It is likely that distilled spirits are at a competitive disadvantage to beer and wine since the latter two products can be advertised on radio and television.
Chapter 20 – Regulation of Advertising and Promotion There is a need for regulation of advertising and other IMC tools as consumers rely on the information provided by marketers to make consumption decisions. If this information is false and/or misleads […]
Journalism Chapter 20 Homework For many years the advertising industry has practiced and promoted the use of voluntary self-regulation as a means of regulating and controlling advertising
Chapter 20 – Regulation of Advertising and Promotion 20-1 CHAPTER 20 REGULATION OF ADVERTISING AND PROMOTION Chapter Overview The purpose of this chapter is to examine the regulatory environment in which advertising and promotion operate including industry self-regulation and regulation […]
Journalism Chapter 19 Homework Just as with domestic marketing, companies engaging in international marketing must carefully analyze and consider the major environmental factors of each market in which they compete
Chapter 19 – International Advertising and Promotion 19-1 CHAPTER 19 INTERNATIONAL ADVERTISING AND PROMOTION Chapter Overview The purpose of this chapter is to introduce the student to the role of advertising and promotion in a company’s international marketing program. We […]
Journalism Chapter 18 Homework Many of the methods already mentioned are also used in the post testing of advertisements. The text once again discusses methods of market testing
Chapter 18 – Measuring the Effectiveness of the Promotional Program 18-1 CHAPTER 18 MEASURING THE EFFECTIVENESS OF THE PROMOTIONAL PROGRAM Chapter Overview This chapter discusses one of the most critical—yet controversial—issues in all of advertising. While it seems perfectly logical […]
Journalism Chapter 17 Homework The actual process of conducting public relations will require a number of tasks. These tasks will involve both traditional and new role activities
Chapter 17 – Public Relations, Publicity, and Corporate Advertising 17-1 CHAPTER 17 PUBLIC RELATIONS, PUBLICITY, AND CORPORATE ADVERTISING Chapter Overview Public relations (PR), publicity and corporate advertising are ways by which information about the organization, its products and/or its services […]
Journalism Chapter 16 Homework In this chapter we examine the very important area of sales promotion including the promotional activities directed at consumers as well as the trade. This is a very long chapter as its covers both consumer
Chapter 16 – Sales Promotion 16–14 C. Media Support and Timing—using a promotion without prior or concurrent advertising can limit VI. SALES PROMOTION ABUSE The increasing use of sales promotion in the marketing program represents a change in the fundamental, […]
Journalism Chapter 16 Homework a direct inducement that offers an extra value or incentive for the product to the sales force, distributors or the ultimate consumer with the primary objective of creating an immediate sale
Chapter 16 – Sales Promotion 16-1 CHAPTER 16 SALES PROMOTION Chapter Overview In this chapter we turn our attention to sales promotion and its role in a firm’s integrated marketing communications program. We examine how marketers use both consumer– and […]
Journalism Chapter 15 Homework The Internet has used its own methods for measuring effectiveness as well as some traditional methods. In an attempt to respond to criticisms and to adopt a standard basis for measurement
Chapter 15 – The Internet and Interactive Media 15-1 CHAPTER 15 THE INTERNET AND INTERACTIVE MEDIA Chapter Overview Perhaps the most intriguing of all media—at least to students—is the Internet and Interactive media. Since the inception of the World Wide […]
Journalism Chapter 14 Homework Direct marketers are very good at determining the effectiveness of their programs. Many direct marketers now measure the impact of the program on the consumer funnel
Chapter 14 – Direct Marketing 14-1 CHAPTER 14 DIRECT MARKETING Chapter Overview One of the most rapidly growing areas in marketing is direct marketing. A variety of direct response media are used to convey the communications message. In this chapter […]
Journalism Chapter 13 Homework sales promotion and motivational communications medium which employs useful articles of merchandise imprinted with an advertiser’s name, message, or logo
Chapter 13 – Support Media 13-1 CHAPTER 13 SUPPORT MEDIA Chapter Overview In addition to the broadcast and print media discussed in the two previous chapters, marketers have a variety of alternative media from which to choose. In fact, the […]
Journalism Chapter 12 Homework there are several problems facing the magazine industry including declines in readership and advertising pages and increasing postal rates and paper costs
Chapter 12 – Evaluation of Print Media 12-1 CHAPTER 12 EVALUATION OF PRINT MEDIA Chapter Overview This chapter continues the analysis of the major media of advertising by examining the two primary types of print media—magazines and newspapers. The characteristics […]
Journalism Chapter 12 Homework Magazines and newspapers still play an important role in the media strategy of many advertisers as they have a number of important characteristics which they must continue to promote
Chapter 12 – Evaluation of Print Media As discussed in the chapter opener, newspapers and magazines are facing major challenges on a number of fronts. Both of these print media have been hit hard by the recession which has led […]
Journalism Chapter 11 Homework As discussed in the chapter, there are a number of problems with the sweeps ratings periods used to measure local TV viewing audiences
Chapter 11 – Evaluation of Media: Television and Radio Digital video recorders and video on demand (VOD) are major technological developments impacting the way people watch television and will continue to do so in the future. DVRs allow shows to […]
Journalism Chapter 11 Homework Radio has become a very viable media option for national as well as local advertisers. Examples of the creative and effective use of radio are readily available
Chapter 11 – Evaluation of Media: Television and Radio 11-1 CHAPTER 11 EVALUATION OF MEDIA: TELEVISION AND RADIO Chapter Overview The purpose of this chapter is to examine the media of television and radio. We examine the general characteristics of […]
Journalism Chapter 10 Homework Media objectives relate to the goals to be attained by the media program, and as such should be limited to those that can be accomplished through media strategies
Chapter 10 – Media Planning and Strategy 10-1 CHAPTER 10 MEDIA PLANNING AND STRATEGY Chapter Overview Chapter 10 introduces the concepts involved in media planning. The chapter begins with an overview of media planning by introducing some key terms and […]
Journalism Chapter 9 Homework Once the major selling idea and the advertising campaign theme has been agreed upon, the creative team then turns its attention to determining the specific type of appeal
Chapter 09 – Creative Strategy: Implementation and Evaluation 9-1 CHAPTER 9 CREATIVE STRATEGY: IMPLEMENTATION AND EVALUATION Chapter Overview In the previous chapter the importance of advertising creativity was examined along with the creative process of advertising. Attention was also given […]
Journalism Chapter 8 Homework A number of advertising people have argued that creativity in advertising is best viewed as a process and that creative success is most likely when some organized approach is followed
Chapter 8 – Creative Strategy: Planning and Development 8-1 CHAPTER 8 CREATIVE STRATEGY: PLANNING AND DEVELOPMENT Chapter Overview This is the first of two chapters devoted to the area of creative strategy in advertising. This chapter focuses on the planning […]
Journalism Chapter 7 Homework The determination of objectives for integrated marketing communication occurs after a thorough situation analysis has been conducted and the marketing and promotional problems
Chapter 07 – Establishing Objectives and Budgeting for the Promotional Program 7-1 CHAPTER 7 ESTABLISHING OBJECTIVES AND BUDGETING FOR THE PROMOTIONAL PROGRAM Chapter Overview This chapter focuses on the process of setting objectives and budgeting for the IMC program. The […]
Journalism Chapter 7 Homework The text gives a very good example of how the communications effects models can be used to establish communication objectives for a new brand
Chapter 07 – Establishing Objectives and Budgeting for the Promotional Program 7-13 One of the reasons for planning is to improve the company’s overall goals, the other is to determine what worked and what did not. Planners need to know […]
Journalism Chapter 6 Homework Peyton Manning of the Indianapolis Colts and Tom Brady of the New England Patriots are two of the top quarterbacks in the National Football League
Chapter 6 – Source, Message, and Channel Factors 6-12 Power is a source characteristic when the source can actually administer rewards and punishments to the receiver and operates through a process known as compliance whereby the receiver accepts the 4. […]
Journalism Chapter 6 Homework while a celebrity may draw attention to an ad, consumers may focus on the celebrity rather than the product or service and the advertising message
Chapter 6 – Source, Message, and Channel Factors 6-1 CHAPTER 6 SOURCE, MESSAGE, AND CHANNEL FACTORS Chapter Overview This chapter is a continuation of the discussion of communications theory and focuses on the controllable variables that are a part of […]
Journalism Chapter 5 Homework An important aspect of developing effective communication involves having an understanding of the response process the receiver may go through and how the promotional
Chapter 05 – The Communication Process 5-1 CHAPTER 5 THE COMMUNICATION PROCESS Chapter Overview The purpose of this chapter is to examine the communication process by introducing the student to the fundamentals of communication and examining various models and perspectives […]
Journalism Chapter 4 Homework A brief introduction to the field of consumer behavior and an indication of the increased importance that this domain of study has assumed in marketing would be a good
Chapter 4 – Perspectives on Consumer Behavior 4-1 CHAPTER 4 PERSPECTIVES ON CONSUMER BEHAVIOR Chapter Overview The purpose of this chapter is to examine the field of consumer behavior and to demonstrate how knowledge and understanding of the consumer can […]
Journalism Chapter 3 Homework The Decentralized System in this system, individual products or brands are the responsibility of the product manager or brand manager
Chapter 03 – Organizing for Advertising and Promotion: The Role of Ad Agencies and Other Marketing Communication Organizations 3-1 CHAPTER 3 ORGANIZING FOR ADVERTISING AND PROMOTION: THE ROLE OF AD AGENCIES AND OTHER MARKETING COMMUNICATION ORGANIZATIONS Chapter Overview The purpose […]
Journalism Chapter 2 Homework To know the various decision areas under each element of the marketing mix and how they influence and interact with advertising and promotional strategy
Chapter 02 – The Role of IMC in the Marketing Process 2-1 CHAPTER 2 THE ROLE OF IMC IN THE MARKETING PROCESS Chapter Overview The purpose of this chapter is to examine the marketing process and the role of advertising […]
Journalism Chapter 1 Homework Discuss the role of integrated marketing communications in the marketing program of automobile manufacturers such as Volkswagen. How can Volkswagen use the various
Chapter 01 – An Introduction to Integrated Marketing Communications 1-13 Answers to Discussion Questions 1. Discuss the role of integrated marketing communications in the marketing program of automobile manufacturers such as Volkswagen. How can Volkswagen use the various IMC tools […]