RDBMS Syllabus

University of Pune

( Pattern – 2013 ) w.e.f. 2014 – 15

B.C.A. Semester III

Subject Name-: RDBMS (Relational Database Management System)

Course Code-:    301

Objectives:

1.    Enables students to understand relational database concepts and transaction management concepts in database system.

2.  Enables student to write PL/SQL programs that use: procedure, function, package, cursor and trigger.

Unit		Topic	No. of	Ref.
			Lectures	Book
Unit 1	Introduction To RDBMS		2	1
	1.1 Introduction to popular RDBMS product and their features
	1.2 Difference Between DBMS and RDBMS
	1.3	Relationship among application programs  and RDBMS
Unit 2	PLSQL		20	4
	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, character,
	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
Unit 3	Transaction Management		10	1,2,3
	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
Unit 4	Concurrency Control		8	1,2,3
	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
Unit 5	Recovery System		8	1,2,3
	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
		Total No. of  Lectures	48

Recommended Books :

1)  Database System Concepts 5th Edition - Silberschatz, Korth, Sudershan.

2)  Database Management System - Bipin Desai

3)  An Introduction to Database Systems Eighth Edition C. J.Date, A.Kannan, S.Swamynathan

4)  SQL/PLSQL the programming language of oracle - Ivan Bayross