01621nam a22002057a 4500003000400000005001700004008004100021040000800062082003000070100001800100245012300118250001200241260003900253300002000292501098500312650002501297650003501322650004101357700001701398OSt20200309101904.0190826b        xxu||||| |||| 00| 0 eng d  cAEF  223rd  ed. a658.403	bBHA1 aKudale, G. A.10aTextbook of relational database:bComputer science (CS-202): paper-IIcAccording to new CBSC syllabus w. e. f. 2019-20  a1st ed.  aPune:bVision publications,c2019.  a176 p. :c25 cm  aContents

1. Introduction to RDBMS                                            

1. Introduction

2. Introduction to Popular RDBMS Product and their Features    

3. Difference between DBMS and RDBMS

4. Relationship among Application Programs and RDBMS

2. PL-SQL 

1. Overview of PL/SQL

2. Data Types  

3. PL/SQL Block

4. Exceptional Handling   

5. Functions, Procedures  

6. Cursor 

7. Database Triggers

8. Oracle Packages  

3. Introduction to RDBMS                                  

1. Transaction Concept    

2. Transaction Properties 

3. Transaction States

4. Concurrent Execution   

5. Serializability  

4. Concurrency Control and Recovery System

1. Concurrency Control    

2. Lock Based Protocols   

3. Timestamp-Based Protocols   

4. Validation-Based Protocols  

5. Deadlock Handling

6. Recovery System  

7. Failure Classification 

8. Storage Structure

9. Recovery and Atomicity 

10.Recovery with Concurrent Transactions  

11.Remote Backup Systems  aRelational databases  aManagement information systems  aFile organization (Computer science)10aPawar, M. D.