- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Partial Dependency in DBMS
What is Partial Dependency?
Partial Dependency occurs when a non-prime attribute is functionally dependent on part of a candidate key.
The 2nd Normal Form (2NF) eliminates the Partial Dependency.
Let us see an example −
In the above table, we have partial dependency; let us see how −
The prime key attributes are StudentID and ProjectNo, and
|StudentID = Unique ID of the student|
StudentName = Name of the student
ProjectNo = Unique ID of the project
ProjectName = Name of the project
As stated, the non-prime attributes i.e. StudentName and ProjectName should be functionally dependent on part of a candidate key, to be Partial Dependent.
The StudentName can be determined by StudentID, which makes the relation Partial Dependent.
The ProjectName can be determined by ProjectNo, which makes the relation Partial Dependent.
Therefore, the <StudentProject> relation violates the 2NF in Normalization and is considered a bad database design.
To remove Partial Dependency and violation on 2NF, decompose the tables −
Now the relation is in 2nd Normal form of Database Normalization.
- Functional dependency in DBMS
- Transitive dependency in DBMS
- Multivalued dependency in DBMS
- Join dependency in DBMS
- Fully-functional dependency in DBMS
- Explain join dependency in DBMS
- What is functional dependency and transitive dependency (DBMS)?
- Explain about partial and fully functional dependency
- What is Multivalued Dependency (DBMS)?
- What is functional dependency in DBMS?
- What is Transitive dependency in DBMS?
- What is multivalued dependency in DBMS?
- Dependency Injection in C#
- Partial Functions in Python?
- Explain dependency injection in C#