A First Course in Database Systems
Pearson Education (US) (Publisher)
Published on 1. January 1997
Book
Hardback
250 pages
978-0-13-861337-2 (ISBN)
Article exhausted; check for reprint
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.
More details
Language
English
Place of publication
Upper Saddle River
United States
Target group
College/higher education
Illustrations
illustrations
Dimensions
Height: 235 mm
Width: 178 mm
Weight
885 gr
ISBN-13
978-0-13-861337-2 (9780138613372)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions

Book
11/2001
2nd Edition
Pearson
€65.60
Article exhausted; check for reprint
Content
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.