Fundamentals of Database Systems: International Edition, 4/E
0321204484

Ramez Elmasri, University of Texas at Arlington
Shamkant B. Navathe, Georgia Institute of Technology

Publisher: Pearson Higher Education
Copyright: 2004
Format: Paper; 1009 pp

ISBN-10: 0321204484
ISBN-13:9780321204486

Our Price: £45.99
Status: Not Yet Published
Estimated Availability: 21 Aug 2003



Description

Fundamentals of Database Systems has become the world-wide leading textbook because it combines clear explanations of theory and design, broad coverage of models and real systems, and excellent examples with up-to-date introductions and modern database technologies. This book has been revised and updated to reflect the latest trends in technological and application development. This fourth edition expands on many of the most popular database topics, including SQL, security, and data mining along with an introduction to UML modeling and an entirely new chapter on XML and Internet databases.


Table Of Contents

I. INTRODUCTION AND CONCEPTUAL MODELING.

 1. Databases and Database Users.

 2. Database System Concepts and Architecture.

 3. Data Modeling Using the Entity-Relationship Model.

 4. Enhanced Entity-Relationship and UML Modeling.

II. RELATIONAL MODEL: CONCEPTS, CONSTRAINTS, LANGUAGES, DESIGN, AND PROGRAMMING.

 5. The Relational Data Model and Relational Database Constraints.

 6. Relational Algebra and Relational Calculus.

 7. Relational Database Design by ER- and EER-to-Relational Mapping.

 8. SQL99-Schema Definition, Constraints, and Queries.

 9. More SQL-Assertions, Views, and Programming Techniques.

III. DATABASE DESIGN THEORY AND METHODOLOGY.

10. Functional Dependencies and Normalization for Relational Databases.

11. Relational Database Design Algorithms and Further Dependencies.

12. Practical Database Design Methodology Using UML.

IV. DATA STORAGE, INDEXING, QUERY PROCESSING, AND PHYSICAL DESIGN.

13. Disk Organization, Basic File Structures, and Hashing.

14. Indexing Structures for Files.

15. Algorithms for Query Processing and Optimization.

16. Physical Database Design and Tuning.

V. TRANSACTION PROCESSING CONCEPTS.

17. Introduction to Transaction Processing Concepts and Theory.

18. Concurrency Control Techniques.

19. Database Recovery Techniques.

VI. OBJECT AND OBJECT-RELATIONAL DATABASES.

20. Object Database Concepts.

21. The ODMG Standard for Object Databases.

22. Object-Relational Systems and SQL3.

VII. FURTHER TOPICS.

23. Database Security, Authorization, and Encryption.

24. Enhanced Data Models for Advanced Applications.

25. Distributed Databases and Client-Server Architectures.

VIII. EMERGING TECHNOLOGIES.

26. Internet Databases and XML.

27. Data Warehousing and Data Mining Concepts.

28. Emerging Database Technologies and Applications.

Appendix A. Alternative Diagrammatic Notations for ER models.

Appendix B. Database Design and Application Implementation Case Study.

(New appendix on the Web including a detailed database design case study).

Appendix C. Parameters of Disks (old Appendix B).

Appendix D. The QBE Language (old section 9.5).

Appendix E. Hierarchical Data Model (old Appendix C dropped - moved to Web).

Appendix F. Network Data Model (old Appendix D dropped - moved to Web).

Bibliographic References.

Index.


Features
  • The market-leading text for both a first and follow-on database course.
  • Features an extensive table of contents that includes basic topics (modeling, diagrams, relational algebra/calculus, SQL, normalization) and advanced object database, toning, mining, XML, and security.
  • Famous for its clear and complete writing style.
  • Renowned for its combinational theory, examples, and exercises which provide the foundational knowledge on topics.
  • Covers advanced modeling in the areas of active, temporal, and spatial databases.
  • Provides coverage of issues on physical database design and tuning.
  • Discusses current database application areas of GIS, genome, and digital libraries.
  • Presents a clear and complete discussion of the relational approach, including modeling, design, algebra and calculus, and query languages.
  • Each new copy comes with free access to Addison-Wesley's Database Place. Database Place helps students master the key concepts of all database courses. It includes online tutorials that help students with their mastery of modeling, SQL, and data normalization. Each tutorial asks students to solve problems (such as writing an SQL query, drawing a diagram, or normalize a relation), and then provides useful feedback based on the student's solution.

New To This Edition
  • Provides new and expanded PowerPoints for professors.
  • Now covers both the traditional ER model and UML when discussing data modeling.
  • Includes updated material on SQL, including a new chapter, which discusses topics from SQL programming including SQLJ, JDBC, and ODBC.
  • Applies ideas from the book to a fully developed case study that uses a step-by-step database design and implementation for a bookstore application.
  • Offers updated coverage of security and database tuning.
  • Features a new chapter on the relationship of XML and Internet databases keeps students on the edge of database technology.
  • Includes a new chapter on data mining.

Appropriate Courses
Database Systems, Database Management and Design, Database Design.

All Valuepacks
Multi Pack: Fundamentals of Database Systems (International Edition) with Introduction to SQL:Mastering the Structured Query Language
Elmasri, Navathe & Van Der Lans
© 2004 | Pearson Higher Education | Kit/Package/ShrinkWrap | Estimated Availability: 26 Aug 2004
ISBN-10: 1405811420 | ISBN-13: 9781405811422
Our Price: £70.91

Package consists of:
Fundamentals of Database Systems: International Edition, 4/E
Introduction to SQL: Mastering the Structured Query Language, 3/E


Student Supplements
DatabasePlace Website
Addison Wesley Higher Education
© 2003 | Addison-Wesley | Website | Available
ISBN-10: 0321160088 | ISBN-13: 9780321160089

Addison-Wesley's Database Place helps students master the key concepts of all database courses, including online tutorials that help students with their mastery of entity-relationship modeling, relational modeling, SQL, normalization, and more.




Instructor Supplements
Online Solution's Manual, 4/E
Elmasri & Navathe
© 2004 | Addison-Wesley | On-line Supplement | Available
ISBN-10: 0321359178 | ISBN-13: 9780321359179

DatabasePlace Website
Addison Wesley Higher Education
© 2003 | Addison-Wesley | Website | Available
ISBN-10: 0321160088 | ISBN-13: 9780321160089

Addison-Wesley's Database Place helps students master the key concepts of all database courses, including online tutorials that help students with their mastery of entity-relationship modeling, relational modeling, SQL, normalization, and more.



Online Book Figures PowerPoints, 4/E
Elmasri & Navathe
© 2004 | Addison-Wesley | On-line Supplement | Available
ISBN-10: 0321360753 | ISBN-13: 9780321360755