subject
Computers and Technology, 15.05.2021 05:10 kat353

To view an employees projects click on the . The Add Project button inserts a new row into the WORKS_ON table after you enter the Project Number and Hours. Suppose that an EMPLOYEE can work at most a total of 40 hours on all projects they are assigned. Write a trigger called MaxTotalHours for the WORKS_ON table that will generate user defined error message if an attempt is made to assign the employee more than 40 hours. This trigger should be called before an insert to the WORKS_ON table so that the insert fails if the new hours increases the total over 40. The error message should give the number of hours entered, the number currently worked and a statement that it is over 40 hours. The web interface will display the message as shown below:

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 18:30
Which of these options are the correct sequence of actions for content to be copied and pasted? select content, click the copy button, click the paste button, and move the insertion point to where the content needs to be inserted. click the copy button, select the content, move the insertion point to where the content needs to be inserted, and click the paste button. select the content, click the copy button, move the insertion point to where the content needs to be inserted, and click the paste button. select the content, move the insertion point to where the content needs to be inserted, click the copy button, and click the paste button.
Answers: 3
question
Computers and Technology, 23.06.2019 01:30
For a typical middle-income family, what is the estimated cost of raising a child to the age of 18? $145,500 $245,340 $304,340 $455,500
Answers: 2
question
Computers and Technology, 23.06.2019 11:00
In the context of the box model, what is the difference between a margin and a padding? a. a padding lies outside a box border, while a margin lies inside it. b. a padding lies inside a box border, while a margin lies outside it. c. a padding can be adjusted independently, while a margin depends on the size of its box. d. a padding depends on the size of its box, while a margin can be adjusted independently.
Answers: 3
question
Computers and Technology, 23.06.2019 12:00
Using the list, you can select the number of photos that will appear on each slide. a. theme b. frame shape c. pictures in album d. picture layout
Answers: 1
You know the right answer?
To view an employees projects click on the . The Add Project button inserts a new row into the WORKS...
Questions
question
Mathematics, 21.06.2021 17:40
question
Computers and Technology, 21.06.2021 17:40
question
Mathematics, 21.06.2021 17:40
question
Mathematics, 21.06.2021 17:40
Questions on the website: 13722360