tailieunhanh - Database System Concepts

• Repetition of information is a condition in a relational database where the values of one attribute are determined by the values of another attribute in the same relation, and both values are repeated throughout the relation. This is a bad relational database design because it increases the storage re- quired for the relation and it makes updating the relation more difficult. • Inability to represent information is a condition where a relationship exists among only a proper subset of the attributes in a relation. This is bad re- lational database design because all the unrelated attributes must be filled with null values otherwise a tuple without the. | INSTRUCTOR S MANUAL TO ACCOMPANY ALPHA incomplete VERSION DATED August 28 2001 Database System Concepts Fourth Edition Abraham Silberschatz Bell Laboratories Henry F. Korth Bell Laboratories S. Sudarshan Indian Institute of Technology Bombay Copyright 2001 A. Silberschatz H. Korth and S. Sudarshan Contents Preface 1 Chapter 1 Introduction Exercises 4 Chapter 2 Entity Relationship Model Exercises 9 Chapter 3 Relational Model Exercises 30 Chapter 4 SQL Exercises 42 Chapter 5 Other Relational Languages Exercises 58 Chapter 6 Integrity and Security Exercises 74 iii iv Contents Chapter 7 Relational-Database Design Exercises 84 Chapter 8 Object-Oriented Databases Exercises 98 Chapter 9 Object-Relational Databases Exercises 109 Chapter 10 XML Exercises 119 Chapter 11 Storage and File Structure Exercises 129 Chapter 12 Indexing and Hashing Exercises 141 Chapter 13 Query Processing Exercises 155 Chapter 14 Query Optimization Exercises 166 Chapter 15 Transactions Exercises 175 Chapter 16 Concurrency Control Exercises 182 Chapter 17 Recovery System Exercises .