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

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.
3. The Senior Customer Service Manager has requested
the ability to create a report at any time that will show
shipped orders that took some specified number of days to
fulfill.
a. Create a view named SHIPPING_TIME that lists only
customer_first_name, customer_last_name, order_date,
shipped_date, and the calculated field days_to_fulfill (use
the DATEDIFF function) showing the number of days
between when the customer placed the order and when it
was shipped. Show the data from this view.
Now let‟s do some queries by adding sorting and filters
USING THIS VIEW, WITHOUT CHANGING IT.
b. Use the view to display the data sorted by highest to
lowest days to ship