fixed assigment view and database