Archives: Solution Manual

2: Collaboration, Interpersonal Communication, and Business Etiquette Copyright © 2019 Pearson Education, Inc. 2-1 CHAPTER 2: Collaboration, Interpersonal Communication, and Business Etiquette CHAPTER SUMMARY Building on material presented in Chapter 1, this chapter focuses on improving interpersonal skills that are […]

1: Professional Communication in a Digital, Social, Mobile World 1-1 [To register for Bovée & Thill’s Real-Time Updates service at http://rtu.businesscommunicationnetwork.com/ use resources as the password] Chapter Guides This section provides information about the chapters in the textbook and suggested […]

More Practice in Grammar, Mechanics, and Usage 47 MORE PRACTICE IN GRAMMAR, MECHANICS, AND USAGE The following exercises are keyed to the “Handbook of Grammar, Mechanics, and Usage.” Solutions are given at end of the exercises. 1. Possessive nouns Review […]

All Sections – The Access Workbench SECTION EIGHT  CHAPTER OBJECTIVES • Learn how to create an OLAP report for Microsoft Access databases as an Excel PivotTable  CHAPTER ERRATA There are no known errors at this time. Any errors […]

All Sections – The Access Workbench // Table data while($RecordSetRow = odbc_fetch_array($RecordSet)) { echo “<tr>”; echo “<td>” . $RecordSetRow[‘NickName’] . “</td>”; echo “<td>” . $RecordSetRow[‘LastName’] . “</td>”; echo “<td>” . $RecordSetRow[‘FirstName’] . “</td>”; echo “<td>” . $RecordSetRow[‘HireDate’] . “</td>”; echo […]

All Sections – The Access Workbench C. Create a form that allows users to view and edit project data. The form should show information about the project, the department that is responsible for the project, and it should list all […]

All Sections – The Access Workbench CREATE TABLE COMPUTER_ASSIGNMENT( SerialNumber Int NOT NULL, EmployeeNumber Int NOT NULL, DateAssigned Date NOT NULL, DateReassigned Date NULL, CONSTRAINT COMP_ASSIGN_PK PRIMARY KEY (SerialNumber, EmployeeNumber, DateAssigned), CONSTRAINT COMP_ASSIGN_EMPLOYEE FOREIGN KEY(EmployeeNumber) REFERENCES EMPLOYEE(EmployeeNumber) ON UPDATE NO […]

All Sections – The Access Workbench SECTION THREE  CHAPTER OBJECTIVES • Learn how to use Microsoft Access SQL • Learn how to run queries in single and multiple tables, using both SQL and Query by Example (QBE) • Learn […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by David J. Auer All Sections including Appendix E and Appendix H The Access Workbench All rights reserved. […]

Page 1 of 16 Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by Robert C. Yoder APPENDIX K BIG DATA Page 2 of 16 All rights […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by Scott L. Vandenberg Appendix J Business Intelligence Systems All rights reserved. No part of this publication may […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by David J. Auer Appendix I Getting Started with Web Servers, PHP, and the NetBeans IDE All rights […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by David J. Auer Appendix H The Access Workbench Section H — Microsoft Access 2016 Switchboards All rights […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by David J. Auer Appendix G Getting Started with Visio 2016 All rights reserved. No part of this […]

Page 1 of 10 Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by Robert C. Yoder APPENDIX F Getting Started in Systems Analysis and Design All […]

Appendix E – Advanced SQL SELECT C.FirstName AS CustomerFirstName, C.LastName AS CustomerLastName, R.FirstName AS ReferrerFirstName, R.LastName AS ReferrerLastName FROM CUSTOMER C LEFT JOIN CUSTOMER R ON C.ReferredBy = R.CustomerID; G. Suppose that James River Jewelry owners are considering changing the […]

Appendix E – Advanced SQL ALTER TABLE EMPLOYEE ADD Supervisor Int NULL; ALTER TABLE EMPLOYEE ADD CONSTRAINT EMP_EMP_FK FOREIGN KEY (Supervisor) REFERENCES EMPLOYEE (EmployeeID); UPDATE EMPLOYEE SET Supervisor = 5 WHERE EmployeeID = 2; UPDATE EMPLOYEE SET Supervisor = 1 […]

Appendix E – Advanced SQL D. How did your steps to add the Training column differ from your steps to add the Supervisor column? Why was (were) the additional step(s) necessary? The Supervisor column required an extra step: creation of […]

Appendix E – Advanced SQL NOTE: We are not implementing the UNIQUE constraint; it’s no longer part of the question. /*** Add the column and foreign key constraint ***/ ALTER TABLE CUSTOMER ADD ReferredBy Int NULL; ALTER TABLE CUSTOMER ADD […]

Appendix E – Advanced SQL For Microsoft Access: SELECT * FROM viewPetCount ORDER BY PetType; For SQL Server, Oracle Database, and MySQL: SELECT * FROM PetCountView ORDER BY PetType; E.33 Code an SQL statement to create a view named DogBreedCountView […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by Scott L. Vandenberg Online Appendix E Advanced SQL All rights reserved. No part of this publication may […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by David J. Auer Appendix D James River Jewelry Project Questions All rights reserved. No part of this […]

Appendix C – Getting Started with MySQL 5.7 Community Server Edition © 2018 Pearson Education, Inc. Page 14 of 25 IMPORTANT: If you are using the Microsoft Windows operating system, download and use the MySQL Installer for Windows! Do not […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by Robert C. Yoder and David J. Auer Appendix C Getting Started with MySQL 5.7 Community Server All […]

Appendix B – Getting Started with Oracle Database XE We will first import the table then create foreign keys in the new table linking it to COMPUTER and to EMPLOYEE. We will use the following column characteristics, which reflect Access […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by Scott L. Vandenberg Appendix B Getting Started with Oracle Database XE All rights reserved. No part of […]

Appendix A – Getting Started with Microsoft SQL Server 2016 10. Click the Next button to display the Save and Run Package page. The defaults are correct. 11. Click the Next button to display the Complete the Wizard page. This […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by David J. Auer Appendix A Getting Started with Microsoft SQL Server 2016 All rights reserved. No part […]

Page 1 of 62 Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by Robert C. Yoder and David J. Auer CHAPTER EIGHT BIG DATA, DATA WAREHOUSES, […]

Chapter Eight – Big Data, Data Warehouses and Business Intelligence Systems Page 52 of 62 D. What transformations of data will need to be made before the JRJ-DW database can be loaded with data? List all the transformations, showing the […]

Chapter Eight – Big Data, Data Warehouses and Business Intelligence Systems Page 41 of 62  ANSWERS TO GARDEN GLORY PROJECT QUESTIONS If you have not already implemented the Garden Glory database shown in Chapter 3 in a DBMS product, […]

Chapter Eight – Big Data, Data Warehouses and Business Intelligence Systems See the file: DBC-e08-MSSQL-HSD-DW-Create-SALES_FOR_RFM.sql. F. What transformations of data are necessary to load the SALES_FOR_RFM table? List any needed transformations, showing the original format of the HSD data and […]

Chapter Seven – Database Processing Applications E. Code a Web page using PHP to display the data in OWNED_PROPERTY. Add a hyperlink on the GG Web page to access the page. Using your database, demonstrate that your page works. <!DOCTYPE […]

Chapter Seven – Database Processing Applications NewCustomerForm.html HTML Code: <!DOCTYPE html> <html> <head> <meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”> <title>NewCustomerForm HTML Page</title> <style type=“text/css”> h1 {text-align: center; color: blue} h2 {font-family: Ariel, sans-serif; text-align: left; color: blue} p.footer {text-align: center} table.output {font-family: […]

Chapter Seven – Database Processing Applications Web Page code: <!DOCTYPE html> <html> <head> <title>Marcia’s Dry Cleaning Demonstration Pages Home Page</title> <meta charset=”UTF–8″> <meta name=”viewport” content=”width=device–width, initial–scale=1.0″> </head> <body> <h1 style=”text–align: center; color: blue“> Database Concepts (8th Edition) </h1> <h2 style=”text–align: […]

Chapter Seven – Database Processing Applications !DOCTYPE> <html> <head> <meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8”> <title>ReadCustomer PHP Page</title> <style type=“text/css”> h1 {text-align: center; color: blue} h2 {font-family: Ariel, sans-serif; text-align: left; color: blue} p.footer {text-align: center} table.output {font-family: Ariel, sans-serif} </style> </head> […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg• Robert C. Yoder Instructor’s Manual Prepared by David J. Auer Chapter 7 Database Processing Applications All rights reserved. No part of this publication may be […]

Chapter Six – Database Administration E. Summarize the recovery capabilities of Oracle Database XE. See the answer to Question D above. 6.52 If you have access to MySQL 5.7, search its help system to answer the following questions. A. How […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by Scott L. Vandenberg Chapter Six Database Administration All rights reserved. No part of this publication may be […]

Chapter Five – Database Design © 2018 Pearson Education, Inc. Page 54 of 66 Chapter Five – Database Design © 2018 Pearson Education, Inc. Page 55 of 66 Chapter Five – Database Design B. Describe how you have represented weak […]

Chapter Five – Database Design  ANSWERS TO GARDEN GLORY PROJECT QUESTIONS Convert the data model you constructed for Garden Glory in part B at the end of Chapter 4 (or an equivalent data model that your instructor provides for […]

Chapter Five – Database Design N:M Recursive; If agents in the community where PNWREA is located want to acquire property themselves, they are required to use another agent (not necessarily at PNWREA) to act as the selling agent on the […]

Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg• Robert C. Yoder Instructor’s Manual Prepared by David J. Auer Chapter 5 Database Design All rights reserved. No part of this publication may be reproduced, […]

Chapter Four – Data Modeling and the Entity-Relationship Model Page 21 of 52 4.30 Extend your work for question 4.29 to include supplies that Heather uses on a project. Assume that she wants to track the description, price, and amount […]

Chapter Four – Data Modeling and the Entity-Relationship Model Page 37 of 52 Chapter Four – Data Modeling and the Entity-Relationship Model Page 38 of 52 C. Describe how you would go about validating the model in part B. This […]

Page 1 of 52 Database Concepts 8th Edition David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder Instructor’s Manual Prepared by Robert C. Yoder and David J. Auer CHAPTER FOUR DATA MODELING AND THE […]

Chapter Three – Structured Query Language INSERT INTO VENDOR VALUES( ‘New York Brokerage’, ‘Smith’, ‘Mark’, ‘621 Roy Street’, ‘Seattle’, ‘WA’, ‘98109’, ‘206-325-9088’, ‘206-329-9908’, ‘NYB@business.com’); INSERT INTO VENDOR (ContactLastName, ContactFirstName, Address, City, State, ZIP, Phone, EmailAddress) VALUES( ‘Walsh’, ‘Denesha’, ‘6712 24th […]

Chapter Three – Structured Query Language J. Answer part I but use a join using JOIN ON syntax. For SQL Server, Oracle, and MySQL: SELECT DISTINCT LastName, FirstName FROM CUSTOMER JOIN PURCHASE ON CUSTOMER.CustomerID = PURCHASE.CustomerID JOIN PURCHASE_ITEM ON PURCHASE.InvoiceNumber […]

Chapter Three – Structured Query Language G. Write an SQL statement to list the INVOICE.InvoiceNumber for sales that include the Heather Sweeney Seminar Live in Dallas on 25-OCT-15 video. Use a subquery. (Hint: The correct solution uses three tables in […]

Chapter Three – Structured Query Language SELECT * FROM OWNED_PROPERTY; SELECT * FROM PROPERTY_SERVICE; E. Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master. SELECT LastName, FirstName, CellPhone FROM EMPLOYEE […]