Consider the following RES$\_$APPT table designed to hold details of graduate student research

appointments in an IE department.

Res$\_$Appt $($StuID$,$ StuName, ResAccNum, StartDate, EndDate, SalCode, EMailID, FTEPercent,

MoRate$\}.$

The functional dependencies in the Res$\_$Appt table are

FD$1$: StuID $->>$ StuName, EMailID

FD$2$: StuID $+$ ResAccNum $->>$ StartDate, EndDate, SalCode

FD$3$: SalCode $->>$ FTEPercent, MoRate,

a$)$ Determine the primary key of the Res$\_$Appt relation.

b$)$ Decompose Res$\_$Appt relation into $2$NF$,$ and then into $3$NF relations. Clearly identify the

primary key for each of the newly formed relations.

c$)$ Using the $3$NF relations, construct an ER diagram. Clearly state any assumptions made.