Concept Of Database Management System

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