Korth Solutions

Only available on StudyMode
  • Download(s) : 129
  • Published : September 7, 2012
Open Document
Text Preview
INSTRUCTOR’S MANUAL TO ACCOMPANY

Database System Concepts
Fourth Edition

Abraham Silberschatz
Yale University
Henry F. Korth
Lehigh University
S. Sudarshan
Indian Institute of Technology, Bombay

Copyright c 2001 A. Silberschatz, H. Korth, and S. Sudarshan

Contents

Preface 1
Chapter 1
Exercises

Chapter 2
Exercises

Chapter 3
Exercises

Chapter 4
Exercises

Chapter 5
Exercises

Chapter 6
Exercises

Introduction
4

Entity Relationship Model
9

Relational Model
30

SQL
42

Other Relational Languages
58

Integrity and Security
74

iii

iv

Contents

Chapter 7
Exercises

Chapter 8
Exercises

Chapter 9
Exercises

Chapter 10
Exercises

Chapter 11
Exercises

Chapter 12
Exercises

Chapter 13
Exercises

Chapter 14
Exercises

Chapter 15
Exercises

Chapter 16
Exercises

Chapter 17
Exercises

Relational-Database Design
84

Object-Oriented Databases
98

Object-Relational Databases
109

XML
119

Storage and File Structure
129

Indexing and Hashing
141

Query Processing
155

Query Optimization
166

Transactions
175

Concurrency Control
182

Recovery System
196

Contents

Chapter 18
Exercises

Chapter 19
Exercises

Chapter 20
Exercises

Chapter 21
Exercises

Chapter 22
Exercises

Chapter 23
Exercises

Chapter 24
Exercises

Database System Architectures
203

Distributed Databases
210

Parallel Databases
219

Application Development and Administration
227

Advanced Querying and Information Retrieval
234

Advanced Data Types and New Applications
243

Advanced Transaction Processing
251

v

Preface

This volume is an instructor’s manual for the 4th 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 to skip if time is at a premium, and tips on software and supplementary material that can be used for programming exercises. Beginning with this edition, solutions for some problems have been made available on the Web. These problems have been marked with a “ * ” in the instructor’s manual.

The Web home page of the book, at http://www.db-book.com, contains a variety of useful information, including up-to-date errata, online appendices describing the network data model, the hierarchical data model, and advanced relational database design, and model course syllabi. We will periodically update the page with supplementary material that may be of use to teachers and students. We provide a mailing list through which users can communicate among themselves and with us. If you wish to use this facility, please visit the following URL and follow the instructions there to subscribe:

http://mailman.cs.yale.edu/mailman/listinfo/db-book-list
The mailman mailing list system provides many benefits, such as an archive of postings, and several subscription options, including digest and Web only. To send messages to the list, send e-mail to: db-book-list@cs.yale.edu

We would appreciate it if you would notify us of any errors or omissions in the book, as well as in the instructor’s manual. Internet electronic mail should be ad1

2

Preface

dressed to db-book@cs.yale.edu. Physical mail may be sent to Avi Silberschatz, Yale University, 51 Prospect Street, New Haven, CT, 06520, USA.
Although we have tried to produce an instructor’s manual which will aid all of the users of our book as much as possible, there can always be improvements. These could include improved answers, additional questions, sample test questions, programming projects,...
tracking img