Instructions For each of the relations below, list the functional dependencies y
ID: 3887254 • Letter: I
Question
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:
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
Explanation / Answer
Functional dependencies for given table are:
StudentID------>StudentEmail,Class,Section,Term,Year,FinalGrade
Year------>Term
Class------>Section
ProfessorEmail,StudentEmail---->ProfessorSupervisorEmail
StudentID,Class------>FinalGrade
The above functional dependencies are based on assumptions of real world. Generally all student details(StudentEmail,Class,Section,Term,Year,FinalGrade) depends on studentID. Term will depend on year. And also class contains sections. Final grade will depend on students and no. of students in that class.