https://gpttutorpro.com/lock-based-concurrency-control-in-databases/