Synopses & Reviews
Examines the fundamentals of relational concepts and then demonstrates the applications of these concepts. Provides numerous practical examples using Structured Query Language (SQL), the popular database language for the PC. Users learn how to evaluate, design and implement relational databases and applications by examining relational concepts, their structural, integrity and manipulation features as well as types of tables and relational fidelity. By studying SQL basics, evaluation and misconceptions, users learn how SQL succeeds—and fails—as a realization of the relational model. Other topics include client/server issues, distributed databases and the emergence of object-oriented database management systems.
Description
Includes bibliographical references (p. 269-270) and index.
Table of Contents
DATABAS(E)ICS.
The Database Concept.
Database Management.
RELATIONAL DATABASES.
Data Structure.
Data Integrity.
Data Manipulation.
Missing Data.
Derived Tables.
RELATIONAL DBMS.
Relational Fidelity.
RDBMS AND SQL.
Understanding SQL.
SQL-92—Relational Features.
SQL-92—Relational Fidelity.
RDBMSs AND COMPLEX INFORMATION.
Managing Complex Information.
RDBMS AND DISTRIBUTION.
Understanding Distribution.
Bibliography.
Index.