In today’s increasingly decentralized and insecure business arena, effective database management has taken on a whole new urgency. Database Management Systems, Third Edition, introduces and explains core concepts of database design, development, and administration. Special sections demonstrate how to first evaluate security threats and then design vital security components and integrate them into each application. Applied exercises and cases bring facts and data into the real world.
New Features
Software Neutral Textbook-the main textbook presents the core concepts of database design, development and administration without distracting students by software-specific references; as well as offers the instructor the choice of what software shall be covered.
Database design explained in terms of business modeling-Students will learn database design through a business perspective. At the end of the course, students will be prepared to analyze a business problem and create a database solution. Thus providing a ‘hands-on’ business experience.
Access Workbook-This workbook matches the organization of the core principles text. Allows for increased breadth and depth designing and developing MS Access databases. Offers students the experience of applying the database concepts within the Access environment through an abundance of examples and exercises with an integrated case.
Oracle Workbook - this workbook matches the organization of the core principles text. Allows for increased breadth and depth designing and developing Oracle databases. Offers students the experience of applying the database concepts within the Oracle environment through an abundance of examples and exercises using an integrated case.
UML Coverage – UML has standardized coverage; allowing students to learn only one set of notations in comparison to ER techniques. Furthermore, it is easier to read then other techniques. Lastly, UML is being widely accepted as the standard by many of the systems design organizations. Therefore, students will be better prepared when entering the workforce.
On-line database design system - a Java-based Web application in which students will draw the design diagrams and save them on the central sever. With a click of the mouse, the server evaluates the diagram and provides immediate feedback on the design. Another method to ensure application of the concepts.
Expanded Discussion of Data Warehouses and Data Mining - Allows for more thorough treatment of how businesses can mine date to identify trends and patterns and make strategic decisions. The text shows how data warehouse design differs from traditional databases. It also explores the analytical techniques increasingly used by managers to make decisions and solve complex problems.
Applied Business Exercises and Cases – the new exercises and cases are business-based allowing students to learn database management systems from this perspective.
In-depth Coverage of Database Security - With the increased national and international emphasis on security, it is critical that students learn to design and integrate security into their applications. All database managers and developers need to know how to protect data in databases from security and privacy threats. The in-depth coverage shows students how to evaluate the security threats and protect their database applications.
Appendix of Data Normalization Definitions: Based on reviewer requests, we have added an appendix with these definitions following chapter 3.
Table of Contents
1. Introduction
Systems Design
2. Database Design
3. Data Normalization
Queries
4. Data Queries
5. Advanced Queries and Subqueries
Applications
6. Forms, Reports & Applications
7. Data Integrity & Transactions
8. Data Warehouses & Data Mining
Database Administration
9. Data Administration
10. Distributed Databases & the Internet 
