CIS 336 STUDY Career Path Begins/cis336study.com CIS 336 STUDY Career Path Begins/cis336study.com | Page 70

during peak operating hours in a production operation (as a
student in a lab exercise, working on your own database, you
may do this at any time) but ideally in hours during which
the business does not normally operate. In cases where
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