Archives: Solution Manual

LEARNING OBJECTIVES In this chapter, we will address the following questions: 1. How do consumer characteristics influence buying behavior? 2. What major psychological processes influence consumer responses to the marketing program? 3. How do consumers make purchasing decisions? 4. In […]

LEARNING OBJECTIVES In this chapter, we will address the following questions: 1. What are customer value, satisfaction, and loyalty, and how can companies deliver them? 2. What is the lifetime value of customers and how can marketers maximize it? 3. […]

LEARNING OBJECTIVES In this chapter, we will address the following questions: 1. What is the scope of marketing research? 2. What steps are involved in conducting good marketing research? 3. What are the best metrics for measuring marketing productivity? CHAPTER […]

Professors on the Go Chapter 18 Managing Retailing, Wholesaling, and Logistics Key Chapter Concepts: Retailing Types of Retailers Franchising New types of Competitors Advances in Retail Technology Retail Marketing Decisions Store Atmosphere Private Label Brands Wholesaling Market Logistics Integrated Logistics […]

LEARNING OBJECTIVES In this chapter, we will address the following questions: 1. What are the components of a modern marketing information system? 2. What are useful internal records for such a system? 3. What makes up a marketing intelligence system? […]

Case-Oriented Syllabus Soren Chemical: Why is the New Swimming Pool Product Sinking? Branding; Communication strategy; Marketing channels; Marketing mix; Marketing strategy; New product marketing; Pricing product B2B through “chemical formulators” serving the commercial pools market — but Soren uses wholesale […]

Professors on the Go Chapter 12 Addressing Competition and Driving Growth Key Chapter Concepts: Growth Strategies Growing the Core Competitive Strategies for Market Leaders General Attack Strategies Market-Follower Strategies Product Life-Cycle Marketing Strategies Product Life Cycles Pioneering Advantages Four Stages […]

LEARNING OBJECTIVES In this chapter, we will address the following questions: 1. How does marketing affect customer value? 2. How is strategic planning carried out at the corporate and divisional levels? 3. How is strategic planning carried out at the […]

Professors on the Go Chapter 1 Defining Marketing for Future Realities Key Chapter Concepts: Marketing Marketing Management Marketer Prospect Needs Wants Demands Target markets Market offering Positions Value proposition Offering Brand Communication channels Distribution channels Paid media Owned media Earned […]

LEARNING OBJECTIVES In this chapter, we will address the following questions: 1. Why is marketing important? 2. What is the scope of marketing? 3. What are some core marketing concepts? 4. What forces are defining the new marketing realities? 5. […]

Chapter 10C – Managing Databases with MySQL 5.7 Page 10C-136 (2) Deleting a SHIPMENT when the last SHIPMENT_ITEM is deleted. MySQL will not support an appropriate trigger in this case. We cannot use a view, since MySQL does not support […]

Chapter 10C – Managing Databases with MySQL 5.7 Page 10C-101 C. Create and test a user-defined function named FirstNameFirst that combines two parameters named FirstName and LastName into a concatenated name field formatted FirstName LastName (including the space). DELIMITER // […]

Chapter 10C – Managing Databases with MySQL 5.7 Page 10C-121 ALTER TABLE SHIPMENT auto_increment = 100; CREATE TABLE SHIPMENT_ITEM ( ShipmentID Int NOT NULL, ShipmentItemID Int NOT NULL, ); CREATE TABLE SHIPMENT_RECEIPT ( ReceiptNumber Int NOT NULL auto_increment, ShipmentID Int […]

Chapter 10C – Managing Databases with MySQL 5.7 Page 10C-61 . G. Populate the postcard_size_price table using the data stored in the postcards_temp table. Hint: You should insert distinct data into the table, and your final table will only have […]

Chapter 10C – Managing Databases with MySQL 5.7 Page 10C-81 P. Explain, in general terms, how you will use triggers to enforce minimum cardinality actions as required by your design. You need not write the triggers, just specify which triggers […]

Chapter 10C – Managing Databases with MySQL 5.7 10C.33 If possible, code a MySQL trigger to allow the deletion of a department if it only has one employee. Before deleting the department, assign the last employee to the Human Resources […]

Chapter 10C – Managing Databases with MySQL 5.7 H. Write a stored procedure to update customer phone data. Assume that your stored procedure receives LastName, FirstName, PriorAreaCode, NewAreaCode, PriorPhoneNumber, and NewPhoneNumber. Your procedure should first ensure that there is only […]

INSTRUCTOR’S MANUAL TO ACCOMPANY 40th Anniversary Edition DATABASE PROCESSING Fundamentals, Design, and Implementation 15th Edition Online Chapter 10C Managing Databases Using MySQL 5.7 David M. Kroenke | David J. Auer | Scott L. Vandenberg | Robert C. Yoder Prepared By […]

Chapter 10B – Managing Databases with Oracle Database Page 10B-161 T. Create a new table named PAYROLL, as shown in Figure 10B-90. Use the column characteristics shown in Figure 10B-90. Note that PayrollEntryID is a surrogate key, with initial value […]

Chapter 10B – Managing Databases with Oracle Database Page 10B-121 — Return the last name RETURN varLastName; END; / Z. Create a user-defined function named GetFirstNameCommaSeparated that will return the first name from a combined name in last-name-first order, with […]

Chapter 10B – Managing Databases with Oracle Database Page 10B-81 Solutions for 12c are presented first, followed by solutions for XE 11.2. For Oracle Database 12c, see the discussion and follow the steps in pages 10B-34 – 10B-36 for tablespaces, […]

Chapter 10B – Managing Databases with Oracle Database readDateOfBirth := artist.DateOfBirth; readDateDeceased := artist.DateDeceased; DBMS_OUTPUT.PUT_LINE (‘===================================================================’); DBMS_OUTPUT.PUT_LINE (‘Artist Name = ‘ ||readLastName||’, ‘||readFirstName|| ‘ Nationality = ‘ || readNationality); DBMS_OUTPUT.PUT_LINE (‘Year of Birth = ‘ || readDateOfBirth); DBMS_OUTPUT.PUT_LINE (‘Year of […]

Chapter 10B – Managing Databases with Oracle Database / To test this, run the following commands: INSERT INTO PURCHASE_ITEM (PurchaseItemID, StoreID, PurchasingAgentID, PurchaseDate, ItemDescription, Category, PriceUSD) VALUES( seqIID.NextVal, 1000, 101, ’06-Sep-18′, ‘Large bureau’, ‘Furniture’, 9500); INSERT INTO PURCHASE_ITEM (PurchaseItemID, StoreID, […]

Chapter 10B – Managing Databases with Oracle Database SET SERVEROUTPUT ON; DELETE FROM DeleteSaleItemView WHERE SaleID = 17 AND SaleItemID = 1; Page 10B-141 Chapter 10B – Managing Databases with Oracle Database Page 10B-142 Note that Oracle responds with “1 […]

Chapter 10B – Managing Databases with Oracle Database Page 10B-101 We will need to use views to allow us to successfully handle this problem in Oracle. This will allow us to use an INSTEAD OF DELETE trigger. We will create […]

Chapter 10B – Managing Databases with Oracle Database Page 10B-21 10B.37 For the View Ridge Gallery database, construct a view that has full customer name and full artist name for all artists in which the customer is interested. Explain the […]

INSTRUCTOR’S MANUAL TO ACCOMPANY 40th Anniversary Edition DATABASE PROCESSING Fundamentals, Design, and Implementation 15th Edition Chapter 10B Managing Databases with Oracle Database David M. Kroenke | David J. Auer | Scott L. Vandenberg | Robert C. Yoder Prepared By Scott […]

Chapter 10B – Managing Databases with Oracle Database 10B.70 Design a system of triggers to enforce the M-M relationship. Use Figure 10B-72 as an example, but assume that departments with only one employee can be deleted. Assign the last employee […]

Chapter 10A – Managing Databases with SQL Server 2017 Page 10A-161 B. Create and test a view called PurchasingAgentSummaryView that contains the employee name of any MI employees who purchase items for the company, concatenated and formatted as LastName, FirstName […]

Chapter 10A – Managing Databases with SQL Server 2017 Page 10A-121 GG. [AG in text] Alter the EMPLOYEE$ table to include an EmployeeID column (Integer data, allow nulls). By using and comparing the EMPLOYEE$.EmployeeLastName and EMPLOYEE$.EmployeeFirstName columns with the EMPLOYEE.EmployeeLastName […]

Chapter 10A – Managing Databases with SQL Server 2017 Page 10A-101 WHERE InvoiceNumber = 2018011 AND ItemNumber = 2; SELECT * FROM DeleteInvoiceItem; DELETE FROM DeleteInvoiceItemView WHERE InvoiceNumber = 2018011 AND ItemNumber = 1; Chapter 10A – Managing Databases with […]

Chapter 10A – Managing Databases with SQL Server 2017 Page 10A-81 /***** CUSTOMER Data *********************************************************/ INSERT INTO CUSTOMER VALUES( ‘Nikki’, ‘Kaccaton’, ‘723-543-1233′, ‘Nikki.Kaccaton@somewhere.com’); INSERT INTO CUSTOMER VALUES( ‘Brenda’, ‘Catnazaro’, ‘723-543-2344′, ‘Brenda.Catnazaro@somewhere.com’); INSERT INTO CUSTOMER VALUES( ‘Bruce’, ‘LeCat’, ‘723-543-3455′, ‘Bruce.LeCat@somewhere.com’); INSERT […]

Chapter 10A – Managing Databases with SQL Server 2017 Page 10A-61 10A.41 Write SQL statements to accomplish the following tasks, and submit them to SQL Server 2017 via the Microsoft SQL Server Management Studio. Save your work in an SQL […]

Chapter 10A – Managing Databases with SQL Server 2017 Page 10A-41 View Ridge Gallery Exercises Review Questions 10.40 and 10.41 are based on the View Ridge Gallery database discussed in this chapter. 10A.40 Write SQL statements to accomplish the following […]

Chapter 10A – Managing Databases with SQL Server 2017 Page 10A-177 — SHIPMENT ShipmentID exists – Send error message. BEGIN SELECT @AssignedShipmentNumber = ShipmentID FROM SHIPMENT WHERE SHIPMENT.ShipmentID= @NewPurchaseItemNumber; END; ELSE BEGIN /* Create the SHIPMENT and COMMIT the transaction […]

Chapter 10A – Managing Databases with SQL Server 2017 Page 10A-21 /***** EMPLOYEE DATA ********************************************************/ INSERT INTO EMPLOYEE VALUES( ‘Mary’, ‘Jacobs’, ‘Administration’, ‘CEO’, NULL, ‘360-285-8110’, ‘Mary.Jacobs@WP.com’); ‘Alan’, ‘Adams’, ‘Human Resources’, ‘HR1’, 4, ‘360-285-8320’, ‘Alan.Adams@WP.com’); INSERT INTO EMPLOYEE VALUES( ‘Ken’, ‘Evans’, […]

Chapter 10A – Managing Databases with SQL Server 2017 Page 10A-141 Here is the trigger code: CREATE OR ALTER TRIGGER [Insert_SALE_SALE_ITEM] ON [dbo].[SaleWithSaleItemsView] INSTEAD OF INSERT AS SET NOCOUNT ON; /* SALE.Sale is a surrogate key. DO NOT INCLUDE IT […]

INSTRUCTOR’S MANUAL TO ACCOMPANY 40th Anniversary Edition DATABASE PROCESSING Fundamentals, Design, and Implementation 15th Edition Online Chapter 10A Managing Databases with SQL Server 2017 David M. Kroenke | David J. Auer | Scott L. Vandenberg | Robert C. Yoder Prepared […]

Chapter Twelve – Data Warehouses, Business Intelligence Systems, and Big Data Page 12-38 SELECT C.CustomerID, C.CustomerName, C.EmailDomain, S.ServiceID, S.ServiceDescription, I.DateIn, T.Year, T.QuarterText, SUM(II.ExtendedPrice) AS TotalEP FROM CUSTOMER C, SERVICE S, INVOICE I, TIMELINE T, INVOICE_ITEM II WHERE C.CustomerID = II.CustomerID […]

Chapter Twelve – Data Warehouses, Business Intelligence Systems, and Big Data Page 12-21 Chapter Twelve – Data Warehouses, Business Intelligence Systems, and Big Data H. Write the SQL view equivalent of the SQL query you wrote to answer part G. […]

INSTRUCTOR’S MANUAL TO ACCOMPANY 40th Anniversary Edition DATABASE PROCESSING Fundamentals, Design, and Implementation 15th Edition Chapter 12 Data Warehouses, Business Intelligence Systems, and Big Data David M. Kroenke | David J. Auer | Scott L. Vandenberg | Robert C. Yoder […]

Chapter Eleven – The Web Server Environment Page 11–78 // Test existence of recordset if (!$RecordSet) { exit (“SQL Statement Error: ” . $SQL); } ?> <!– Page Headers –> <h1> The Morgan Importing Store Purchases View </h1> <hr /> […]

Chapter Eleven – The Web Server Environment Page 11–21 ❖ ANSWERS TO PROJECT QUESTIONS 11.92 In this exercise you’ll create a Web home page in the DBP folder and link it to the VRG Home page in the VRG folder. […]

INSTRUCTOR’S MANUAL TO ACCOMPANY 40th Anniversary Edition DATABASE PROCESSING Fundamentals, Design, and Implementation 15th Edition Chapter 11 The Web Server Environment David M. Kroenke | David J. Auer | Scott L. Vandenberg | Robert C. Yoder Prepared By David J. […]

Chapter Eleven – The Web Server Environment Page 11–61 Web/PHP Page code: <!DOCTYPE HTML> <html> <head> </head> <body> <?php // Get connection $DSN = “QACS”; $User = “QACS-User”; $Password = “QACS-User+password”; $Conn = odbc_connect($DSN, $User, $Password); // Test connection if […]

Chapter Eleven – The Web Server Environment Page 11–41 H. Write a stored procedure that receives values for InvoiceNumber and NewStatus and that sets the value of Status to NewStatus for the row having the given value of InvoiceNumber. Generate […]

“Copy”: “583/750” }] “CustomerID”: 1000, “LastName”: “Janes”, “FirstName”: “Jeffrey”, “EmailAddress”: “Jeffrey.Janes@somewhere.com”, “State”: “WA”, “ZIPorPostalCode”: 98005, “Country”: “USA” }, { “CustomerID”: 1015, “LastName”: “Twilight”, “FirstName”: “Tiffany”, “EmailAddress”: “Tiffany.Twilight@somewhere.com”, “State”: “WA”, “ZIPorPostalCode”: 98260, “Country”: “USA” } ], “Works”: [{ “WorkID”: 564, “Title”: […]

INSTRUCTOR’S MANUAL TO ACCOMPANY 40th Anniversary Edition DATABASE PROCESSING Fundamentals, Design, and Implementation 15th Edition Appendix L JSON and Document Databases David M. Kroenke | David J. Auer | Scott L. Vandenberg | Robert C. Yoder Prepared By Scott L. […]

INSTRUCTOR’S MANUAL TO ACCOMPANY 40th Anniversary Edition DATABASE PROCESSING Fundamentals, Design, and Implementation 15th Edition Appendix K Big Data David M. Kroenke | David J. Auer | Scott L. Vandenberg | Robert C. Yoder Prepared By Scott L. Vandenberg Siena […]

Appendix J –Business Intelligence Systems Page J-32 To test this procedure use: Execute Calculate_R; SELECT * FROM CUSTOMER_R; Appendix J –Business Intelligence Systems /***************** PROCEDURE Calculate_F **********************/ CREATE PROCEDURE Calculate_F AS /* Compute F_Score */ INSERT INTO CUSTOMER_F (CustomerID, OrderCount) […]