ALTER VIEW student_directory(ID, Name, Cell_Telephone, Home_Telephone) 
AS SELECT student_id, 
CONCAT(name_first, SPACE(1), name_last), 
phone_dorm, phone_home
FROM students;