[工学]DatabaseSystemConceptsINSTRUCTOR’SMANUALTOACCOMPANY.doc

INSTRUCTOR’S MANUALTO ACCOMPANY DatabaseSystem Concepts Fifth Edition Abraham Silberschatz Yale University Henry F. Korth Lehigh University S. Sudarshan Indian Institute of Technology, Bombay Copyright_c 2005 A. Silberschatz, H. Korth, and S. Sudarshan Contents Preface 1 Chapter 1 Introduction Exercises 3 Chapter 2 RelationalModel Exercises 7 Chapter 3 SQL Exercises 11 Chapter 4 Advanced SQL Exercises 19 Chapter 5 Other Relational Languages Exercises 23 Chapter 6 Database Design and the E-R Model Exercises 33 iii iv Contents Chapter 7 Relational Database Design Exercises 41 Chapter 8 Application Design and Development Exercises 47 Chapter 9 Object-Based Databases Exercises 51 Chapter 10 XML Exercises 55 Chapter 11 Storage and File Structure Exercises 61 Chapter 12 Indexing and Hashing Exercises 65 Chapter 13 Query Processing Exercises 69 Chapter 14 Query Optimization Exercises 75 Chapter 15 Transactions Exercises 79 Chapter 16 Concurrency Control Exercises 83 Chapter 17 Recovery System Exercises 89 Contents v Chapter 18 Data Analysis and Mining Exercises 93 Chapter 19 Information Retrieval Exercises 99 Chapter 20 Database-System Architectures Exercises 101 Chapter 21 Parallel Databases Exercises 105 Chapter 22 Distributed Databases Exercises 109 Chapter 23 Advanced Application Development Exercises 115 Chapter 24 Advanced Data Types and New Applications Exercises 119 Chapter 25 Advanced Transaction Processing Exercises 123 Preface This volume is an instructor’s manual for the 5th edition of Database System Concepts by Abraham Silberschatz, Henry F. Korth and S. Sudarshan. It contains answers to the exercises at the end of each chapter of the book. Before providing answers to the exercises for each chapter, we include a few remarks about the chapter. The nature of these remarks vary. They include explanations of the inclusion or omission of certain material, and remarks on how we teach the chapter in our own courses. The remarks also include suggestions on material t