Suppose in addition to the requirements specified you must store the number of the department in which the student is majoring. Indicate the changes this would cause in the design in the following two situations:. A. The student must be assigned an advisor who is in the department in which the student is majoring. B. The student's advisor does not necessarily have to be in the department in which the student is majoring.