RDBMS Notes for BCA Pune University

Hii sir, I wants to get the Syllabus of the Subject RDBMS of the BCA of the pune University ?

[sumit]

As you Asking for the Syllabus of the Subject RDBMS of the BCA of the pune University the Syllabus of the RDBMS Course of the Pune University is given below

Introduction To RDBMS
1.1 Introduction to popular RDBMS product and theirfea
1.2 Difference Between DBMS and RDBMS
1.3 Relationship among application programs and RDBM

PLSQL

2.1 Overview of PLSQL
2.2 Data Types
2.3 PLSQL Block
2.3.1 % type, % rowtype
2.3.2 Operators, Functions, comparison, numeric, cha

date
2.3.3 Control Statement
2.4 Exception Handling
2.4.1 Predefined
2.4.2 User defined exceptions
2.5 Functions , Procedures
2.6 Cursor
2.6.1 Definition
2.6.2 Types of cursor- implicit, explicit (attributes)
2.6.3 Parameterized cursor
2.7 Trigger
2.8 Package

Transaction Management
3.1 Transaction Concept
3.2 Transaction Properties
3.3 Transaction States
3.4 Concurrent Execution
3.5 Serializability
3.5.1 Conflict Serializability
3.5.2 View Serializability
3.6 Recoverability

3.6.1 Recoverable Schedule
3.6.2 Cascadless Schedule
Concurrency Control
4.1 Lock Based Protocol
4.1.1 Locks
4.1.2 Granting of Locks
4.1.3 Two Phase Locking Protocol
4.2 Timestamp Based Protocol
4.2.1 Timestamp
4.2.2 Timestamp ordering protocol
4.2.3 Thomas’s Write Rule
4.3 Validation Based Protocol
4.4 Deadlock Handling
4.4.1 Deadlock Prevention
4.4.2 Deadlock Detection
4.4.3 Deadlock Recovery

Recovery System
5.1 Failure Classification
5.1.1 Transaction Failure
5.1.2 System Crash
5.1.3 Disk Failure
5.2 Storage Structures
5.2.1 Storage Types
5.2.2 Data Access
5.3 Recovery & Atomicity
5.3.1 Log based Recovery
5.3.2 Deferred Database Modification
5.3.3 Immediate Database Modification
5.3.4 Checkpoints
5.4 Recovery with Concurrent Transaction
5.4.1 Transaction Rollback
5.4.2 Restart Recovery
5.5 Remote Backup System

For Any Query you May contact to the Pune University the contact details Are given below

Contact details :
Pune University
Address: Ganeshkhind, Pune, Maharashtra 411007
Phone: 020 2569 6064