Instructions

For each of the relations below, list the functional dependencies you find. Remember to look past the sample data and think of all possibilities that may occur in a real-world application. If needed, list the assumptions required to make your functional dependencies valid. When listing functional dependencies, make sure to follow the correct notation as outline in the lecture slides.

Question 3

StudentID	StudentEmail	Class	Section	Term	Year	FinalGrade	ProfessorEmail	ProfessorSupervisorEmail
00045875	asmith@unv.edu	MIS 310	002	Fall	2016	A+	dsvancer@unv.edu	bshelton@unv.edu
00003524	bdavis@unv.edu	MIS 431	001	Fall	2016	F	dsvancer@unv.edu	bshelton@unv.edu
00002547	dloades@unv.edu	MIS 210	002	Spring	2014	A-	aboyce@unv.edu	bshelton@unv.edu
00000568	dsanders@unv.edu	MIS 310	002	Fall	2016	C+	adutt@unv.com	rsmith@unv.edu
00021457	bkhan@unv.edu	MIS 431	001	Spring	2016	D	dsvancer@unv.edu	bshelton@unv.edu
00032545	rcortez@unv.edu	MIS 210	002	Fall	2014	A	aboyce@unv.edu	bshelton@unv.edu
00005548	lumanzor@unv.edu	MIS 431	001	Spring	2013	B	dsvancer@unv.edu	bshelton@unv.edu
00003524	bdavis@unv.edu	MIS 431	003	Spring	2017	C-	dsvancer@unv.edu	bshelton@unv.edu
00547814	lharvey@unv.edu	MIS 310	001	Fall	2015	B	adutt@unv.com	rsmith@unv.edu
00684571	wsmeal@unv.edu	MIS 210	001	Fall	2017	C-	wkant@unv.com	jmiller@unv.edu

Functional Dependencies: