Read and download CBSE Class 12 Informatic Practices RDBMS Concepts chapter in NCERT book for Class 12 Informatics Practices. You can download latest NCERT eBooks for 2022 chapter wise in PDF format free from Studiestoday.com. This Informatics Practices textbook for Class 12 is designed by NCERT and is very useful for students. Please also refer to the NCERT solutions for Class 12 Informatics Practices to understand the answers of the exercise questions given at the end of this chapter
Rdbms Concepts Class 12 Informatics Practices NCERT
Class 12 Informatics Practices students should refer to the following NCERT Book chapter Rdbms Concepts in standard 12. This NCERT Book for Grade 12 Informatics Practices will be very useful for exams and help you to score good marks
Rdbms Concepts NCERT Class 12
Introduction
DBMS and Transaction Management Raunak studies in Class XII. He is very helpful. During summer vacations, he helped his aunt's son in his studies. His aunt was very pleased with him and gave him a cheque of ` 2000.00. Raunak knows that after presentation of the cheque to the bank, his aunt's account will be reduced by ` 2000.00 and his account will be increased by ` 2000.00. Raunak walked up to the bank to present the cheque. Are Raunak's fears valid? Can you recollect something like this happening with you or with your friends or relatives?
Raunak should not fear at all as the Bank's DBMS looks after these eventualities. DBMSs ensure consistency (correctness) of data by managing Transactions. Mostly customers view an operation like transfer of funds as a single operation but actually it consists of series of operations. Suppose Raunak's account number is 3246 and his aunt's account number is 5135. In order to process the cheque presented by Raunak, the following two SQL commands need to be executed on the database maintained by the bank:
What is a Transaction
A Transaction is a unit of work that must be done in logical order and successfully as a group or not done at all. Unit of work means that a Transaction consists of different tasks - but together they are considered as one unit. Each transaction has a beginning and an end. If anything goes wrong in between the execution of transaction, the entire transaction (No matter to what extent has been done) should be cancelled. If it is successful, then the entire transaction should be saved to the database.
A transaction is a unit of work that must be done in logical order and successfully as a group or not done at all. In Raunak's case, both the updation statements constitute a transaction. Both are together treated as a single unit.
To understand how transactions are managed, let us study the following 3 statements of SQL:
START TRANSACTION statement
COMMIT statement
ROLLBACK statement
Please refer to the link below for - CBSE Class 12 Informatic Practices RDBMS Concepts
Click for more Informatics Practices Study Material ›