Question: In the college database, write an insert trigger than insures that the email of people added to the faculty table is in the standard form
In the college database, write an insert trigger than insures that the email of people added to the faculty table is in the standard form of FirstLast@college.edu, regardless of what value might be used in the insert statement. Create a stored procedure named Faculty_Before_Insert. Then execute an INSERT statement to put yourself into the faculty table. Use bad@bad.bad as your email.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
