CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 72

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.