Catherine M. Ricardo - Databases Illuminated

World Headquarters
Jones & Bartlett Learning
25 Mall Road, Suite 600
Burlington, MA 01803
978-443-5000
www.jblearning.com

Jones & Bartlett Learning books and products are available through most bookstores and online booksellers. To contact Jones & Bartlett Learning directly, call 800-832-0034, fax 978-443-8000, or visit our website, www.jblearning.com.

Substantial discounts on bulk quantities of Jones & Bartlett Learning publications are available to corporations, professional associations, and other qualified organizations. For details and specific discount information, contact the special sales department at Jones & Bartlett Learning via the above contact information or send an email to .

Copyright 2023 by Jones & Bartlett Learning, LLC, an Ascend Learning Company

All rights reserved. No part of the material protected by this copyright may be reproduced or utilized in any form, electronic or mechanical, including photocopying, recording, or by any information storage and retrieval system, without written permission from the copyright owner.

The content, statements, views, and opinions herein are the sole expression of the respective authors and not that of Jones & Bartlett Learning, LLC. Reference herein to any specific commercial product, process, or service by trade name, trademark, manufacturer, or otherwise does not constitute or imply its endorsement or recommendation by Jones & Bartlett Learning, LLC and such reference shall not be used for advertising or product endorsement purposes. All trademarks displayed are the trademarks of the parties noted herein. Databases Illuminated, Fourth Edition is an independent publication and has not been authorized, sponsored, or otherwise approved by the owners of the trademarks or service marks referenced in this product.

There may be images in this book that feature models; these models do not necessarily endorse, represent, or participate in the activities represented in the images. Any screenshots in this product are for educational and instructive purposes only. Any individuals and scenarios featured in the case studies throughout this product may be real or fictitious but are used for instructional purposes only.

23635-4

Production Credits

Vice President, Product Management: Marisa R. Urbano

Vice President, Content Strategy and Implementation: Christine Emerton

Product Manager: Ned Hinman

Content Strategist: Melissa Duffy

Content Coordinator: Mark Restuccia

Director, Project Management and Content Services: Karen Scott

Project Manager: Kristen Rogers

Senior Project Specialist: Dan Stone

Senior Digital Project Specialist: Angela Dooley

Marketing Manager: Andrea DeFronzo

Content Services Manager: Colleen Lamy

Product Fulfillment Manager: Wendy Kilborn

Composition: Straive

Cover Design: Briana Yates

Media Development Editor: Faith Brosnan

Rights & Permissions Manager: John Rusk

Rights Specialist: James Fortney

Cover Image (Title Page, Part Opener, Chapter Opener): Cherezoff/Shutterstock

Printing and Binding: McNaughton & Gunn

Library of Congress Cataloging-in-Publication Data

Names: Ricardo, Catherine M., author. | Urban, Susan D., author. | Davis, Karen C., author.

Title: Databases illuminated / Catherine M. Ricardo, Emeritus Professor of Computer Science, Iona College, New Rochelle, NY, Susan D. Urban, Emeritus Professor, School of Computing and Augmented Intelligence, Arizona State University, Tempe, AZ, Karen C. Davis, Professor Miami University, Oxford, OH.

Description: Fourth edition. | Burlington, Massachusetts : Jones & Bartlett Learning, [2023] | Includes index.

Identifiers: LCCN 2021041929 | ISBN 9781284231588 (paperback)

Subjects: LCSH: Database management.

Classification: LCC QA76.9.D3 R514 2023 | DDC 005.74dc23

LC record available at https://lccn.loc.gov/2021041929

6048

Printed in the United States of America

26 25 24 23 22 10 9 8 7 6 5 4 3 2 1

DEDICATION

For Catherine M. Ricardo

To my husband, Henry, my children and their spouses, and my grandchildren, Tomas, Nicholas, Christopher, Joshua, and Elizabeth.

For Susan D. Urban

To my husband, Joe, and to Andrew and Heather, Jillian and David, and my grandsons, Charlie and Teddy. Thanks for your love and support.

For Karen C. Davis

To my husband, Bobby, and my daughter, Evie. Thanks for all the love and laughter.

For Susan and Karen

To Lois M.L. Delcambre for starting us down this path so many years ago.

Chapter opener image: cherezoff/Shutterstock

CONTENTS

Chapter opener image: cherezoff/Shutterstock

PREFACE

Purpose of This Book

Databases have become a central element of the framework of modern computer systems. It follows that the study of database systems, design, and management is an essential part of the education of computer science, data science, information science, and information technology curricula. A course in database technology should provide students with a strong theoretical background, practice in database design, and experience creating and developing a working database. Students should also be exposed to emerging data management issues and new directions for database technology. This book is designed to help students integrate theoretical material with practical knowledge, using an approach that applies theory to database implementation. It will also help students understand the difference between traditional database technology and the new directions created by big data, outlining the motivation, fundamental concepts, technologies, and challenges associated with handling large datasets. Issues of data security and privacy are incorporated throughout the text, as well as in a special chapter devoted to these topics.

Structure

Theoretical foundations are presented early, and theoretical concepts are incorporated throughout the book, including in the chapters that address implementation. Chapters are sequenced to take the student through the process of planning, designing, and implementing databases using the leading models. Conceptual and logical database design are given thorough consideration. The entity-relationship (ER) and enhanced entity-relationship (EER) models are introduced early and then mapped to the relational model. Full examples of implementations of relational models are presented in detail, with Java Database Connectivity (JDBC) illustrated as an application programming interface for accessing relational databases. Reverse engineering from the relational to the ER model is included. Relational normalization is studied in detail, and many examples of the normalization process are discussed. The Unified Modeling Language (UML) is presented as a vehicle for conceptual design for the object-oriented model and a full example of an object-oriented model database is given. The object-relational model is described, with mappings from both UML and EER models shown. Details of implementing the object-relational model are presented. For the semi-structured model, both JavaScript Object Notation (JSON) and Extensible Markup Language (XML) implementations are presented. NoSQL models are described, with examples of documentbased and graph-based systems presented in detail.