Request for consultation
CONCEPTS OF DATABASE MANAGEMENT fits perfectly into any introductory database course for information systems, business or CIS programs. This concise text teaches SQL in a database-neutral environment with all major topics being covered, including E-R diagrams, normalization, and database design. Now in its seventh edition, CONCEPTS OF DATABASE MANAGEMENT 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.
- NEW! Updated to cover Access 2010.
- NEW! Appendix covering Access Web Databases, Navigation Forms, Macros, and Data Type Parts has been added.
- NEW! Appendix on Determining Information-Level Requirements has been added.
- NEW! Instructor's Manual. The Instructor's Manual includes detailed tips on integrating the Seventh Edition with other books from Course Technology that cover Microsoft Access 2010 and SQL. These books include: New Perspectives on Microsoft Access 2010 (Comprehensive, Introductory, or Brief) by Adamski and Finnegan; Microsoft Office Access 2010 (Introductory, Complete, or Comprehensive Concepts and Techniques) by Shelly, Cashman, Pratt, and Last; A Guide to SQL by Pratt and Last; and A Guide to MySQL by Pratt and Last.
- 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.
- 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.
- 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.
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.
Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.
Cengage Learning Testing, powered by Cognero Instant Access