The following key features are included in the fourth edition: Along the way-in Parts 2 through 6-we provide an in- depth treatment of the most important aspects of database fundamentals. We conclude the book in Parts 7 and 8 with an introduction to emerging technologies, such as data mining, XML, security, and Web databases. We start in Part I with an introduction and a presentation of the basic concepts and terminology, and database conceptual modeling principles.
We assume that the readers are familiar with elementary programming and data-structuring concepts and that they have had some exposure to the basic computer organization. The book is meant to be used as a textbook for a one- or two-semester course in database systems at the junior, senior or graduate level, and as a reference book. Our presentations stresses the fundamentals of database modeling and design, the languages and facilities provided by the database management systems, and system implementation techniques. Preface This book introduces the fundamental concepts necessary for designing, using, and imple- menting database systems and applications.
To my motherVijayaand wifeAruna for their love and support S. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, or other- wise, without the prior written permission of the publisher. Copyright © 2004 by Pearson Education, Inc. QA 76.9.03E57 2003 005.74 dc21 2003057734 ISBN 6-7 For information on obtaining permission for the use of material from this work, please submit a writ- ten request to Pearson Education, Inc., Rights and Contracts Department, 75 Arlington St., Suite 300, Boston, MA 02116 or fax your request to 61. Includes bibliographical references and index. Fundamentals of database systems / Ramez Elmasri, Shamkant B. Library of Congress Cataloging-in-Publication Data Elmasri, Ramez. The pub- lisher does not offer any warranties or representations, nor does it accept any liabilities with respect to the programs or applications. They have been tested with care, but are not guaranteed for any particular purpose. The programs and applications presented in this book have been included for their instructional value. Where those designations appear in this book, and Addison-Wesley was aware of a trademark claim, the designations have been printed in initial caps or all caps. Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Figure 12.15 is a graphi- cal data model diagram in Rational Rose'", Figure 12.17 is the company database class diagram drawn in Rational Rose®.
Boston San Francisco New York London Toronto Sydney Tokyo Singapore Madrid Mexico City Munich Paris Cape Town Hong Kong Montreal Sponsoring Editor: Project Editor: Senior Production Supervisor: Production Services: Cover Designer: Marketing Manager: Senior Marketing Coordinator: Print Buyer: Cover image © 2003 Digital Vision Maite Suarez-Rivas Katherine Harutunian Juliet Silveri Argosy Publishing Beth Anderson Nathan Schultz Lesly Hershman Caroline Fell Access the latest information about Addison-Wesley titles from our World Wide Web site: Figure 12.14 is a logical data model diagram definition in Rational Rose®. N avathe College of Computing Georgia Institute of Technology , FUNDAMENTALS OF FourthEdition DATABASE SYSTEMS FUNDAMENTALS OF Fourth Edition DATABASE SYSTEMS Ramez Elmasri Department of Computer Science Engineering University of Texas at Arlington Shamkant B.