Web Development

Ask something
Discussion Locked

Normalization of Relational Databases

0 helpful
5 replies

by aldanatech

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

5 replies

by john_wills

Each student has only one home city, so you shuld have a table like this
S1|SEATTLE
S2|BOTHELL
and another like the one you have but without the city.

This discussion is closed to new replies.