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
-
No Libraries matched.
- Remove all filters.
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"