Design a relational database schema for this database application.

Step $1$: Show all the functional dependencies that should hold among the attributes.

$$

We have received the following requirements for UVA$-$Wise$$s student enrollment database that is used track students$$ transcripts:

The College tracks each student$$s:

$-$ name $($SNAME$)$

$-$ student number $($SNUM$)$

$-$ student ID$($SID$)$

$-$ current address $($SCADDR$)$

$-$ cell phone $($SCPHONE$)$

$-$ permanent address $($SPADDR$)$

$-$ home phone $($SPPHONE$)$

$-$ birth date $($BDATE$)$

$-$ sex $($SEX$)$

$-$ class $($CLASS$)($freshman$,$sophomore$,...,$graduate$)$

$-$ major department $($MAJORDEPTCODE$)$

$-$ minor department $($MINORDEPTCODE$)($if any$)$

$-$ degree program $($PROG$)($BA$,$BS$,....$MA$$ or $$MS$)$

NOTE:$$ Both SSSN and SNUM have unique values for each student.

Each department is described by:

$-$ Department name $($DEPTNAME$)$

$-$ Department code $($DEPTCODE$)$

$-$ Office number $($DEPTOFFICE$)$

$-$ Office phone $($DEPTPHONE$)$

$-$ College $($DEPTCOLLEGE$)$

NOTE: $$Both Dname and Dcode have unique values for each department.

Each course has a:

$-$ Course name $($CNAME$)$

$-$ Course Description $($CDESC$)$

$-$ Course number $($CNUM$)$

$-$ Number of semester hours $($CREDIT$)$

$-$ Level $($LEVEL$)$

$-$ Course department $($CDEPT$)$

NOTE: The CNUM is unique for each course.

Each section has an:

$-$ Last name for instructor $($INSTUCTORNAME$)$

$-$ Semester $($SEMESTER$)$

$-$ Year $($YEAR$)$

$-$ Section Course $($SECCOURSE$)$

$-$ Section number $($SECNUM$)$

NOTE: The SEC$\_$Num distinguishes different sections of the same course that are taught during the same semester$/$year; its values are $1,2,3,...,$ up to the total number of sections taught during each semester.

A grade record refers to a:

$-$ student number $($SNUM$)$

$-$ particular section $($SECNUM$)$

$-$ grade $($GRADE$)$

$$

Create $3$NF or BCNF schemas.$$

Step $2$:$$ Design relation schemas for the database that are each in $3$NF or BCNF$.$

$-$ Specify the key attributes of each relation.

$-$ Note any unspecified requirements

$-$ Note any assumptions to render the specification complete.