CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 68

high-demand environment is an advanced topic, study of
which is outside the scope of this course. Use the outline
below to construct your script. Show all commands in
your answer sheet along with the output of the commands.
lock table customers write;
set foreign_key_checks = 0;
– Replace this comment with your ALTER TABLE
command to add the auto_increment feature to the PK
field
set foreign_key_checks = 1;
unlock tables;
–statements to insert two rows into the table
–verify auto_increment with a select statement
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: