CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 70

round-the-clock, high availability of a database is required,
other approaches may be required. Addressing this problem
in a high-availability, 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