Here is the complete code for the provided specification:

Understanding Serializable Isolation Level in SQL Server: Strategies for Consistent Transaction Execution