Database System Concepts
Henry F. Korth
Indian Institute of Technology, Bombay
Copyright c 2001 A. Silberschatz, H. Korth, and S. Sudarshan
Entity Relationship Model
Other Relational Languages
Integrity and Security
Storage and File Structure
Indexing and Hashing
Database System Architectures
Application Development and Administration
Advanced Querying and Information Retrieval
Advanced Data Types and New Applications
Advanced Transaction Processing
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:
The mailman mailing list system provides many beneﬁts, 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: email@example.com
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
dressed to firstname.lastname@example.org. 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,...