User:Ritu Shrestha/Teaching Practice Lesson Plan-32

Class: BICTE 4^th 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?