Machine-translated by Google. Questions are authored in English.
Top

Discussion

A relation in this form is free of all modification anomalies.

  • A.First normal form
  • B.
    Second normal form
  • C.Third normal form
  • D.
    Domain/key normal form

Answer: D

Correct answer: Domain/key normal form

Fagin proved that a relation in domain/key normal form has no modification anomalies of any kind, and conversely that any relation free of them is in DK/NF. It is defined by requiring that every constraint on the relation follow from its domain and key definitions alone. The difficulty is that there is no general procedure for putting a relation into it.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.