User:Ritu Shrestha/Teaching Practice Lesson Plan-32

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