Archives

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 […]