BCA 322 DBMS

FILE ORGANIZATION

·         Introduction

·         Storage Devices Characteristics

·         File Organization

·         Sequential Files

·         Indexing and Methods of Indexing

·         Hash Files

INTRODUCTION TO DATABASE SYSTEMS

·         What is Data, Database System, DBMS?

·         Single and Multi-User Systems

·         Advantages and Drawbacks of DBMS

·         Architecture of DBMS

·         Users of DBMS

·         Roll of Database Administrator

·         Components of DBMS

·         Types of DBMS

·         Hierarchical

·         Network

·         Relational

·         Why RDBMS?

·         Features of RDBMS

·         Attributes, Tuples & Tables, Codd’s Rules

·         Entity Relationship Model

·         Entity Relationship Model

·         Entity Set

·         Relationship Set

·         Attributes and Values.

·         Weak and Strong Entity

·         Keys in DBMS

·         Conventions for Drawing ERD

·         Abstraction

·         Generalization

DBMS CONCEPTS

·         Objectives

·         Introduction

·         ACID Properties

·         Concurrency Control

·         Recovery Mechanisms

·         Views And Security

·         Integrity Constraints

·         Data Security

·         Summary

RELATIONAL DATABASE DESIGN

·         Objectives

·         Introduction

·         Need for Proper Database

·         Undesirable Properties of Bad Database Design

·         Functional Dependencies

·         Normalization Using FDS

·         1 NF

·         2 NF

·         3 NF

·         BCNF

·         Properties of Decomposition

·         Loss Less Join

·         Dependency Preserving

·         Summary

SQL RELATIONAL DATABASE LANGUAGE

·         Objectives

·         Introduction

·         DDL - Data Defination Language

·         DML - Data Manipulation Language

·         DCL- Data Control Language

·         Simple Queries

·         Summary

SECURITY

·         Objectives

·         Introduction

·         Granting Access to Users

·         Extending and Restricting

·         Privileges

·         Using Views of Security

·         Summary

TRANSACTION PROCESSING

·         Objectives

·         Introduction

·         Transaction Processing

·         Properties of Transaction

·         Schedules

·         Serializing and Its Need

·         Summary

·

BACKUP AND RECOVERY

·         Objectives

·         Introduction

·         Types of Failure and Storage Systems

·         Need for Backup and Recovery

·         Summary

CONCURRENCY CONTROL AND RECOVERY TECHNIQUES

·         Objectives

·         Introduction

·         Concurrency Problems

·         Concurrency Control Mechanisms

·         Deadlocks

·         Deadlocks Handling Detection and Prevention

·         Summary

INTRODUCTION TO DATA WAREHOUSING AND DATA MINING

·         Objectives

·         Introduction

·         Data Warehousing

·         Data Mining

·         Summary