CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 71
2 . The Vice President of Marketing for your firm wants the firm ‟ s sales representatives to be able to directly view and edit customer details , but only for the state to which a particular sales representative is assigned . You have suggested that this need can be addressed with a view . For example , a view could be created for one particular state , and user account permissions for accessing that view granted only to sales representatives from that state . The VP has asked you to quickly create a simple proof-of-concept demonstrating how this might work . Complete the following steps :
a . Construct a view on the customers table called CA _ CUSTOMERS that consists of all data about customers that live in California .
b . Display the data using this view to verify that only customers that reside in California are visible .
c . Prove that It is possible to add or update records through this view by updating the record for Karina Lacy to change the spelling of Karina ‟ s last name to Lacie .
d . Display the data using the customer table to verify that the change has been made .
Show all commands in your answer sheet along with the output of the commands .
2 . The Vice President of Marketing for your firm wants the firm ‟ s sales representatives to be able to directly view and edit customer details , but only for the state to which a particular sales representative is assigned . You have suggested that this need can be addressed with a view . For example , a view could be created for one particular state , and user account permissions for accessing that view granted only to sales representatives from that state . The VP has asked you to quickly create a simple proof-of-concept demonstrating how this might work . Complete the following steps :
a . Construct a view on the customers table called CA _ CUSTOMERS that consists of all data about customers that live in California .
b . Display the data using this view to verify that only customers that reside in California are visible .
c . Prove that It is possible to add or update records through this view by updating the record for Karina Lacy to change the spelling of Karina ‟ s last name to Lacie .
d . Display the data using the customer table to verify that the change has been made .
Show all commands in your answer sheet along with the output of the commands .