A First Course in Database Systems

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.