0 0 votes https://gateoverflow.in/968/gate2003-85 How in the above question the functional dependency (date of birth -> age) is a partial functional dependency. (As told in the selected answer for this question) Because according to navathe the definition of partial functional dependency is A functional dependency X -> Y is a partial dependency if some attribute A belongs to X can be removed from X and the dependency still holds; that is, for some A belongs to X (X - {A}) -> Y. Databases databases + – Kushagra Chatterjee 1.0k views answer comment Share Follow Print See all 6 Comments 6 6 Comments reply Kushagra Chatterjee commented Apr 12, 2019 reply Follow flag Arjun sir please clarify my doubt. 0 0 replyShare srestha commented Apr 13, 2019 reply Follow flag DOB is not a total key Here keys are (Roll_Number, Course_Number,DOB) or (Name, Course_No, DOB) So, DOB is forming Partial dependency for any key attribute 1 1 replyShare Subarna Das commented Apr 17, 2019 reply Follow flag @Kushagra Chatterjee, $Age$ is a Non-Prime Attribute here. Candidate keys are : $\{ \text{Date_Of_Birth, Name\} } \& \text{ \{Date_Of_Birth, Roll_number}\}$ Now, $Age$ can be determined by the proper subset of both the candidate keys. So, here partial dependency holds. And hence, the relation is in $1NF$. $\color{teal}{\text{Suggested Read: }} $ https://gatecse.in/demystifying-database-normalization/ 0 0 replyShare Kushagra Chatterjee commented Apr 18, 2019 i edited by Kushagra Chatterjee Apr 18, 2019 reply Follow flag @Subarna Das I dont have any problem regarding the schema is in 1nf or not I know that it is in 1nf. My problem is that in the answer to this question it is written that the dependency (DOB -> age) is a partial dependency. But if you see the definition given in navathe (written in the question) then (DOB-> age) is not a partial functional dependency. Rather I think {DOB, NAME} -> age is a partial functional dependency. 0 0 replyShare srestha commented Apr 18, 2019 reply Follow flag @Kushagra Chatterjee u r right. moreover, Here keys are (Roll_Number, Course_Number,DOB) or (Name, Course_No, DOB) right?? 0 0 replyShare Subarna Das commented Apr 18, 2019 reply Follow flag @Kushagra Chatterjee, for this FD $\color{red}{\text{\{ Date_Of_Birth} \to \text{Age\}}}$, all the candidate keys are holding partial functional dependency. So, $\color{violet}{\text{ ( Date_Of_Birth, Name ) }} \& \color{purple}{\text{ ( Date_Of_Birth, Roll_number)}}$ -- both of these are partial functional dependency as $\color{blue}{\text{Date_Of_Birth}}$ is in both of the keys. 0 0 replyShare Please log in or register to add a comment.