Question: Implement and comprehensively test a statement trigger that enforces the following data access constraint. A user is allowed to insert a row into a relational
Implement and comprehensively test a statement trigger that enforces the following data access constraint. A user is allowed to insert a row into a relational table Employee only one time per day. When ready, create an SQL script solutionsql with CREATE OR REPLACE TRIGGER statement and with SQL statements used for implementation of the constraint and for comprehensive testing of the trigger. A comprehensive test must consist of at least two cases: one when insertion is accepted and one when insertion is rejected. Hints: SYSDATE function returns a value of type DATE that contains the current year, month, day, time, hour, and second. Time measurement with a precision of up to a single second is acceptable. A value of an expression SYSDATE is tomorrow the same time as now. You are allowed to change the structures of a sample database. Deliverables Submit a file solutionOutput.lst with a report from processing of SQL script solutionsql The report MUST have no errors other than reported by a trigger and the report MUST list all SQL statements processed. The report MUST include ONLY SQL statements and control statements that implement the specifications of Task and NO OTHER statements. Remember to set ECHO option of SQLPlus to ON
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
