Concepts of Database Management Systems (BCA)

Concepts of Database Management Systems (BCA)

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...

Full description

Bibliographic Details
Main Author: Naik, Shefali (-)
Format: eBook
Language:Inglés
Published: Noida : Pearson India 2014.
Edition:1st ed
Series:Always learning.
Subjects:
Database management.
Electronic data processing.
See on Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009820527106719
Table of Contents:
  • 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.

Similar Items