Archives: Solution Manual

Chapter Five – Data Modeling with the Entity-Relationship Model Page 5-73 ❖ THE QUEEN ANNE CURIOSITY SHOP PROJECT QUESTIONS The Queen Anne Curiosity Shop wants to expand its database applications beyond the current recording of sales. The company still wants […]

Chapter Five – Data Modeling with the Entity-Relationship Model Page 5-21 ❖ ANSWERS TO EXERCISES Answer the following questions using IE Crow’s Foot notation. 5.56 Examine the subscription form shown in Figure 5-53. Using the structure of this form, do […]

INSTRUCTOR’S MANUAL TO ACCOMPANY 40th Anniversary Edition DATABASE PROCESSING Fundamentals, Design, and Implementation 15th Edition Chapter 5 Data Modeling with the Entity–Relationship Model David M. Kroenke | David J. Auer | Scott L. Vandenberg | Robert C. Yoder Prepared By […]

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

Chapter Four – Database Design Using Normalization Page 4-18 CLASS (ClassName, Trainer, StartDate, EndDate, Time, DayOfWeek, Cost) CLASS.(ClassName, Trainer, StartDate, Time) → CLASS.EndDate 4.41 Classify each table according to whether it is in BCNF or in 4NF. State your assumptions. […]

Chapter 3 – The Relational Model and Normalization Page 3-33 E. Given your assumptions, comment on the appropriateness of the following designs: 1. PURCHASE (PurchaseItem, PurchasePrice, PurchaseDate, Vendor, Phone) 2. PURCHASE (PurchaseItem, PurchasePrice, PurchaseDate, Vendor, Phone) NOT GOOD. There may […]

Chapter 3 – The Relational Model and Normalization Page 3-21 c. Transform this table into two or more tables such that each table is in BCNF and in 4NF. State the primary keys, candidate keys, foreign keys, and referential integrity […]

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

Chapter Two – Introduction to Structured Query Language Page 2-132 D. List the ShipmentID, ShipperName, and ShipperInvoiceNumber of all shippers whose name starts with “AB”. Solutions to Morgan Importing questions are contained in the Microsoft Access database DBP-e15-IM–CH02-MI.accdb and in […]

Chapter Two – Introduction to Structured Query Language ON C.CustomerID = S.CustomerID JOIN SALE_ITEM SI ON S.SaleID = SI.SaleID JOIN ITEM I ON SI.ItemID = I.ItemID WHERE ItemDescription = ‘Desk Lamp’ ORDER BY LastName, FirstName DESC; Note that for Microsoft […]

Chapter Two – Introduction to Structured Query Language Page 2-101 Figure 2-54 – The QACS Database The column characteristics for the tables are shown in Figures 2-55, 2-56, 2-57, and 2-58. The relationships CUSTOMER-to-SALE and ITEM-to–SALE_ITEM should enforce referential integrity, […]

Chapter Two – Introduction to Structured Query Language Page 2-81 Figure 2-49 – Column Characteristics for the MDC Database INVOICE Table Figure 2-50 – Column Characteristics for the MDC Database INVOICE_ITEM Table Figure 2-51 – Sample Data for the MDC […]

Chapter Two – Introduction to Structured Query Language Page 2-61 A. What projects are in the PROJECT table? Show all information for each project. /***** Question A – SQL-Query-02-A ************************/ SELECT * FROM PROJECT; B. What are the ProjectID, ProjectName, […]

Chapter Two – Introduction to Structured Query Language Note that the “GROUP BY” clause is necessary here since warehouse manager names are not necessarily unique: since the question asks for warehouse ID, there should be one result for each warehouse […]

Chapter Two – Introduction to Structured Query Language Page 2-21 2.22 Write an SQL statement to display all of the columns using the SQL asterisk (*) wildcard character. SQL Solutions to Project Questions 2.17 – 2.60 are contained in the […]

Chapter Two – Introduction to Structured Query Language Page 2-1 INSTRUCTOR’S MANUAL TO ACCOMPANY 40th Anniversary Edition DATABASE PROCESSING Fundamentals, Design, and Implementation 15th Edition Chapter 2 Introduction to Structured Query Language David M. Kroenke | David J. Auer | […]

Chapter 1 – Introduction The development of the first database technology was driven by the need for data integration. In the early days of computer technology, data was stored in separate files, and often processed by different applications. Users needed […]

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

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 14: Exploring Destructive Leadership Learning Objectives 1. Describe three defining components of destructive leadership 2. Analyze methods for addressing toxic leadership through the perspectives of leaders, followers, […]

Peter G. Northouse Introduction to Leadership, 5e SAGE Publishing, 2020 Case Notes Chapter 14: Destructive Leadership Case 14.1: Dr. Chen Likes Power Case Summary Dr. Chen is a prominent researcher and professor in medicine and pharmacy. As an administrator, she […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 13: Overcoming Obstacles Learning Objectives 1. Explain the importance of leaders helping followers to overcome obstacles 2. Share the solutions for seven common obstacles that affect teams […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 13: Overcoming Obstacles Case 13.1—Student Maid Case Summary Kristen Hadeed accidently created her own business as a college student to earn extra money. After her business exploded […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 12: Addressing Ethics in Leadership Learning Objectives 1. Define ethical leadership Chapter Outline I. Introduction A. Moral leadership is the need of the day. B. Understanding the […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 12: Addressing Ethics in Leadership Case 12.1: The Write Choice Case Summary This case study outlines the ethical decision-making process that leaders (in this case, a professor) […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 11: Managing Conflict Learning Objectives 1. Discuss the ways that conflict can be managed to produce positive change Chapter Outline I. Introduction A. Conflict is a felt […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 11: Managing Conflict Case 11.1: Office Space Case Summary A change in office space and office environment led to considerable conflict between five co-workers in a web […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 10: Listening to Out-Group Members Learning Objectives 1. Describe the challenges and opportunities of working with out-groups within a team or organization Chapter Outline I. Introduction A. […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 10: Listening to Out-Group Members Case 10.1: Next Step Case Summary This case study outlines the work of a student organization called Next Step, a graduate student […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 9: Embracing Diversity and Inclusion Learning Objectives 1. Compare the complex processes of diversity and inclusion Chapter Outline I. Introduction A. Addressing diversity and inclusion is a […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 8: Establishing a Constructive Climate Learning Objectives 1. Define climate in the context of a team or organization Chapter Outline I. Constructive Climate Explained A. Climate is […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 7: Creating a Vision Learning Objectives 1. Identify the five characteristics of a vision 2. Assess the leadership skills required to translate a vision into reality Chapter […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 6: Engaging Strengths Learning Objectives 1. Assess the potential role of strengths in an individual’s development as a leader Chapter Outline I. Introduction A. Every one of […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 5: Developing Leadership Skills Learning Objectives 1. Explain the role of developing administrative skills for being an effective leader Chapter Outline I. Introduction A. Leadership skills critical […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 4: Attending to Tasks and Relationships Learning Objectives 1. Compare task and relationship-oriented styles. Chapter Outline I. Introduction A. Behaviors determining leaders’ success. B. Two dimensions of […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 3: Understanding Leadership Styles Learning Objectives 1. Analyze the implications of Douglas MacGregor’s two general theories. Chapter Outline I. Introduction A. It is important to recognize your […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 2: Recognizing Your Traits Learning Objectives 1. Explain the six key traits for successful leaders. Chapter Outline I. Introduction A. Important leadership traits include diligence, trustworthiness, dependability, […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Lecture Notes Chapter 1: Understanding Leadership Learning Objectives 1. Summarize the seven concepts that are essential to leadership. Chapter Outline I. Introduction A. Leadership is a mutual influence process, involving […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 9: Embracing Diversity and Inclusion Case 9.1: What’s in a Name? Case Summary Springfield High School, a high school in a small town in the rural Midwest, […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 8: Establishing a Constructive Climate Case 8.1: A Tale of Two Classes Case Summary This case study highlights two different approaches to a college communication class, noting […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 7: Creating a Vision Case 7.1: A Clean Slate Case Summary As a newspaper editor responsible for delivering printed content to a Midwestern town, Nick Gibbons was […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Case 6.1: Ready to Be CEO? Case Summary Christine Jorgens’s experience, dedication, and passion for her organization – Begin the Future Foundation – had led her in an […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 5: Developing Leadership Skills Case 5.1— Give Me Shelter Case Summary This case study explores the experiences of Theodore Henderson, an operations director for The Ross Center, […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 4: Attending to Tasks and Relationships Case 4.1— From Two to One Case Summary In this brief case, Mark Schmidt is tasked with a common, yet complicated […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 3: Understanding Leadership Styles Case 3.1—Several Different Styles Case Summary Vanessa Mills is a personal banker at Lakeshore Bank and reports to three different managers at her […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 2: Recognizing Your Traits Case 2.1—NorthTown Doulas Case Summary This case study discusses the experiences of Kamiah N., a woman from North Town, an impoverished African-American community, […]

Instructor Resource Northouse, Introduction to Leadership, 5e SAGE Publishing, 2021 Case Notes Chapter 1: Understanding Leadership Case 1.1—King of the Hill Case Summary This brief case study explains the culture for leadership created by high school swimming coach Denny Hill. […]

Expected exchange rate (Lp/$) 14.8000 14.8000 14.8000 14.8000 Carambola’s expected FCF in US$ 878,378$ 948,649$ 11,269,946$ Present value factor 1.0000 0.8333 0.6944 0.5787 Present value of expected FCF in US$ 731,982$ 658,784$ 6,521,959$ Cumulative present value in US$ 7,912,725$ Expected […]