View the step-by-step solution to:

Given the following table schema, write query to separate prerequisites from courses:

屏幕快照 2018-08-02 08.36.29 PM.png


1.Given the following table schema, write query to separate prerequisites from courses:

CoursePrerequisites(courseID, prerequisiteCourseID, prerequisiteCourseName)

PK(courseID, prerequisiteCourseID)

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.

屏幕快照 2018-08-02 08.36.29 PM.png

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question