[Book Cover]

First Course in Database Systems, A, 1/e

Jeffrey D. Ullman, Stanford University
Jennifer Widom, Stanford University

Published April, 1997 by Prentice Hall Engineering/Science/Mathematics

Copyright 1997, 470 pp.
Cloth
ISBN 0-13-861337-0
$60.00


Sign up for future
mailings on this subject.

See other books about:
    Systems


Author Home Page





This concise introduction to Database Systems offers an accessible, user-oriented approach.

Covers the latest database standards—OQL, ODL, SQL2, and SQL3—with detailed explanations of how to use ODL and E/R to design databases. The book also features excellent coverage of SQL with more depth than most other texts.



The aim of this book is to focus on database design, use, and implementation of database applications.

  • Comprehensive coverage of all aspects of SQL programming.
  • The ER model and OO standard ODL are covered and contrasted as tools for the design of database systems.
  • Explains object-oriented and object-relational database programming with coverage of the OO standard OQL and object-oriented features of SQL3.




    1. The Worlds of Database Systems.

      The Evolution of Database Systems. The Architecture of a DBMS. The Future of Database Systems. Outline of the Book. Summary of Chapter 1.

    2. Database Modeling.

      Introduction to ODL. Entity-Relationship Diagrams. Design Principles. Subclasses. The Modeling of Constraints. Weak Entity Sets. Models of Historical Interest.

    3. The Relational Data Model.

      Basics of the Relational Model. From ODL Designs to Relational Designs. From E/R Diagrams to Relational Designs. Converting Subclass Structures to Relations. Functional Dependencies. Rules About Functional Dependencies. Design of Relational Database Schemas. Multivalued Dependencies. An Example Database Schema.

    4. Operations in the Relational Model.

      An Algebra of Relational Operations. A Logic for Relations. From Relational Algebra to Datalog. Recursive Computations. Constraints on Relations. Relational Operations on Bags. Other Extensions of the Relational Model.

    5. The Database Language SQL.

      Simple Queries in SQL. Queries Involving More than One Relation. Subqueries. Duplicates. Aggregation. Database Modifications. Defining a Relation Schema in SQL. View Definitions. Null Values and Outerjoins. Recursions in SQL3.

    6. Constraints and Triggers in SQL.

      Keys in SQL. Referential Integrity and Foreign Keys. Constraints on the Values of Attributes. Global Constraints. Modification of Constraints. Triggers in SQL3.

    7. System Aspects of SQL.

      SQL in a Programming Environment. Transactions in SQL. The SQL Environment. Security and User Authorization in SQL2.

    8. Object-Oriented Query Languages.

      Query-Related Features of ODL. Introduction to OQL. Additional Forms of OQL Expressions. Object Assignment and Creation of OQL. Tuple Objects in SQL3. Value-ADT's. Comparison of ODL/OQL and SQL3 Approaches.

[Help] [Home]

© Prentice-Hall, Inc. A Pearson Education Company
Comments To webmaster@prenhall.com