nerdexam
Microsoft

98-361 · Question #116

This question requires that you evaluate the underlined text to determine if it is correct. A table whose attributes depend only on the primary key must be at least second normal form. Select the…

The correct answer is A. No change is needed. 2nd Normal Form Definition A database is in second normal form if it satisfies the following conditions: It is in first normal form All non-key attributes are fully functional dependent on the primary key

Understanding Databases

Question

This question requires that you evaluate the underlined text to determine if it is correct. A table whose attributes depend only on the primary key must be at least second normal form. Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed'' if the underlined text makes the statement correct.

Options

  • ANo change is needed
  • BFirst
  • CThird
  • Dfourth

How the community answered

(43 responses)
  • A
    74% (32)
  • B
    5% (2)
  • C
    14% (6)
  • D
    7% (3)

Explanation

2nd Normal Form Definition A database is in second normal form if it satisfies the following conditions: It is in first normal form All non-key attributes are fully functional dependent on the primary key

Topics

#database normalization#third normal form#primary key#functional dependency

Community Discussion

No community discussion yet for this question.

Full 98-361 Practice