General discussion

Locked

Normalization of Relational Databases

By Aldanatech ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by john_wills In reply to Normalization of Relation ...

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.

Collapse -

by Aldanatech In reply to

Poster rated this answer.

Collapse -

by InletGroveHS In reply to Normalization of Relation ...

If you don't have it already, you should get this book.

"Database Design for Mere Mortals"
By: Michael J. Hernandez

http://www.amazon.com/exec/obidos/tg/detail/-/0201694719/002-7103366-2568830?v=glance


It's an excellent resource, I had a relational database design class based off of it.

Collapse -

by Aldanatech In reply to

Poster rated this answer.

Collapse -

by Aldanatech In reply to Normalization of Relation ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums