Create a trigger in your todo database

Assignment Help Database Management System

Reference no: EM132011144

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.

Reference no: EM132011144

Questions Cloud

Identify and explain the impact of political issues : Identify and explain the impact of political issues associated with the proposed evaluation.

Explain how a swimmer can have a better time : Using the concept of acceleration, explain how a swimmer can have a better time for a 100-m race in a 25-m pool than in a 100-m pool.

Prepare the journal entry to record the sale : On January 1, 2014, Acker Inc. had the following balance sheet. Prepare the journal entry to record the sale of the available-for-sale securities in 2014

Various steps in the process : Describe in detail which form(s) of energy get converted into which other form(s) during the various steps in the process.

Create a trigger in your todo database : Create a trigger in your ToDo database that adds a new line to an audit table when you add a new task. Using the ToDo database that you created.

Velocity of the 0.300-kg puck after the collision : (a) Determine the velocity of the 0.300-kg puck after the collision. (b) Find the fraction of kinetic energy lost in the collision.

What is the expected return for this two stock portfolio : There is a 22.50% probability of average economy and a 77.50% probability of an above average economy. What is the expected return for this two stock portfolio?

Explore a mental disorder that was not properly controlled : According to the text, mental disorders may be caused organically or via chemical or genetic causes. In either case, if left untreated the cost is usually dire.

Calculate the net income for the firm : Calculate the net income for the firm. If the company paid out $77,000 in cash dividends, calculate the increase to retained earnings

User Account

All Pages