Microsoft
98-361 · Question #368
98-361 Question #368: Real Exam Question with Answer & Explanation
The correct answer is A. None of the columns in the table should have multiple values in the same row of data. B. All non-key columns are functionally dependent on the entire primary key. D. Non-key attributes don't share any functional dependency.. See the full explanation below for the reasoning.
Question
As you design a database for your company, you review the normalization rules for the database tables. You need to ensure that your table design meets the requirements for the third normal form. Which of the following statements must be true for your tables? (Choose all that apply.)
Options
- ANone of the columns in the table should have multiple values in the same row of data.
- BAll non-key columns are functionally dependent on the entire primary key.
- CAt least one non-key column is functionally dependent on the entire primary key.
- DNon-key attributes don't share any functional dependency.
- ENon-key attributes share functional dependency.
Community Discussion
No community discussion yet for this question.