Editing User:Ritu Shrestha/Teaching Practice Lesson Plan-32

__notoc__
Class: BICTE 4<sup>th</sup> Semester                                              Date: 2024/05/16		

Subject: DBMS                                                                Time: 50 min       

Unit: 8                                                                            Number of Students: 15

Topic: Properties of Transactions                

== 1.    Specific Objective: ==
At the end of this lesson, students will be able:

·       To explain the concept of transaction in DBMS.

·       To illustrate properties of transactions in DBMS.

== 2.    Instructional materials: ==
·       Daily uses materials

·       PowerPoint presentation slides

== 3.    Teaching Learning Activities: ==
·       Welcome the students to the lesson and introduce the topic and objectives.

·       Pose questions: What do you understand by transactions in DBMS? Why are they important?

·       Engage students with a brief discussion on their understanding of transactions in databases.

·       Discuss the importance of transactions in ensuring data consistency, reliability, and integrity in database systems.

·       Explain that transactions have several key properties that govern their behavior and reliability.

·       Define atomicity and provide examples to illustrate atomicity.

·       Discuss how atomicity is achieved through mechanisms like undo logs or rollback segments.

·       Define consistency as the property Discuss the role of constraints (e.g., primary key, foreign key) and triggers in maintaining consistency.

·       Define isolation and durability.

·       Emphasize the importance of durability for maintaining data integrity and reliability.

·       Summarize the key concepts and takeaways from the lesson.

·       Encourage students to ask any remaining questions or share any additional thoughts before concluding the lesson.

== 4.    Assessment: ==
·       What is transaction?

·       What is the full form of ACID?

== 5.    Evaluation: ==
In what ways do transaction properties impact the design and development of database applications?