Question: 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

 


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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Heres how you can create the view customersprivateinfo and the trigger customerspa... View full answer

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!