I kind of new in Database development and I can’t figure this one out. The following is a sample university database table:
StdSSN | StdCity | StdClass | OfferNo | OffTerm | OffYear | EnrGrade | CourseNo | CrsDesc
S1 | SEATTLE | JUN | O1 | FALL | 2003 | 3.5 | C1 | DB
S1 | SEATTLE | JUN | O2 | FALL | 2003 | 3.3 | C2 | VB
S2 | BOTHELL | JUN | O3 | WINT | 2003 | 3.1 | C3 | OO
S2 | BOTHELL | JUN | O2 | FALL | 2003 | 3.4 | C2 | VB
1) I need to list the funcional dependencies (FD) with the column “StdCity” as the determinant that are “not” true due to the sample data. With each FD that does not hold, can you help me find the sample data that violate it. I know that it takes two rows to demonstrate a violation of an FD, but I still can’t find it.
2) From the same table, can you help me list FDs with the column “StdCity” as the determinant that the sample data do not violate. For each FD, can you help me add one or more sample rows and then identify the sample data that violate the FD? It takes two rows to demonstrate a violation of an FD.