You are previewing Concepts of Database Management System.
O'Reilly logo
Concepts of Database Management System

Book Description

Concepts of Database Management System is designed to meet the syllabi requirements of undergraduate students of computer applications and computer science. It describes the concepts in an easy-to-understand language with sufficient number of examples. The overview of emerging trends in databases is thoroughly explained. A brief introduction to PL/SQL, MS-Access and Oracle is discussed to help students get a flavor of different types of database management systems.

Table of Contents

  1. Cover
  2. Title Page
  3. Contents
  4. Dedication
  5. Foreword
  6. Acknowledgements
  7. Chapter 1. Basics of Database
    1. 1.1 Introduction
    2. 1.2 Data and Information
      1. 1.2.1 Data
      2. 1.2.2 Information
    3. 1.3 Database
      1. 1.3.1 Components of Database System
    4. 1.4 Database Management
    5. 1.5 Database Management System
    6. 1.6 Need for a Database
    7. 1.7 File-based Data Management System
    8. 1.8 Characteristics, or Features, or Advantages of Database Systems
    9. 1.9 Limitations of Database
    10. Summary
  8. Chapter 2. Data Models and Architecture of DBMS
    1. 2.1 Evolution of Data Models
    2. 2.2 Hierarchical Data Model
    3. 2.3 Network Data Model
    4. 2.4 Relational Data Model
    5. 2.5 Object-oriented Data Model
    6. 2.6 Object-relational Data Model
    7. 2.7 Three Level Architecture of Database
    8. 2.8 Database Languages
    9. 2.9 Data and Structural Independence
    10. Summary
  9. Chapter 3. Relational Database Management System
    1. 3.1 Introduction
    2. 3.2 RDBMS Terminology
    3. 3.3 Various Types of Keys
    4. 3.4 Integrity Rules
    5. 3.5 Relational Set Operators
    6. 3.6 Retrieval Operators
    7. 3.7 CODD’s Twelve Rules of Relational Database
    8. 3.8 Database Life Cycle
    9. 3.9 Data Dictionary
    10. Summary
  10. Chapter 4. Developing Entity-Relationship Diagram
    1. 4.1 Introduction
    2. 4.2 Identifying Entities
    3. 4.3 Identifying Relationships
    4. 4.4 Types of Relationships
    5. 4.5 Relationship Participation
    6. 4.6 Strong and Weak Relationship
    7. 4.7 Managing Many-to-many Relationship
    8. 4.8 Example of E-R Model
    9. 4.9 Extended E-R Model
    10. 4.10 Converting E-R Model into Relational Model
    11. 4.11 Object Modelling
      1. 4.11.1 Subclass and Superclass
      2. 4.11.2 Specialization and Generalization
      3. 4.11.3 Class Diagram
    12. Summary
  11. Chapter 5. Normalization
    1. 5.1 Introduction
    2. 5.2 Need for Normalization
    3. 5.3 Types of Dependencies
    4. 5.4 First Normal Form
    5. 5.5 Second Normal Form
    6. 5.6 Third Normal Form
    7. 5.7 Boyce-Codd Normal Form
    8. 5.8 Multi-valued Dependency
    9. 5.9 Join Dependency
    10. 5.10 Lossless and Lossy Decompositions
    11. 5.11 Normalizing Tables
    12. 5.12 Examples
    13. Summary
  12. Chapter 6. Managing Data Using Structured Query Language (SQL)
    1. 6.1 Introduction
    2. 6.2 Data Definition Commands
    3. 6.3 Data Manipulation Commands
    4. 6.4 SELECT Statement and Its Clauses
    5. 6.5 Aggregate Functions
    6. 6.6 Date and Time Functions
    7. 6.7 String Functions
    8. 6.8 Conversion Functions
    9. 6.9 Mathematical Functions
    10. 6.10 Special Operators
    11. 6.11 Types of Constraints
    12. 6.12 Types of Join and Set Operators
    13. 6.13 Sub-query
    14. 6.14 Advances SQL Roll-up, Cube, Crosstab
    15. Summary
  13. Chapter 7. Introduction to PL/SQL
    1. 7.1 Introduction
    2. 7.2 Block of PL/SQL in Oracle
    3. 7.3 Cursors in Oracle
    4. 7.4 Procedures in Oracle
    5. 7.5 Functions in Oracle
    6. 7.6 Triggers in Oracle
    7. 7.7 Overview of Packages in Oracle
    8. Summary
  14. Chapter 8. Transaction Management in Database
    1. 8.1 Introduction
    2. 8.2 Definition of Transaction
    3. 8.3 Properties of Transaction
    4. 8.4 States of Transaction
    5. 8.5 Concurrency Control Using Locks
    6. 8.6 Deadlocks
    7. 8.7 Database Backup and Recovery
    8. 8.8 Security, Integrity and Authorization
    9. Summary
  15. Chapter 9. Centralized and Distributed Database Management System
    1. 9.1 Introduction
    2. 9.2 Types of Databases
    3. 9.3 Centralized Database Management System vs. Distributed Database Management System
    4. 9.4 DDBMS Components
    5. 9.5 Distributed Processing
    6. 9.6 DDBMS Advantages and Disadvantages
    7. Summary
  16. Chapter 10. Advancement in Databases
    1. 10.1 Multidimensional Database
    2. 10.2 Mobile Databases
    3. 10.3 Multimedia Databases
    4. 10.4 Data Warehousing and Data Mining
    5. 10.5 Open Source Database
    6. 10.6 Spatial Databases
    7. 10.7 Moving Object Databases
    8. 10.8 NoSQL Database
    9. Summary
  17. Chapter 11. Overview of MS-Access 2007
    1. 11.1 MS-Access as an RDBMS
    2. 11.2 Elements of MS-Access
    3. 11.3 Creating Database and Tables
    4. 11.4 Data Types of MS-Access
    5. 11.5 Sorting and Filtering Records in MS-Access
    6. 11.6 Creating Queries in MS-Access
    7. 11.7 Creating Forms in MS-Access
    8. 11.8 Creating Reports in MS-Access
    9. 11.9 Creating Macros and Switchboard
    10. Summary
  18. Chapter 12. Overview of Oracle
    1. 12.1 Oracle as an RDBMS
    2. 12.2 Logging into Oracle
    3. 12.3 Command Summary of Oracle Database 10g XE
    4. 12.4 Database Administration
      1. 12.4.1 Managing Users
      2. 12.4.2 Managing Roles
      3. 12.4.3 Managing Privileges
    5. Summary
  19. References and Bibliography
  20. Copyright