Blog

Given: EMPLOYEE (EID, F_NAME, L_NAME, A_ADDRESS) At ABC publ…

Given: EMPLOYEE (EID, F_NAME, L_NAME, A_ADDRESS) At ABC publishing, the editor wants to make sure that each first name begins with an upper case letter and all other letters in lower cases. Write a trigger that will ensure that any first names being entered will meet this requirement. Also, write a statement that will execute this trigger.  Note: You don’t have to write a 100% correct trigger, just write what you know.