Create a trigger in your todo database that adds a new line


Question: 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.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Create a trigger in your todo database that adds a new line
Reference No:- TGS02805608

Expected delivery within 24 Hours