Description

Features

• Large variety of real-world examples ensure the presentation is readable and engaging.
• Extensive treatment of database modeling teaches about this important first step of the planning process.
• Coverage of advanced issues important to database designers and users includes discussions of views, integrity constraints, assertions, triggers, transactions, authorization, and recursion in SQL: 1999.
• Discussion of how to successfully plan a database application before building it reflects how these plans are developed in the real world.
• Extensive exercises in almost every section provide students with the opportunity to practice and apply the concepts they've learned in each chapter.
• GOAL--please note that GOAL is no longer available.

¿

New To This Edition

• More emphasis on the variety of large-data systems (e.g., Web search) in Chapter 1.

• Simplified functional dependencies material – Introduces X, Y, ... as attribute sets early, and simplifies lossless-join decomposition via project/join from Ch. 2.

• More material on SQL indexes, including materialized views as a general kind of index.

• New advanced topics in SQL added, such as star schemas, OLAP, data cubes, recursive SQL, and authorization.

• A new Chapter 11 on Semistructured Data Models – Covers XML, DTD’s and new material on XSchema.

• A new Chapter 12 on Query Languages for Semistructured Data – Includes new material on XPath and XQuery.

Table of Contents

 1. The Worlds of Database Systems.

 2. Introduction to the Relational Model.

 3. Relational Database Schema Design.

 4. Higher-Level Models for Relational Design.

PART II: RELATIONAL DATABASE PROGRAMMING.

 5. Algebraic and Logical Query Languages.

 6. The Database Language SQL.

 7. SQL Constraints and Triggers.

 8. SQL Indexes and Views.

 9. SQL in a Service Environment.

10. Advanced Topics in SQL.

Web Appendix A. More About Datalog.

PART III: MODELING AND PROGRAMMING IN SEMISTRUCTURED-DATA MODELS.

11. Semistructured Data Models.

12. Query Languages for Semistructured Data.

Courses

Database Systems: Advanced Topics  (Computer Science)
Database Management  [CORE TEXTS]   (MIS)
Database Systems & Design  (Computer Science)

Product Tours

Companion Website for First Course in Database Systems, A, 3/E
Ullman & Widom
©2008  |  Prentice Hall  |  Website  |  Live
ISBN-10: 0137003366  |  ISBN-13: 9780137003365
This online resource is available at no cost at infolab.stanford.edu/~ullman/fcdb.html.
More Info

Downloadable Instructor Resources

Show All Downloadable Files

Hide All Downloadable Files

|

Help Downloading Files

Solutions Manual for A First Course in Database Systems, 3/E
Ullman & Widom
©2009  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0136120040  |  ISBN-13: 9780136120049
URL: www.prenhall.com/ullman

Show Downloadable Files

Hide Downloadable Files

|

More Info

Back to top

Author Website for A First Course in Database Systems, by Ullman and Widom, 3/E
Ullman
©2008  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0136006388  |  ISBN-13: 9780136006381
URL: infolab.stanford.edu/~ullman/fcdb.html
More Info

Companion Website for First Course in Database Systems, A, 3/E
Ullman & Widom
©2008  |  Prentice Hall  |  Website  |  Live
ISBN-10: 0137003366  |  ISBN-13: 9780137003365
This online resource is available at no cost at infolab.stanford.edu/~ullman/fcdb.html.
More Info

Back to top

Companion Website for First Course in Database Systems, A, 3/E
Ullman & Widom
©2008  |  Prentice Hall  |  Website  |  Live
ISBN-10: 0137003366  |  ISBN-13: 9780137003365
This online resource is available at no cost at infolab.stanford.edu/~ullman/fcdb.html.
More Info

Companion Website for First Course in Database Systems, A, 3/E
Ullman & Widom
©2008  |  Prentice Hall  |  Website  |  Live
ISBN-10: 0137003366  |  ISBN-13: 9780137003365
This online resource is available at no cost at infolab.stanford.edu/~ullman/fcdb.html.
More Info

Back to top

Give your students a choice! PearsonChoices products are designed to give your students more value and flexibility by letting them choose from a variety of text and media formats to best match their learning style and their budget.

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, see the Packages Tab.

• First Course in Database Systems, A, CourseSmart eTextbook, 3/E
  Ullman & Widom
  ©2008  |  Prentice Hall  |  Electronic Book; 592 pp  |  Available
  ISBN-10: 0136006752  |  ISBN-13: 9780136006756
  Online purchase price: $53.99Brief Description  | 

  

  CourseSmart eTextbooks are a creative digital solution that offers the freedom and convenience of online, offline, and mobile access using a single platform. With a CourseSmart eTextbook, students can:

  • search the text

  • make notes online

  • print out reading assignments that incorporate lecture notes

  • bookmark important passages for later review

  • save money. As an alternative to purchasing the print textbook, students can subscribe to the same content online for a significant discount off the suggested list price of the print text.

  For more information, or to subscribe to the CourseSmart eTextbook, visit www.coursesmart.com (for customers in U.S. and Canada) or www.coursesmart.co.uk (for customers in Europe, Middle East, and Africa).

  More Info  |  Students, buy access
  

• Pearson Custom Computer Science
  Pearson
  ©2009  |  Prentice Hall  |  On-line Supplement  |  Live
  ISBN-10: 0135075483  |  ISBN-13: 9780135075487
  This online resource is available at no cost at http://www.pearsoncustom.com/custom-library/pearson-custom-computer-science.
  Brief Description  | 

  

  Create your own customized textbook for introductory computing, Visual Basic, introduction to programming, data structures, and computer ethics using this exciting new custom publishing program.

   

  With Pearson Custom Computer Science, you can select just the chapters you need, in the sequence you want, from 27 best-selling textbooks from Pearson Education’s Prentice Hall and Addison Wesley. Using our online book-building system, you have direct control over the content and cost of your course materials. Add chapters on programming logic, Alice or Python to help introduce your students to programming. Develop your own custom text for non-majors courses with chapters on scripting languages, Alice, Python, labs, and other topics. Incorporate coverage of computer ethics topics throughout your custom book. Remove chapters you don’t cover from your favorite Java or C++ text. Or change the sequence of the presentation of objects (early or late) to suit your teaching approach.

   

  The choice is yours. Your book matches your course organization exactly, and your students pay only for the chapters you choose.
  
  Program features include:

  • You’re in full control of the cost. Custom CS texts are $8.00 + $.09/pg for black and white, $8.00 + $.14/pg for color.
  • Your custom book is sequentially paginated, with a custom index and table of contents.
  • Your cover and title page can be customized with your name, school and course information.
  • Include your own materials - up to 20% of the custom book can be your own writing or come from outside sources such as course materials, questions and syllabi. We handle all necessary permissions.
  • Free evaluation copy! Create your custom text online and request a free evaluation copy of your book in 7-10 days for black and white content, or 10-15 days for color.
  • 25-copy minimum for a new order; 10 copies for a re-order.

  Your custom book is published in 4-6 weeks (for black and white, 6-8 for color) from the time we receive your order from your bookstore. If you are including outside material, please allow 8-10 weeks.

  More Info
  

This product is a member of the following series. Click on the series name to see the full list of products in the series.

• GOAL Series

• Pearson Custom Computer Science

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.

Package ISBN-10: 0132457008 | ISBN-13: 9780132457002
©2008 | Instock (Additional assembly time required)
Suggested retail price: $134.60  Buy from myPearsonStore
Net price: $100.95  (What's this?)
This package contains:

Package ISBN-10: 013508668X | ISBN-13: 9780135086681
©2009 | Instock (Additional assembly time required)
Suggested retail price: $332.40  Buy from myPearsonStore
Net price: $249.30  (What's this?)
This package contains: