Timedora
Free Practice Quiz Question List

Database Normalization Workflow Online Quiz Questions

Use this free practice quiz with 20 questions to review Database Normalization Workflow, test your knowledge, and prepare for your next test or exam.

20 questions
01
Choose one
1 point

Which action is the best first step in the practical normalization workflow?

  1. A

    Identify the domain’s entities and relationships without inferring business rules from a small sample alone.

  2. B

    Remove every duplicated fact before identifying keys or dependencies.

  3. C

    Review query performance before deciding what facts determine other facts.

  4. D

    Denormalize the relations before defining their keys.

02
Choose all
1 point

Select all checks or practices that support a sound decomposition in the normalization workflow.

  1. A

    Check that joining the new relations reconstructs the original information without losing facts or creating spurious rows.

  2. B

    Check that important dependencies can be enforced by examining individual relations rather than requiring complex joins.

  3. C

    Accept any decomposition that reduces redundancy, even if information is lost.

  4. D

    Use appropriate keys and constraints to enforce key and reference rules.

03
True or false
1 point

A decomposition preserves dependencies when important dependencies can still be enforced by checking individual relations rather than requiring complex joins.

  1. A

    True

  2. B

    False

04
Written response
1 point

In the normalization workflow, removing partial dependencies of non-key attributes on a composite key is done to reach which normal form?

05
Fill in the blank
1 point

For a composite key, remove partial dependencies of non-key attributes to reach .

06
Open ended
1 point

After decomposing a relation, how should you check that the decomposition is lossless and preserves important dependencies?

07
Choose one
1 point

Which approach to denormalization matches the workflow?

  1. A

    Denormalize whenever any duplicate fact is found, without documenting it.

  2. B

    Avoid reviewing queries and workload because normalization alone determines performance.

  3. C

    Consider deliberate denormalization if performance later justifies it, and document duplicated facts and how they will be kept consistent.

  4. D

    Remove constraints whenever denormalization is used.

08
Choose all
1 point

Select all practices that belong in the normalization workflow.

  1. A

    List candidate keys and functional dependencies, and ask what determines each fact.

  2. B

    Infer all business rules from a small sample of rows.

  3. C

    Check for partial dependencies on composite keys when working toward 2NF.

  4. D

    Check whether non-key attributes determine other non-key facts when working toward 3NF.

  5. E

    Treat reduced redundancy as sufficient even if a decomposition loses information.

09
True or false
1 point

A small sample of rows alone is enough to establish the domain’s business rules during normalization.

  1. A

    True

  2. B

    False

10
Written response
1 point

When listing attributes and candidate keys, what type of dependencies should you also identify to determine what establishes each fact?

11
Fill in the blank
1 point

In a normalization workflow, removing partial dependencies from a relation with a composite key brings it to . Separating facts determined by other non-key attributes brings it to .

12
Choose one
1 point

Which sequence best follows the normalization workflow when preparing to check a relation for 2NF?

  1. A

    Check whether non-key attributes determine other non-key facts, then define keys.

  2. B

    Address repeating groups, multi-valued fields, and unclear row identity; define keys before checking partial dependencies.

  3. C

    Review workload and denormalize before identifying candidate keys.

  4. D

    Check lossless joins before listing attributes and functional dependencies.

13
True or false
1 point

When identifying domain entities and relationships, it is safe to infer the domain’s business rules from a small sample alone.

  1. A

    True

  2. B

    False

14
Written response
1 point

What is the name of the decomposition property that ensures joining the new relations reconstructs the original information without losing facts or creating spurious rows?

15
Choose one
1 point

A decomposition reduces redundancy. What should you check before concluding that it is a good design?

  1. A

    Choose the decomposition that produces the fewest relations, even if some original facts cannot be reconstructed.

  2. B

    Choose the decomposition that removes redundancy, even if important rules require complex joins to enforce.

  3. C

    Check that the decomposition is lossless, preserves important dependencies, and supports appropriate constraint enforcement.

  4. D

    Choose the decomposition with the most foreign keys, regardless of the information it preserves.

16
True or false
1 point

If performance needs later justify deliberate denormalization, document duplicated facts and provide a reliable way to keep them consistent.

  1. A

    True

  2. B

    False

17
Written response
1 point

What is the term for a non-key attribute depending on only part of a composite key?

18
Choose one
1 point

Which approach best begins a normalization workflow?

  1. A

    Identify entities and relationships, then list attributes, candidate keys, and functional dependencies.

  2. B

    Choose a decomposition from a small sample before identifying domain rules.

  3. C

    Review query performance before determining what establishes each fact.

  4. D

    Add foreign keys before identifying entities, relationships, or candidate keys.

19
Written response
1 point

What is the name of the decomposition property that allows important dependencies to be enforced by checking individual relations rather than requiring complex joins?

20
Choose one
1 point

Which checks and action are part of the workflow for reaching 1NF?

  1. A

    Check whether non-key attributes determine other non-key facts.

  2. B

    Check for repeating groups, multi-valued fields, and unclear row identity; define keys.

  3. C

    Review real queries and workload to decide whether denormalization is useful.

  4. D

    Verify that important dependencies can be checked in individual relations.