Higher Ed. and Vocational >> Business and Economics >> IT and Management Information Systems >> Database Management Systems


Database Systems: An Application-Oriented Approach, Introductory Version, 2/e

Database Systems:  An Application-Oriented Approach, Introductory Version,  2/e

Author(s):
  • Michael Kifer
  • Philip Lewis
  • Arthur Bernstein
  • Prabin Panigrahi
  • Author: Michael Kifer
    • ISBN:9788131703748
    • 10 Digit ISBN:8131703746
    • Price:Rs. 729.00
    • Pages:624
    • Imprint:Pearson Education
    • Binding:Paperback
    • Status:Available


    Ratings:

    Designed for students learning databases for the first time, Database Systems: An Application-Oriented Approach, Introductory Version, 2/e,, presents the principles underlying the design and implementation of databases and their applications. This book consists of nine core chapters, including separate chapters on triggers (Chapter 7) and using SQL in an application (Chapter 8) that recognize the growing importance of application development in building database systems. Additional chapters (Chapters 11-17) cover database tuning, transaction processing, query processing, object-oriented databases, and XML databases and provide a variety of ways to enrich students' introduction to databases.

    Table of Content

    1. INTRODUCTION.
      1. Overview of Databases and Transactions.
      2. The Big Picture.
    2. DATABASE MANAGEMENT.
      1. The Relational Data Model.
      2. Conceptual Modeling of Databses with Entity-Relationship Diagrams and the Unified Modeling Language.
      3. Relational Algebra and SQL.
      4. Database Design with The Relational Normalization Theory.
      5. Triggers and Active Databases.
      6. Using SQL in an Application.
    3. OPTIMIZING DBMS PERFORMANCE AND TRANSACTION PROCESSING.
      1. Physical Data Organization and Indexing.
      2. The Basics of Query Processing.
      3. An Overview of Query Optimization.
      4. Database Tuning.
      5. An Overview of Transaction Processing.
    4. SOFTWARE ENGINEERING ISSUES AND DOCUMENTATION.
      1. Case Study: Starting the Student Registration System.
      2. Case Study: Completing the Student Registration System.
    5. ADVANCED TOPICS IN DATABASES.
      1. Introduction to Object Databases.
      2. Introduction to XML and Web Data.
    • References.
    • Index.

    Salient Features

    • An application-oriented introduction to database concepts
    • SQL updated to the latest standard
    • Coverage of both Entity-Relationship modeling and the Unified Modeling Language
    • Discussions of software-engineering issues related to implementing transaction-processing applications
    • Detailed case studies providing hands-on experience in application design and programming
    • In-depth coverage of XML, object-oriented databases, and database tuning