all views now return the desired results or perform the desired db operation