Suppose that we have the following requirements for a university database that is used to keep track of students$$ transcripts:

Each department is described by a name $($dname$),$ department code $($dcode$),$ office number $($doffice$),$ office phone $($dphone$),$ and college $($dcollege$).$ Both name and code have unique values for each department.

Each course has a course name $($cname$),$ description $($cdesc$),$ course number $($cnum$),$ number of semester hours $($credit$),$ level $($level$),$ and offering department $($cdept$).$ The course number is unique for each course.

Design relation schemas for department and course, get $2$ relation schemas.

First show all the functional dependencies $($FD$)$ that should hold among the attributes. Then design relation schemas for the database that are each in $3$NF or BCNF$.$ Specify the key attributes of each relation.