Assistance understanding Functional Dependencies & Anomalies?
I'm working through an old Database book of mine to get a better grasp on
Database concepts. I read through a chapter on Functional Dependencies and
how to normalize the database (a couple times...) but one of the chapter
review questions has me particularly stumped:
Consider the relation: PERSON_2 (Name, Sibling, ShoeSize, Hobby)
Assume that the following functional dependencies exist:
`Name->->Sibling`
`Name->ShoeSize`
`Name->->Hobby`
Describe deletion, modification, and insertion anomalies for the relation.
My thinking goes along like this:
INSERTION: ???
MODIFICATION: Since 'Name' has not been shown as a Primary Key, if you
modified records where 'Name' = 'John' and you had 2 or more Johns in the
table (thinking older times with large families) then each one would then
be modified.
DELETION: Same as Modification?
I seem to be having a lot of difficulty wrapping my head around this kind
of thinking and understanding the idea. Could anyone be of assistance?
No comments:
Post a Comment