Please help! Database

Normalization Exercise 4 Consider the following relation: STUDENT(studentID, SFname, SLname, CourselD, CourseName, OfferDept, OfferDeptTel, Grade) refer to the student's first and last name respectively, OfferDept refers to the SPname and SLname department that offers the course, and OfferDeptTel refers to the offering department telephone number. Suppose the following functional dependencies exist: FD1: FD2: FD3: FD4: studentID SFnane , SLname atudentID, Cours IDGrade CourseID CourseName, offerDept offerDept OfferDeptTel A sample STUDENT table is shown as follows: StudentID SFname SLname CourseID | CourseName 100 Offerlept OfferDeptTel Grade CS Mike Mike Mary Java CH Ethics 1501-1112222 CS111 CS110 CS110 CSI11 CS CS Smith Doe Doe Wang EE120 Circuits and System EE 100 101 140 140 142 142 501-1112222 B 501-1112222 A 501-2223333B 501-2223333A 301-2223333 501-1112222 B Dan Wang EE130 Brown EE130 Brown CSI12 Intro to DSP Intro to DSIP Java Eric Eric CS 1) What are the non-prime attributes? 2) Which functional dependencies are partial functional dependencies? 3) Which functional dependencies are full functional dependencies? 4) Which functional dependencies are transitive functional dependencies