Partial dependency occurs when a non-primary attribute is functionally dependent on part of a composite primary key, rather than on the whole key, leading to redundancy.