Page Tools:

Databases Illuminated, Second Edition

Author(s): Catherine M. Ricardo, PhD, Iona College
Details:
  • ISBN-13: 9781449606008
  • ISBN-10:1449606008
  • Hardcover    668 pages      © 2012
Price: International Sales $153.95 US List
Add to Cart Request a Review Copy

Overview

Databases Illuminated, Second Edition integrates database theory with a practical approach to database design and implementation. The text is specifically designed for the modern database student, who will be expected to know both theory and applied design and implementation as professionals in the field. This Second Edition has been revised and updated to incorporate information about the new releases of Access 2010, Oracle 11g and Intersystems Cache. It includes material on the most recent topics such as, Web access, JDBC, web programming, XML, data mining, and other emerging database technologies and applications.

Now Available for Download - look to the Resources tab below.
Instructor resources include Microsoft PowerPoint lecture slides, solutions to all the exercises and projects in the text, test bank, and a complete instructor's manual that includes classroom objectives and teaching hints.
Student resources include an open access companion website featuring:

  • downloadable code
  • projects with step-by-step guidance that ensure students fully understand each step before moving on to the next.
  • hands-on lab exercises that allow students to apply the concepts learned from the text
  • additional information not included in the text to allow for further study.

The integrated, modern approach to databases, combined with strong pedagogical features, accessible writing, and a full package of student and instructor’s resources, makes Databases Illuminated, Second Edition the perfect textbook for courses in this exciting field.

New and Key Features of the updated Second Edition:

  • Covers the new features of the current versions of popular database management systems, including Oracle 11, Access 2010, and InterSystems Cache.
  • Incorporates the new curriculum recommendations in ACM Computer Science Curriculum 2008 and ACM/AIS IS2010 Curriculum Guidelines for IS2010.2, Data and Information Management, including more attention to security, concurrency, and net-centric computing. The chapter on computer ethics has been updated to take into account new regulations and practices.
  • Contains more material on recent and relevant topics, such as Web access, JDBC, web programming, XML, data warehousing, data mining, and other emerging database technologies and applications.
  •  Includes the extensive object-relational features of the current release of Oracle, with downloadable code for students to implement.
  • Object-oriented databases are implemented using InterSystems Cache, with downloadable code included on the website.

ShowKey Features

  • Balanced coverage of theory and application - this book contains thorough coverage of theory and applied database design and implementation throughout. For example, relational algebra and SQL are both presented, and normalization is discussed both by formal definition and by examples. Theory provides the deep understanding that survives changes in technology, while practice provides the skills students need for employment and further exploration.
  • Conforms to the ACM-IEEE and AIS curriculum recommendations - Includes an entire chapter devoted to ethics. In addition to the core topics, the book covers database security, concurrency control, recovery, query optimization, distributed databases, internet-based systems, XML, data warehouses, and data mining.
  • Each chapter begins with learning objectives and ends with a chapter summary that emphasizes the key points. Exercises follow each chapter, and hands-on lab exercises will be provided on the companion website whenever appropriate.
  • Code for real-life database management systems including Access, Oracle, and InterSystems Cache provide practice with relational, object-relational, and object-oriented systems. Code appears in the text and will be on the website, so students can download and run it immediately.
  • The sample project and student projects provide continuing examples that students can build on as they progress.
  • Includes discussion on data mining techniques and provides accessible examples

Back to top

ShowTable of Contents

Chapter  1  Introductory Database Concepts
Chapter  2  Database Planning and Database Architecture
Chapter  3  The Entity-Relationship Model
Chapter  4  The Relational Model
Chapter  5  Relational Database Management Systems and SQL
Chapter  6  Normalization
Chapter  7  The Object-Oriented Model
Chapter  8  The Enhanced-Entity Relationship Model and the Object Relational Model
Chapter  9  Introduction to Database Security
Chapter  10  Transaction Management
Chapter  11  Relational Query Optimization
Chapter  12  Distributed Databases
Chapter  13  Databases and the Internet
Chapter  14  Social and Ethical Issues
Chapter  15  Data Warehouses and Data Mining
Back to top

ShowAbout the Author(s)

Catherine M. Ricardo, PhD-Iona College

Catherine Ricardo received a Ph.D. from Columbia University in 1983. She has been on the Computer Science faculty at Iona College since 1979. She has taught a variety of courses including computer literacy, introductory programming in several languages, data structures, discrete mathematics, educational computing, modeling, and artificial intelligence, but she has concentrated on courses in database systems, which she has taught at both the undergraduate and graduate level for over 25 years. Besides writing textbooks on databases, she has written numerous articles and made presentations at many conferences in the field.

 

Back to top

ShowReviews

  • Ricardo has written an excellent book on the design and maintenance of modern electronic databases. Starting with an interesting history of databases, the book quickly moves to a discussion of database planning and architecture by devoting chapters to various models (e.g., entity-relationship, relational, object-oriented, enhanced-entity relationship, and object-relational). Next, the author thoroughly covers SQL and examines several levels of normalization. The book also discusses database security, including authorization, authentication, and data redundancy; transaction management and concurrency; and relational query optimization, including a close look at the Boolean logic that underpins SQL searches. Later chapters address distributed processing and multitiered architectures necessary for Internet transactions. The book finishes with an in-depth look at social and ethical concerns and the vast amount of electronic data found in data warehouses. This new edition contains the latest versions of various database management systems, and expanded coverage of recent topics in the field. Instructor resources include PowerPoint presentations for each chapter, solutions for student projects, and comprehensive chapter exams. A companion website allows students to build a database as they progress through the book. Online appendices are available.

    -M. Connell, SUNY College at Cortland

Back to top

ShowResources

    • show overviewClick here to request access to these instructor resources.

      The following instructor resources are available to qualified instructors for download

      ISBN-13: 9781449606008

      Additional Resources for Instructors
      Angel ready Test Bank
      BlackBoard ready Test Bank
      Desire to Learn ready Test Bank
      Image Bank
      Instructor Manual
      Instructor's Solutions Manual
      Moodle ready Test Bank
      Powerpoint™
      Project Answers
      Solutions Manual
      Test Bank
Back to top