دانلود کتاب 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