A first course in database systems
Author(s)
Bibliographic Information
A first course in database systems
（An Alan R. Apt book）
Prentice Hall, c1997
Available at 24 libraries
Note
Includes bibliographical references and index
Description and Table of Contents
Description
Giving comprehensive coverage of all aspects of SQL programming, this student-friendly text adopts a user-oriented approach. It covers the design of databases using both the E/R model and the OO standard ODL, and explains object-oriented and object-relational database programming. It also covers the OO standard OQL and object-oriented features of SQL3, and advanced database programming, including integrity constraints, assertions, triggers and recursion in SQL3.
Table of Contents
- The worlds of database systems: the evolution of database systems
- the architecture of a DBMS
- the future of database systems
- outline of the book. Database modelling: introduction of ODL
- entity-relationship diagrams
- design principles
- subclasses
- the modelling of constraints
- weak entity sets
- models of historical interest. The relationship data model: basic 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 rational database schemas
- multivalued dependencies
- an example database schema. 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. The database language SQL: simple queries in SQL
- queries involving more than on e relation
- subqueries
- supplicates
- aggregation database modifications
- defining a relation schema in SQL
- view definitions
- Null values and outerjoints
- recursion in SQL3. Active elements in SQL: declaring keys in SQL
- referential integrity and foreign keys
- value constraints
- global constraints
- modification of constraints
- event-condition-action rules in SQL3. System aspects of SQL: SQL in a programming environment
- transactions in SQL
- the SQL environment
- security and user authorization in SQL2. Object oriented query languages: query-related features of ODL
- introduction to OQL
- additional forms of OQL
- expressions
- object assignment and creation in OQL
- tuple objects in SQL3
- value-ADT's
- comparison of ODL/PQL and SQL3
- approaches.
by "Nielsen BookData"