1.In the DataBase, we can apply Table level locking or row level locking....
2.Very rare, we apply table level locking...
3.Instead of row level locking, we can take a new table and we can apply locking....
STUDENT == SNO SNAME
STU_LOCK == SNO
1.before updating the student records first verify any record is there in the LOCK table...
2.if no record then insert a record and start updating the student...and after updation delete the record from the LOCK table.
3.if there is a record then display the warning to the user....
2.Very rare, we apply table level locking...
3.Instead of row level locking, we can take a new table and we can apply locking....
STUDENT == SNO SNAME
STU_LOCK == SNO
1.before updating the student records first verify any record is there in the LOCK table...
2.if no record then insert a record and start updating the student...and after updation delete the record from the LOCK table.
3.if there is a record then display the warning to the user....
