Write Database Triggers for SQL server
Budget: $30 – $250 USD
Write Database Triggers for SQL server.
Please refer the attached Image for Database Diagram. We will give you database backup before you actually stat working.
Database Triggers and work requirements-
1) Each time Formula:CalculationCount is updated (by 1)-
a) Update UserInfo:CalculationsCount_List, CalculationsCount_Create, CalculatorCount_Verify, CalculationsCount_Verify
b) Update Node:TotalCalculationCount [Iteratively]
2) Each time Formula Inserted/ Deleted
a) Update 1) above.
b) Node:FormulasUnderCount, TotalFormulasUnderCount [Iteratively]
3) Each time a Node Inserterd / Deleted
a) Update Node: NodesUnderCount, TotalNodesUnderCount [Iteratively]
4) Buffer - A couple of more if and as required.
5) Also, Write required SQL insert/update/delete Queries as test cases to demo working of above triggers!
Please bid IFF you have experience with writing Database Triggers for MS SQL Server.
Please refer the attached Image for Database Diagram. We will give you database backup before you actually stat working.
Database Triggers and work requirements-
1) Each time Formula:CalculationCount is updated (by 1)-
a) Update UserInfo:CalculationsCount_List, CalculationsCount_Create, CalculatorCount_Verify, CalculationsCount_Verify
b) Update Node:TotalCalculationCount [Iteratively]
2) Each time Formula Inserted/ Deleted
a) Update 1) above.
b) Node:FormulasUnderCount, TotalFormulasUnderCount [Iteratively]
3) Each time a Node Inserterd / Deleted
a) Update Node: NodesUnderCount, TotalNodesUnderCount [Iteratively]
4) Buffer - A couple of more if and as required.
5) Also, Write required SQL insert/update/delete Queries as test cases to demo working of above triggers!
Please bid IFF you have experience with writing Database Triggers for MS SQL Server.