Got Homework?
Connect with other students for help. It's a free community.
Here's the question you clicked on:
 0 viewing
Nodata
Group Title
Why does this fields have a transitive functional dependency.?
 2 years ago
 2 years ago
Nodata Group Title
Why does this fields have a transitive functional dependency.?
 2 years ago
 2 years ago

This Question is Closed

Nodata Group TitleBest ResponseYou've already chosen the best response.1
I mean the genre, rented_by, due_date and rating fields.
 2 years ago

Nodata Group TitleBest ResponseYou've already chosen the best response.1
I'm confused about the meaning of that term "transitive functional depedency". In the book states that I have a transitive functional dependency when: "any of the nonkey columns is related to any of the other nonkey columns".
 2 years ago

bmp Group TitleBest ResponseYou've already chosen the best response.2
I assume that it's because they are related fields somehow, i.e., due_date could be a function of rating fields and the genre, and even of rented_by. A blockbuster movie would be generally be returned earlier than, say, a 60's French cult movie. It's a strange term nevertheless, so wait for a second opinion on this.
 2 years ago

Nodata Group TitleBest ResponseYou've already chosen the best response.1
That makes sense, thank you =).
 2 years ago

Nodata Group TitleBest ResponseYou've already chosen the best response.1
If the due_date is a function of genre or rating_fields, then I have a functional dependency. But what about the "transitive" charactheristic?
 2 years ago

bmp Group TitleBest ResponseYou've already chosen the best response.2
That very likely has mathematical foundation in the fact that if a is related to b and b is related to c, then a is related to c. Suppose ratings fields depends on genre. Then, if due_date depends on rating fields, due_date also depends on the genre, albeit indirectly.
 2 years ago

Nodata Group TitleBest ResponseYou've already chosen the best response.1
Ok. thanks! bmp
 2 years ago

bmp Group TitleBest ResponseYou've already chosen the best response.2
No problem, mate.
 2 years ago

nczempin Group TitleBest ResponseYou've already chosen the best response.0
http://en.wikipedia.org/wiki/Transitive_dependency seems to explain it quite well with books and authors. So for your example, the genre can be determined by the movie title; you could put the relation between movie titles and genres in another table (thus removing the genre from this table) and still find out what the genre is. Depending on what a "movie" is (the concept of certain movie or the physical DVD that can be rented) there may also be a transitive dependency on "due date; presumably different copies of a DVD would have different due dates depending on who rented any one of them.
 2 years ago
See more questions >>>
Your question is ready. Sign up for free to start getting answers.
spraguer
(Moderator)
5
→ View Detailed Profile
is replying to Can someone tell me what button the professor is hitting...
23
 Teamwork 19 Teammate
 Problem Solving 19 Hero
 Engagement 19 Mad Hatter
 You have blocked this person.
 ✔ You're a fan Checking fan status...
Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.