'DATABASE MANAGEMENT CONCEPTS, 7E, prepares students for success in their field using real-world cases addressing current issues such as database design, data integrity, concurrent updates, and data security. Special features include detailed coverage of the relational model (including QBE and SQL), normalization and views, database design, database administration and management, and more. Advanced topics covered include distributed databases, data warehouses, stored procedures, triggers, data macros, and Web databases.
' Extensively covers SQL with numerous examples illustrating the various concepts. Advanced topics such as concurrency issues, distributed databases, data warehouses, stored procedures, triggers, XML, and database processing over the Web are included. Comprehensively discusses database design that includes normalization, an easily applied database design method, E-R diagrams, numerous database design examples, requirements gathering and analysis, and trade-off discussions. A case problem in each chapter challenges students and reinforces concepts. Appendices describe the purpose and syntax of the major SQL commands used in the book. Supplements include an integrated syllabus for using the book with leading Microsoft Access 2007 books such as Shelly & Cashman and New Perspectives.
'1. Introduction to Database Management. 2. The Relational Model 1: Introduction, QBE, and Relational Algebra. 3. The Relational Model 2: SQL. 4. The Relational Model 3: Advanced Topics. 5. Database Design 1: Normalization. 6. Database Design 2: Design Method. 7. DBMS Functions. 8. Database Administration. 9. Database Management Approaches. Appendix A: Comprehensive Design Example: Marvel College. Appendix B: SQL Reference. Appendix C: "How Do I" Reference. Appendix D: Answers to Odd-Numbered Review Questions. Appendix E: Using Access to Create and Publish a Web Database. Appendix F: Determining Information-Level Requirements.
'Joseph J. Adamski Joseph J. Adamski spent 12 years as a computer professional at aerospace and financial services companies and is an Associate Professor Emeritus at Grand Valley State University. He has worked as a computer professional and educator for over 40 years with a special interest in database management and personal uses of databases. Philip J. Pratt Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis, and discrete mathematics. He has authored over 60 textbooks, including coauthoring three levels of Microsoft Office Access 2007 books for the Shelly Cashman Series.
