Synopses & Reviews
Revised to reflect the needs of today’s users, this 11th edition of Database Processing assures that you will learn marketable skills. By presenting SQL SELECT statements near the beginning of the book readers will know early on how to query data and obtain results—seeing firsthand some of the ways that database technology is useful in the marketplace. By utilizing free software downloads, you will be able to actively use a DBMS product by the end of the 2nd chapter. Each topic appears in the context of accomplishing practical tasks. Its spiral approach to database design (incorporating all 3 sources: from the integration of existing data, from new information, and the need to redesign an existing database) provides users with enhanced information not available in other database books on the market. Topics include: SQL, database design, implementation, processing, access standards, and business intelligence. An excellent reference and handbook for information systems professionals such as database administrators, database designers, systems analysts, web-database developers, and programmers of database applications.
Get readers straight to the point of database processing.
Database Processing reflects a new teaching method that gets readers straight to the point with its thorough and modern presentation of database processing fundamentals.
The eleventh edition includes active use of DBMS products, a new focus on database application processing, and coverage of Business Intelligence systems.
Table of Contents
PART 1: GETTING STARTED
Chapter 1: Introduction
Chapter 2: Introduction to Structured Query Language
PART 2: DATABASE DESIGN
Chapter 3: The Relational Model and Normalization
Chapter 4: Database Design Using Normalization
Chapter 5: Data Modeling with the Entity-Relationship Model
Chapter 6: Transforming Data Models into Database Designs
PART 3: DATABASE IMPLEMENTATION
Chapter 7: SQL for Database Construction and Application Processing
Chapter 8: Database Redesign
PART 4: MULTIUSER DATABASE PROCESSING
Chapter 9: Managing Multiuser Databases
Chapter 10: Managing Databases with SQL Server 2008
Online Chapter 10a: Managing Databases with Oracle Database 11g
Online Chapter 10b: Managing Databases with MySQL 5.1
PART 5: DATABASE ACCESS STANDARDS
Chapter 11: The Web Server Environment
Chapter 12: Database Processing with XML
Chapter 13: Database Processing for Business Intelligence Systems
Appendix A: Getting Started with Microsoft Access 2007
Appendix B: The IDEF1X Standard
Appendix C: UML-Style Entity-Relationship Diagrams
Appendix D: Data Structures for Database Processing
Appendix E: The Semantic Object Model