DBI202_-_PE_-_02_-_SP_2024_-_Block_3_1893.webp

Question 10:
1
1
Write the trigger named tr_EmployeeSkill to prevent the case that the end user to input or modify invalid Employee skill information (RegDate < StartDate). For example, when we execute the following statement, the result should be as in the following figure (the image is only sample based on entered data)::
testcase1
insert into Emp_Skill(SkillNo, EmpNo, SkillLevel, RegDate) values (3, 1, 5, '2023-06-30')/*YYYY-MM-DD*/
insert into Emp_Skill (SkillNo, EmpNo, SkillLevel, RegDate) values(3, 1, 5, '2023-12-12')
testcase 2
Results
Messages
(No column name)
done
(No column name)
No inserted or update
testcase 1
testcase 2
Picture 10.1
Zoom
+ 100%
Close