answersLogoWhite

0

A functional dependency is defined as a constraint between two sets of attributes in a relation from a database.

Given a relation R, a set of attributes X in R is said to functionally determine another attribute Y, also in R, (written X Y) if and only if eachX value is associated with at most oneY value.

A functional dependency X --> Y is full functional dependency if removal of any attribute 'k' from X means that the dependency does not hold any more. Full functional dependency is minimal in size.

Partial Functional Dependency Indicates that if A and B are attributes of a table, B is partially dependent on A if there is some attribute that can be removed from A and yet the dependency still holds.

A key is a set of attributes that uniquely identifies an entire tuple, a function dependency allow us to express constraints that uniquely identify the values of certain attribute.

User Avatar

Wiki User

12y ago

Still curious? Ask our experts.

Chat with our AI personalities

ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi
ReneRene
Change my mind. I dare you.
Chat with Rene
EzraEzra
Faith is not about having all the answers, but learning to ask the right questions.
Chat with Ezra

Add your answer:

Earn +20 pts
Q: What is difference between Partial Functional Dependency and Full Functional Dependency?
Write your answer...
Submit
Still have questions?
magnify glass
imp