Microsoft
98-361 · Question #368
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…
Sign in or unlock 98-361 to reveal the answer and full explanation for question #368. The question stem and answer options stay visible for context.
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.
Unlock 98-361 to see the answer
You've previewed enough free 98-361 questions. Unlock 98-361 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.