Skip to main content
Database Administrators

Return to Question

edited tags
Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663
Made post easier to read.
Source Link
edit approved Oct 22, 2016 at 20:00
James Rhoat
edit approved Oct 22, 2016 at 20:00
James Rhoat
  • 1.6k
  • 4
  • 12
  • 32

For 2NF every source I can get hands on says the following: The

The non prime attribute must be fully dependent on a candidate key.

But can the non prime attribute must be fully dependent on a super set of the candidate key  ? I mean can the left side contain an extraneous attribute.

 But can the non prime attribute be dependent on a super set of the candidate key ? I mean can the left side contain an extraneous attribute .

Also  ,please tell me : Is please explain, if it is necessary that all non prime attributes have to be fully dependent upon on any of the candidate keys . Can't one non prime attribute just be dependent on another non prime attribute?

For 2NF every source I can get hands on says the following: The non prime attribute must be fully dependent on a candidate key  .

 But can the non prime attribute be dependent on a super set of the candidate key ? I mean can the left side contain an extraneous attribute .

Also  ,please tell me : Is it necessary that all non prime attributes have to be fully dependent upon on any of the candidate keys . Can't one non prime attribute just be dependent on another non prime attribute?

For 2NF every source I can get hands on says the following:

The non prime attribute must be fully dependent on a candidate key.

But can the non prime attribute be dependent on a super set of the candidate key? I mean can the left side contain an extraneous attribute.

Also, please explain, if it is necessary that all non prime attributes have to be fully dependent upon on any of the candidate keys . Can't one non prime attribute just be dependent on another non prime attribute?

Source Link
Kishan Kumar
Kishan Kumar
  • 123
  • 6

can a table in 2nd normal form have a FD in which the non prime attribute depend on a super key having an extraneous attribute?

For 2NF every source I can get hands on says the following: The non prime attribute must be fully dependent on a candidate key .

 But can the non prime attribute be dependent on a super set of the candidate key ? I mean can the left side contain an extraneous attribute .

Also ,please tell me : Is it necessary that all non prime attributes have to be fully dependent upon on any of the candidate keys . Can't one non prime attribute just be dependent on another non prime attribute?