I understand. Do you have one to many relationships among all the tables? Is Device an independent entity that has one room and Employee and independent entity that have a...

I think there is a problem with you relational model. Could you please add the cardinality?

Stored procedures may not solve the deadlocks 100% but you may have a considerable improvement. I think, If you have a server running with just one processor, SQL Server will...