Assume the same scenario as that given in Question 13 but replace CourseNum and Description with Advisor-

Question:

Assume the same scenario as that given in Question 13 but replace CourseNum and Description with Advisor- Num, LastName, and FirstName as shown. Advisor refers to the advisor responsible for the activity. One advisor can be responsible for many activities but each activity has only one advisor.

Student (StudentNum, StudentName, ActivityNum, ActivityName, AdvisorNum, LastName, FirstName)