Create a VIEW called customers_private_info that contains three columns: customer_id email_address password Create a trigger called...

 

Transcribed Image Text:

Create a VIEW called customers_private_info that contains three columns: customer_id email_address password Create a trigger called customers_password_length_check that verifies the length of the password hash is exactly 40 characters before an update occurs. Be sure to explain in the error that the password hash length must be 40. Provide an UPDATE statement that attempts to update a row in the customers_private_info VIEW to a password of non 40 length to trigger the error message. Create a VIEW called customers_private_info that contains three columns: customer_id email_address password Create a trigger called customers_password_length_check that verifies the length of the password hash is exactly 40 characters before an update occurs. Be sure to explain in the error that the password hash length must be 40. Provide an UPDATE statement that attempts to update a row in the customers_private_info VIEW to a password of non 40 length to trigger the error message.