Make view named SCSP_VIEW using joins. 

Reuse what you did in the FROM clause from your saved Expanded Rollup script

Update your view to return the following columns

StudentID, CourseID, SectionID, ProfessorID, StudentFirstName, StudentLastName, CourseName, SectionName, ProfessorFirstName, ProfessorLastName
 

EXPANDED ROLLUP

FROM DEPARTMENT_CC
INNER JOIN PROGRAM_CC ON  DEPARTMENT_CC.DepartmentID = PROGRAM_CC.DepartmentID
LEFT JOIN PROGRAM_COURSE_INT_CC ON PROGRAM_CC.ProgramID = PROGRAM_COURSE_INT_CC.ProgramID
LEFT JOIN COURSE_CC ON COURSE_CC.CourseID = COURSE_CC.CourseID
LEFT JOIN SECTION_CC ON COURSE_CC.CourseID = SECTION_CC.SectionID
LEFT JOIN STUDENT_CC ON SECTION_CC.SectionID = STUDENT_CC.StudentID
LEFT JOIN SECTION_CC ON Student_cc.StudentID = Section_CC.SectionID
GROUP BY(DEPARTMENT_CC.DepartmentName, PROGRAM_CC.ProgramName, COURSE_CC.CourseID, COURSE_CC.CourseName, SECTION_CC.SectionName);