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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!