Discount for the Season

For All Your Writing Assignments

Create a trigger in your To Do database that adds a new line to an audit table when you add a new task

Database

1.create a trigger in your ToDo database that adds a new line to an audit table when you add a new task.

2.Using the ToDo database that you created, create a stored procedure with a try/catch block to get a detailed list of all completed task for a particular period with period dates entered as parameters.

3. Create and populate the ToDo database with primary and foreign keys and cascading constraints for updates and deletes. Include nulls, defaults (like a timestamp for date the task is created, and auto-incremented primary keys. Include a constraint that prohibits you from entering a completion date before the start date. Submit a .sql file with comments. Use indents for clarity.