First Course in Database Systems, A, 3rd Edition

About

Features

• Large variety of real-world examples ensure the presentation is readable and engaging.
• Extensive treatment of database modeling teaches about this important first step of the planning process.
• Coverage of advanced issues important to database designers and users includes discussions of views, integrity constraints, assertions, triggers, transactions, authorization, and recursion in SQL: 1999.
• Discussion of how to successfully plan a database application before building it reflects how these plans are developed in the real world.
• Extensive exercises in almost every section provide students with the opportunity to practice and apply the concepts they've learned in each chapter.
• GOAL--please note that GOAL is no longer available.

Description

Written by well-known computer scientists, this accessible and succinct introduction to database systems focuses on database design and use. It provides in-depth coverage of databases from the point of view of the database designer, user, and application programmer. KEY TOPICS: The authors provide an overview of important programming systems (e.g., SQL, JDBC, PSM, CLI, PHP, XQuery, etc.) and the intellectual framework to put them into context.  MARKET: For software engineers, database engineers, and programmers.

Sample Content

Table of Contents

 1. The Worlds of Database Systems.

 2. Introduction to the Relational Model.

 3. Relational Database Schema Design.

 4. Higher-Level Models for Relational Design.

PART II: RELATIONAL DATABASE PROGRAMMING.

 5. Algebraic and Logical Query Languages.

 6. The Database Language SQL.

 7. SQL Constraints and Triggers.

 8. SQL Indexes and Views.

 9. SQL in a Service Environment.

10. Advanced Topics in SQL.

Web Appendix A. More About Datalog.

PART III: MODELING AND PROGRAMMING IN SEMISTRUCTURED-DATA MODELS.

11. Semistructured Data Models.

12. Query Languages for Semistructured Data.

Updates

Submit Errata