Name: A First Course in Database Systems By Jeffrey D. Ullman
SKU: 9780138613372
Price: 4.49 USD
Availability: InStock

A First Course in Database Systems Summary

A First Course in Database Systems by Jeffrey D. Ullman

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.

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.

Additional information

Sku

CIN0138613370G

ISBN 13

9780138613372

ISBN 10

0138613370

Title

A First Course in Database Systems by Jeffrey D. Ullman

Author

Jeffrey D. Ullman

Condition

Used - Good

Binding type

Hardback

Publisher

Pearson Education (US)

Year published

19970101

Number of pages

250

Prizes

N/A

Cover note

Book picture is for illustrative purposes only, actual binding, cover or edition may vary.

Note

This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in good condition, but if you are not entirely satisfied please get in touch with us

A First Course in Database Systems Jeffrey D. Ullman

A First Course in Database Systems by Jeffrey D. Ullman

Summary

Faster Shipping

A First Course in Database Systems Summary

A First Course in Database Systems by Jeffrey D. Ullman

Table of Contents

Additional information

Customer Reviews - A First Course in Database Systems