Archives: Solution Manual

Chapter 30: Database Security Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 30: DATABASE SECURITY Answers to Selected Exercises 30.30 – 30.31: No solutions provided. 30.32 – Consider the relational database schema of Figure 3.5. Suppose that all […]

Chapter 28: Data Mining Concepts Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 28: DATA MINING CONCEPTS Answers to Selected Exercises 28.14 – Apply the Apriori algorithm to the following data set: Trans ID Items Purchased 101 milk, […]

Chapter 26: Enhanced Data Models for Advanced Applications Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 26: ENHANCED DATA MODELS FOR ADVANCED APPLICATIONS Answers to Selected Exercises 26.34 – Consider the COMPANY database described in Figure 3.6. Using […]

Chapter 22: Database Recovery Techniques Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 22: DATABASE RECOVERY TECHNIQUES Answers to Selected Exercises 22.21 – Suppose that the system crashes before the [read_item,T3,A] entry is written to the log in […]

Chapter 21: Concurrency Control Techniques Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 21: CONCURRENCY CONTROL TECHNIQUES Answers to Selected Exercises 21.20 – Prove that the basic two-phase locking protocol guarantees conflict serializability of schedules. (Hint: Show that, […]

Chapter 20: Introduction to Transaction Processing Concepts and Theory Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 20: INTRODUCTION TO TRANSACTION PROCESSING CONCEPTS and THEORY Answers to Selected Exercises 20.14 – Change transaction T 2 in Figure 21.2b […]

Chapter 19: Query Optimization CHAPTER 19: QUERY OPTIMIZATION Answers to Selected Questions 19.15 – Develop cost functions for the PROJECT, UNION, INTERSECTION, SET DIFFERENCE, and CARTESIAN PRODUCT algorithms discussed in section 19.4. Answer: Assume relations R and S are stored […]

Chapter 18: Algorithms for Query Processing and Optimization Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 18: ALGORITHMS FOR QUERY PROCESSING AND OPTIMIZATION Answers to Selected Exercises 18.13 – Consider SQL queries Q1, Q8, Q1B, Q4, Q27 in […]

Chapter 17: Indexing Structures for Files Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 17: INDEXING STRUCTURES FOR FILES Answers to Selected Exercises 17.18 – Consider a disk with block size B=512 bytes. A block pointer is P=6 […]

Chapter 16: Disk Storage, Basic File Structures, and Hashing Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 16: DISK STORAGE, BASIC FILE STRUCTURES, AND HASHING Answers to Selected Exercises 16.27 – Consider a disk with the following characteristics […]

Chapter 15: Database Design Theory: Normalization Algorithms Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 15: Database Design Theory: Normalization Algorithms Answers to Selected Exercises 15.17 – Show that the relation schemas produced by Algorithm 15.4 are in […]

Chapter 14: Database Design Theory: Introduction to Normalization Using Functional and Multivalued Dependencies Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 14: Database Design Theory: Introduction to Normalization Using Functional and Multivalued Dependencies Answers to Selected Exercises 14.19 […]

Chapter 13: XML: Extensive Markup Language CHAPTER 13: XML: EXTENSIVE MARKUP LANGUAGE Answers to Selected Exercises 13.7 <?xml version=“1.0” standalone=“yes” ?> <Departments> <Department> <Dname>Research</Dname> <Dnumber>5</Dnumber> <Mgr_ssn>333445555</Mgr_ssn> <Mgr_start_date>1988-05-22</Mgr_start_date> <Dlocation>Bellaire</Dlocation> <Dlocation>Sugarland</Dlocation> <Dlocation>Houston</Dlocation> </Department> <Department> <Dname>Administration</Dname> <Dnumber>4</Dnumber> <Mgr_ssn>987654321</Mgr_ssn> <Mgr_start_date>1995-01-01</Mgr_start_date> <Dlocation>Stafford</Dlocation> </Department> … </Departments> […]

Chapter 12: Object and Object-Relational Databases Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 12: OBJECT and OBJECT-RELATIONAL DATABASES Answers to Selected Exercises 12.25 – Convert the example of GEOMETRY_OBJECTS given in section 11.1.5 from the functional notation […]

Chapter 11: Web Database Programming Using PHP CHAPTER 11: WEB DATABASE PROGRAMMING USING PHP Answers to Selected Exercises 11.10 <?php require ‘DB.php’; $d = DB::connect(‘oci8://acct1:pass12@www.host.com/dbname’); if(DB::isError($d)){die(“cannot connect – “.$d->getMessage());} … $q=$d->query(” CREATE TABLE PUBLISHER( Name VARCHAR NOT NULL, Address VARCHAR, […]

Chapter 10: Introduction to SQL Programming Techniques CHAPTER 10: INTRODUCTION TO SQL PROGRAMMING TECHNIQUES Answers to selected Exercises 10.7 … loop=1; while(loop) { prompt(“Please enter your name: “, name); EXEC SQL DECLARE REPORT CURSOR FOR select G.Grade, C.Credit_hours from STUDENT […]

Chapter 9: Relational Database Design by ER- and EER-to-Relational Mapping Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 9: RELATIONAL DATABASE DESIGN BY ER- AND EER-TO– RELATIONAL MAPPING Answers to Selected Exercises 9.3 – Try to map the […]

Chapter 8: The Relational Algebra and Relational Calculus Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 8: THE RELATIONAL ALGEBRA AND RELATIONAL CALCULUS Answers to Selected Exercises 8.15 – Show the result of each of the sample queries […]

Chapter 7: More SQL: Complex Queries, Triggers, Views, and Schema Modification Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 7: More SQL: Complex Queries, Triggers, Views, and Schema Modification Answers to Selected Exercises 7.5 – Specify the following […]

Chapter 6: Basic SQL Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 6: Basic SQL Answers to Selected Exercises 6.5 – Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. What are the […]

Chapter 5: The Relational Data Model and Relational Database Constraints Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 5: THE RELATIONAL DATA MODEL AND RELATIONAL DATABASE CONSTRAINTS Answers to Selected Exercises 5.11 – Suppose each of the following […]

Chapter 4: The Enhanced Entity-Relationship (EER) Model Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 4: THE ENHANCED ENTITY-RELATIONSHIP (EER) MODEL Answers to Selected Exercises 4.16 – No solution provided. 4.17 – Consider the BANK ER schema of […]

Chapter 3: Data Modeling Using the Entity-Relationship (ER) Model Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 3: DATA MODELING USING THE ENTITY-RELATIONSHIP (ER) MODEL Answers to Selected Exercises 3.16 – Consider the following set of requirements for […]

Chapter 2: Database System Concepts and Architecture Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 2: DATABASE SYSTEM CONCEPTS AND ARCHITECTURE Answers to Selected Exercises 2.12 – Think of different users for the database of Figure 1.2. What […]

Chapter 1: Databases and Database Users Copyright © 2016 Pearson Education, Inc., Hoboken NJ 1 CHAPTER 1: DATABASES AND DATABASE USERS Answers to Selected Exercises 1.8 – Identify some informal queries and update operations that you would expect to apply […]

Chapter 1: Overview of Autism Spectrum Disorders Chapter Summary Autism Spectrum Disorder (ASD) is one of the fastest growing of all childhood disorders, with a prevalence rate of one in every 68 individuals in the United States. There are three […]

Angel and Shreiner: Interactive Computer Graphics, Seventh Edition Chapter 12 Solutions 12.1 Let’s do the problem in two dimensions. The solution in three dimensions is essentially the same. Assume that the vertices are used in a consistent clockwise or counterclockwise […]

Angel and Shreiner: Interactive Computer Graphics, Seventh Edition Chapter 11 Solutions 11.1 (m+ 1)3 11.2 The function y=f(x) describes the same curve in any plane of constant z, or equivalently, a curve in the y, z plane that is extruded […]

Angel and Shreiner: Interactive Computer Graphics, Seventh Edition Chapter 10 Solutions 10.1 There are a number of possibilities. One is to use the turtle representation where the angle is 60 degrees and the distance forward is half the size of […]

Angel ad Shreiner: Interactive Computer Graphics; Seventh Edition Chapter 9 Solutions 9.1 If the upper arm is longer than the lower arm then, as a first approximation, the robot can reach all points within a sphere centered at the joint […]

Angel and Shreiner: Interactive Computer Graphics, Seventh Edition Chapter 8 Solutions 8.1 First, consider the problem in two dimensions. We are looking for an α and βsuch that both parametric equations yield the same point, that is x(α) = (1 […]

Angel and Shreiner: Interactive Computer Graphics, Seventh Edition Chapter 7 Solutions 7.1 The major problem is that the environment map is computed without the object in the scene. Thus, all global lighting calculations of which it should be a part […]

Angel and Shreiner: Interactive Computer Graphics, Seventh Edition Chapter 6 Solutions 6.1 Point sources produce a very harsh lighting. Such images are characterized by abrupt transitions between light and dark. The ambient light in a real scene is dependent on […]

Angel and Shreiner: Interactive Computer Graphics, Seventh Edition Chapter 5 Solutions 5.1 Eclipses (both solar and lunar) are good examples of the projection of an object (the moon or the earth) onto a nonplanar surface. Any time a shadow is […]

Angel and Shreiner: Interactive Computer Graphics, Seventh Edition Chapter 4 Solutions 4.1 If the scaling matrix is uniform then RS =RS(α, α, α) = αR=SR Consider Rx(θ), if we multiply and use the standard trigonometric 4.4 Translation T=   […]

Angel: Interactive Computer Graphics, Seventh Edition Chapter 3 Solutions 3.7 There are a couple of potential problems. One is that the application program can map different points in object coordinates to the same point 3.8 In picking we have the […]

Angel and Shreiner: Interactive Computer Graphics, Seventh Edition Chapter 2 Solutions 2.2 Each iteration removes the central triangle of the four created by subdivision. If we start with an equilateral triangle, the area is reduced by 3/4 by each iteration. […]

Angel and Shreiner: Interactive Computer Graphics, Seventh Edition Chapter 1 Solutions 1.1 The main advantage of the pipeline is that each primitive can be processed independently. Not only does this architecture lead to fast performance, it reduces memory requirements because […]