Redesign the data and/or business layers in order to minimize serialization failures in the database. Given a set of Cold Fusion templates with queries to MS SQL time entry tables, redesign the tables and/or the templates so that simultaneous access to the time entry tables does not cause the processes to deadlock. Check out the zipped attachment for schemas and sample deadlock errors.
## Deliverables
Your solution need only be partially implemented to be considered successful, but you must oversee implementable across the application. (Your solution cannot delete columns in existing tables, for instance.) If we see no deadlocks with only 300 people logging into the system over a 24 hour period, we will consider the full implementation (and therefore your solution) 100% successful. Complete source code of all work done is superfluous in the sense that we would be implementing your solution together - you would check our code to make sure it actually implements your solution and we would build extensive test scaffolding ourselves regardless. Complete copyrights to all work purchased.
## Platform
Windows 2000 Server, Macromedia ColdFusion Server 5, Microsoft SQL Server 2000
## Deadline information
Unit testing must begin by May 31st, 2002.