1,070 views
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.

Please log in or register to answer this question.

Position:
Show:

Related questions

2 2 votes
0 0 answers
507
507 views
Dknights asked Jan 4, 2025
507 views
can someone please explain the working of computation in database transactions is the following computation correct?Time Transaction 1 (T1) Transaction 2 (T2) A (Value) 1...
0 0 votes
1 1 answer
555
555 views
abhinowKatore asked Sep 8, 2022
555 views
If a schedule is not conflict-serializable. Is it serializable?
4 4 votes
4 4 answers
4.4k
4.4k views
Tuhin Dutta asked May 27, 2019
4,359 views
In a relation, if every attribute is prime but key may not be simple then the relation is in ______.A. 1NFB. 2NFC. 3NFD. BCNF
0 0 votes
0 0 answers
1.8k
1.8k views
kd..... asked Apr 30, 2019
1,800 views
Here why does the 5th query select * from employees natural join works_on where PID = 'X' AND PID='Y'; is not workingThe queries are The output are