Module/Week 5 Homework Assignment Chapter 7 Homework PART 1: (1 point) Given the following table, identify the functional dependencies: StdSSN StdCity StdClass OfferNo OffTerm OffYear EnrGrade CourseNo CrsDesc S1 SEATTLE JUN 01 SPRIN
Module/Week 5 Homework Assignment
Chapter 7 Homework
PART 1: (1 point)
Given the following table, identify the functional dependencies:
StdSSN
|
StdCity
|
StdClass
|
OfferNo
|
OffTerm
|
OffYear
|
EnrGrade
|
CourseNo
|
CrsDesc
|
S1
|
SEATTLE
|
JUN
|
01
|
SPRING
|
2009
|
3.5
|
C1
|
DB
|
S1
|
SEATTLE
|
JUN
|
02
|
FALL
|
2009
|
3.3
|
C2
|
VB
|
S2
|
DENVER
|
JUN
|
03
|
SPRING
|
2010
|
3.1
|
C3
|
OO
|
S2
|
DENVER
|
JUN
|
02
|
FALL
|
2009
|
3.4
|
C2
|
VB
|
No comments:
Post a Comment