Creation should include
differentiating between a view and a complex view
determining when data in a view can be updated
writing a trigger that will update the tables that are used to create a view INSTEAD OF the present view.