Neelkanth - BCA Textbook - Database Management Systems (BCA-52T-113)

Name : Neelkanth - BCA Textbook - Database Management Systems (BCA-52T-113)

Author : Dr. Mahaveer Kumar Sain, Vipin Singh

Book Format : Paperback

Edition : 1

Genre : Higher Education Textbooks

ISBN : 9789357366069

Language : English

Pages : 201-300 Pages

Publish Year : 2024

Publisher : Neelkanth Publishers

Semester : II

Topic : Database Storage & Design Textbooks

Overview of Database Management System

History of Database Management System

Basic DBMS Terminologies

Overview of Popular DBMS

File System vs Database Management System

Advantages and Disadvantages of DBMS

Relational Database Management System (RDBMS)

Object Oriented Database Management System

Codd’s Rules

Data Independence

Architecture of DBMS

Data Abstraction

Schema

Database Languages

Database Administrator

Database Users

Data Models

Distributed Database

Data Modeling

Data Modeling

ER Model

Mapping Constraints

Keys

Generalization and Specialization

Aggregation

Relational Model

Relational Model Concept

Constraints

Languages

Relational Database Design by ER and EER Mapping

Relational Algebra and Calculus

Database Design

Functional Dependencies

Normalization

Decomposition

Transaction Management

Concept of Transaction

ACID Properties

Serializability

Isolation

Checkpoint

Deadlock Handling

Recovery System and Security

Failure in DBMS

Database Recovery and Atomicity

Log Based Recovery

Shadow Paging

Recovery with Concurrent Transactions

Introduction to Security

Authorization

Introduction to SQL

Structured Query Language

SQL Data Type

SQL Literals

SQL Commands

SQL Operators and their Procedure

Views

Indexes

Queries and Subqueries

Aggregate Functions in DBMS

SQL Operations

Joins

SQL Set Operations

Database Management System

Country of Origin : India