1.Given the following table schema, write query to separate prerequisites from courses:
CoursePrerequisites(courseID, prerequisiteCourseID, prerequisiteCourseName)
FK(courseID) -> Courses(courseID)
FK(prerequisiteCourseID) -> Courses(courseID)
2. Assuming life goes from bad to worse and Management Studio crashes each time you start it. Write the SQL command to remove the now unnecessary columns from Courses.