CBSE Class 12 Informatic Practices RDBMS Concepts

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

Tags: 

 


Click to View or Download pdf file
Click for more Informatics Practices Study Material

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

CBSE notification 40/2021 Innovation Ambassador Program

This is with reference to CBSE Notification No. 40/2021 dated 04.05.2021 regarding the Innovation Ambassador program – An online training program for teachers by CBSE in collaboration with Ministry of Education’s Innovation Cell (MIC) and AICTE. In view of the current...

National Youth Day and Birth Anniversary of Swami Vivekananda

Ministry of Education, Govt. of India vide D.O No. 12-4/2021-IS.4 dated 04.01.2022 intimated that 12 January 2022 will be celebrated as “National Youth Day” and “Birth Anniversary of Swami Vivekananda”.   All Schools affiliated to CBSE may celebrate 12 January 2022 as...

CBSE OMR Sheet Guidelines for Term 1

You are aware that the CBSE will be using OMR for the first time for assessment of both the Classes-X and XII in Term-I examinations. Hence, there is a need that all the students appearing in the Term-l examinations and the schools sponsoring these students should have...

CBSE Science Challenge 2021 22

Science is inexplicably linked with our lives and helps us to understand the world around us better. Scientific and technological developments contribute to progress and help improve our standards of living. By engaging with this subject, students learn to think, solve...

CBSE Term 2 Board Examinations

CBSE vide Circular No.Acad-51/2021 dated 5th July, 2021, notified that in the session 2021-2022, Board Examinations would be conducted in two terms, i.e.. Term I and Term II. This decision was taken due to the uncertainty arising out of COVID 19 Pandemic. Term I...

All India Children Educational Audio Video Festival

The Central Institute of Educational Technology (CIET), a constituent unit of National Council of Educational Research and Training (NCERT), is inviting entries for the 26th All India Children’s Educational Audio Video Festival (AICEAVF). This festival showcases the...