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
  Aomori
  Iwate
  Miyagi
  Akita
  Yamagata
  Fukushima
  Ibaraki
  Tochigi
  Gunma
  Saitama
  Chiba
  Tokyo
  Kanagawa
  Niigata
  Toyama
  Ishikawa
  Fukui
  Yamanashi
  Nagano
  Gifu
  Shizuoka
  Aichi
  Mie
  Shiga
  Kyoto
  Osaka
  Hyogo
  Nara
  Wakayama
  Tottori
  Shimane
  Okayama
  Hiroshima
  Yamaguchi
  Tokushima
  Kagawa
  Ehime
  Kochi
  Fukuoka
  Saga
  Nagasaki
  Kumamoto
  Oita
  Miyazaki
  Kagoshima
  Okinawa
  Korea
  China
  Thailand
  United Kingdom
  Germany
  Switzerland
  France
  Belgium
  Netherlands
  Sweden
  Norway
  United States of America
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"