b$)$ Define a relational schema for students, student advisors, and advisor departments

$$ Students have StudentID, First Name, Last Name, DOB, Telephone and a reference to their advisor

$$ Advisors have ID$,$ Name, Address, Specialization, and a reference link to their Department

$$ Departments have Name, Chair, College $($identified by Name$)$