ConnectWise Interview Question

Database design while also handling deadlocks, concurrent access and which would be better fit sql or nosql