RELATIONAL DATABASE MANAGEMENT SYSTEM BBA,B.COM (CA) Second Sem

Unit

Topics

1

Introduction to RDBMS and PL-SQL

1.1 Introduction to RDBMS

1.1.1 Difference between DBMS and RDBMS

1.1.2 Advantages and Disadvantages of RDBMS

1.2 Overview of PLSQL

1.2.1 Data Types

1.2.2 PLSQL Block

1.2.3 Variables, Constant

1.2.4 Operator

1.3 Control Statement

1.3.1 Conditional Control

1.3.2 Looping Control

1.3.3 Sequential Control

1.3.4 Case Statement

1.4 Exception Handling

1.4.1 Structure of Exception Handling

1.4.2 Types of Exception

1.4.3 Handling Exception

1.5 Functions

1.5.1 Create a Function

1.5.2 Calling a Function

1.6 Procedures

1.6.1 Creating a Procedure

1.6.2 Executing a Standalone Procedure

1.7 Cursor

1.7.1 Attributes of Cursor

1.7.2 Types of Cursors

1.8 Trigger

1.8.1 Types of Triggers

1.8.2 Different Operation on Triggers

1.9 Package

1.9.1 Characteristics of PL/SQL Package

1.9.2 Advantages of PL/SQL Packages [Lecture-10]

2

Transaction Management

2.1 Transaction Concept

2.1.1 Transaction Concept

2.1.2 ACID Properties

2.1.3 Transaction State

2.1.4 Transaction Operation

2.2 Schedule

2.2.1 Serial Schedule

2.2.2 Concurrent Schedule

2.3 Serializability

2.3.1 Conflict Serializability

2.3.2 View Serializability

2.3.3 Testing for Serializability

2.4 Recoverability

2.4.1 Recoverable Schedules

2.4.2 Cascade less Schedules [Lecture-10]

3

Concurrency Control & Recovery System

3.1 Lock Based Protocol

3.1.1 Lock

3.1.2 Locking Protocol

3.1.3 Locking Techniques for Concurrency Control

3.1.4 Granting of Locks

3.1.5 Two-Phase Locking Protocol

3.2 Timestamp Based Protocol

3.3 Deadlock Handling

3.3.1 Deadlock

3.3.2 Techniques of Deadlock Handling

3.3.3 Deadlock Prevention

3.3.4 Deadlock Detection

3.3.5 Deadlock Recovery

3.4 Failure Classification

3.5 Recovery & Atomicity

3.6 Recovery with concurrent transaction [Lecture-10]