We provide solutions to the Practice Exercises of the Sixth Edition of Database System Concepts , by Silberschatz, Korth and Sudarshan. These practice exercises are different from the exercises provided in the text. (Solutions to the exercises in the text are available only to instructors.) Students are encouraged to solve the practice exercises on their own, and later use the solutions to check their own solutions.
The material below are copyright by Silberschatz, Korth and Sudarshan 2010. Use of the material is authorized for personal use, and for use in conjunction with a course for which Database System Concepts is the prescribed text. Any use that differs from the above, and any for profit sale of the manual (in any form) requires the consent of the copyright owners; contact Avi Silberschatz (avi@cs.yale.edu) to obtain the copyright owners consent.
Chapter | Exercises | |
|
1. Introduction | | |
|
Part 1: Relational Databases | |||
2. Relational Model | | |
|
3. SQL | | |
|
4. Intermediate SQL | | |
|
5. Advanced SQL | | |
|
6. Other Relational Languages | | |
|
Part 2: Database Design | |||
7. Database Design and the E-R Model | | |
|
8. Relational-Database Design | | |
|
9. Application Design and Development | | |
|
Part 3: Data Storage and Querying | |||
10. Storage and File Structure | | |
|
11. Indexing and Hashing | | |
|
12. Query Processing | | |
|
13. Query Optimization | | |
|
Part 4: Transaction Management | |||
14. Transactions | | |
|
15. Concurrency Control | | |
|
16. Recovery System | | |
|
Part 5: Database System Architecture | |||
17. Database System Architectures | | |
|
18. Parallel Databases | | |
|
19. Distributed Databases | | |
|
Part 6: Data Warehousing, Mining, and IR | |||
20. Data Analysis and Mining | | |
|
21. Information Retrieval | | |
|
Part 7: Specialty Databases | |||
22. Object-based Databases | | |
|
23. XML | | |
|
Part 8: Advanced Topics | |||
24. Advanced Application Development | | |
|
25. Advanced Data Types and New Applications | | |
|
26. Advanced Transaction Processing | | |