Looking for something else?

Not the answer you are looking for? Search for more explanations.

## More answers

Looking for something else?

Not the answer you are looking for? Search for more explanations.

- anonymous

Why does this fields have a transitive functional dependency.?

At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga.
Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus.
Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.

Get our expert's

answer on brainly

SEE EXPERT ANSWER

Get your **free** account and access **expert** answers to this

and **thousands** of other questions.

Get your **free** account and access **expert** answers to this and **thousands** of other questions

- anonymous

Why does this fields have a transitive functional dependency.?

- schrodinger

See more answers at brainly.com

Get this expert

answer on brainly

SEE EXPERT ANSWER

Get your **free** account and access **expert** answers to this

and **thousands** of other questions

- anonymous

- anonymous

I mean the genre, rented_by, due_date and rating fields.

- anonymous

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 non-key columns is related to any of the other non-key columns".

Looking for something else?

Not the answer you are looking for? Search for more explanations.

- anonymous

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.

- anonymous

That makes sense, thank you =).

- anonymous

If the due_date is a function of genre or rating_fields, then I have a functional dependency. But what about the "transitive" charactheristic?

- anonymous

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.

- anonymous

Ok. thanks! bmp

- anonymous

No problem, mate.

- anonymous

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.

Looking for something else?

Not the answer you are looking for? Search for more explanations.