Computer Science

For use as a dynamic supplementary text in introductory Database Systems courses in Computer Science programs. This book can be used to supplement any main text for the introductory database systems course.

This invaluable learning tool provides an understanding of the industry-standard query language SQL. Using an appropriate mix of underlying mathematical formalism and hands-on activities with numerous examples, the text is designed to help students grasp the essential concepts of relational database query languages.

• Extensive examples.

  • Provide students with hands-on applications and practice of concepts. Ex.___

• Case studies.

  • Enable students to examine realistic examples from requirements description, to conceptual design and implementation. Shows students side-by-side comparison of the four query languages. Ex.___

• Win RDBI software—Available on the author's website. Allows students to interactively experiment with Relational Algebra, Domain Relational Calculus, Tuple Relational Calculus, and Structured Query Language expressions.

  • Provides students with an “under the hood” look at how databases function, giving them insights about how to build better databases. Ex.___

• Relational algebra covered—Fundamental relational algebra operators are defined using a combination of set theory and diagrams; additional operators defined in terms of the fundamental operators.

  • Teaches students about this procedural query language. Ex.___

• Relational calculus—Covers both the domain (DRC) and tuple (TRC) relational calculus languages. Truth tables help to illustrate the correct declarative specification of the division operator.

  • Teaches students about these declarative query languages. Ex.___

• Emphasis on SQL.

  • Introduces students to industry standard query language in terms of its mathematical functions and the formal query languages on which SQL is based. Ex.___

• Discussion of the query languages—Provided by the popular, PC-based database product Microsoft® Access™.

  • Enables students to relate theory to practice. Ex.___

 1. The Relational Data Model.


 2. Relational Algebra.


 3. Domain Relational Calculus.


 4. Tuple Relational Calculus.


 5. SQL.


 6. Case Studies.


 7. Microsoft Access.


Appendix: WinRDBI

Database Management  [SUPPLEMENTAL/VALUE PACK ITEMS]   (MIS)
SQL--Programming  (Computer Science)

This text functions as a dynamic supplementary text in Introductory Database Systems courses as well as a stand-alone reference for professionals. This invaluable learning tool provides an understanding of the industry-standard query language SQL. Using an appropriate mix of underlying theory, concepts, and hands-on activities with numerous examples, this text is designed to help students or professionals understand how relational database query languages work.

FEATURES/BENEFITS

• Hands-on Approach
• Win RDBI software available on the author's web site allows readers to interactively experiment with Relational Algebra, Domain Relational Calculus, Tuple Relational Calculus, and Structured Query Language expressions appearing in the book.
• SQL Foundations
• Introduces readers to the industry standard query language in terms of its mathematical foundations and the formal query languages on which SQL is based.
• Case Studies
• Enable students and professionals to examine realistic examples from a requirement description to conceptual design and implementation. Provides a side-by-side comparison of the four query languages.
• Relates Theory to Practice
• Examines the query languages of the popular PC-based database product Microsoft® Access™, including Access QBE (Query By Example) and Access SQL.

Companion Website - Dietrich
Dietrich
©2001 | Prentice Hall | On-line Supplement | Instock
ISBN-10: 0130291293 | ISBN-13: 9780130291295

Companion Website - Dietrich
Dietrich
©2001 | Prentice Hall | On-line Supplement | Instock
ISBN-10: 0130291293 | ISBN-13: 9780130291295

Companion Website - Dietrich
Dietrich
©2001 | Prentice Hall | On-line Supplement | Instock
ISBN-10: 0130291293 | ISBN-13: 9780130291295

Interwrite Personal Response System
EduCue, Addison-Wesley & Benjamin Cummings
©2004 | Prentice Hall | Electronic Supplement | Instock
ISBN-10: 0321267354 | ISBN-13: 9780321267351

Companion Website - Dietrich
Dietrich
©2001 | Prentice Hall | On-line Supplement | Instock
ISBN-10: 0130291293 | ISBN-13: 9780130291295

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 contact your Pearson Higher Education representative.