BCA Notes (Pokhara University): Unit VII: Creating DML Triggers

In this unit named “Creating DML Triggers – Database Management System” readers and viewers will get information regarding the following topics:

Introduction to DML Trigger
DML Trigger Benefits
Types of DML Triggers
AFTER Trigger, INSTEAD OF Triggers
Uses for Triggers
Complex Auditing, Enforce Business Rules, Derive Column Values
Transaction Flow
Operations of Transaction
Properties of Transaction (ACID Properties)
Atomicity, Consistency, Isolation, Durability
States of Transaction
Transaction Schedule
Serial, Schedule, Non-serial Schedule, Serializable Schedule
Testing of Serializability
Conflict Serializable Schedule
View Serializability
Recoverability of Schedule
Irrecoverable Schedule, Recoverable with Cascading Rollback
Log-based Recovery, Checkpoint
Deadlock in DBMS
Concurrency Control
Problems of Concurrency Control
Lost Update Problem, Dirty Read, Inconsistent Retrievals Problem
Concurrency Control Protocol
Lock-based Protocol, Timestamp Ordering Protocol, Validation Based Protocol
Thomas Write Rule
Multiple Granularity
Create a DML Trigger
Using SQL Server Management Studio, Using Transact-SQL
Triggers Limitation
Delete or Disable DML Trigger
Using SQL Server Management Studio, Using Transact-SQL
Create DML Triggers to Handle Multiple Rows of Data
Examples
Storing A Running Total For A Single-Row Insert, Storing A Running Total For A Multirow Or Single-Row Insert, Storing A Running Total Based On The Type Of Insert
Modify or Rename DML Triggers
Using SQL Server Management Studio, Using Transact-SQL

This article Creating DML Triggers – Database Management System is contributed by Rashita Gurung, a student of LA GRANDEE International College.

If you like to contribute, you can mail us BCA Notes, BCA Question Collections, BCA Related Information, and Latest Technology Information at bcanotespu@gmail.com. See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.