Complete the steps indicated below to design a relational database schema for a university database that is used to keep track of students$$ transcripts. Suppose we have the following requirements

$($a$)$ The university keeps track of each student's name $($SNAME$),$ student number $($SNUM$),$ social security number $($SSSN$),$ current address $($SCADDR$)$ and phone $($SCPHONE$),$ permanent address $($SPADDR$)$ and phone $($SPPHONE$),$ birthdate $($BDATE$),$ sex $($SEX$),$ class $($CLASS$)($freshman$,$ sophomore, $...,$ graduate$),$

major department $($MAJORDEPTCODE$),$ minor department $($MINORDEPTCODE$)($if any$),$ and degree program $($PROG$)($B$.$A$.,$ B$.$S$.,...,$ Ph$.$D$.).$ Both ssn and student number have unique values for each student.