Timedora
Free Online Flashcard Deck

Database Normalization Free Online Flashcards

Study Database Normalization with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.

12 cards
01
Front

What are the main steps in a normalization workflow?

Back

Identify domain rules, keys, and functional dependencies; check 1NF, 2NF, and 3NF; then verify decomposition properties and constraint enforcement. Review workload before considering deliberate denormalization.

02
Front

What does 1NF require of each row-column position?

Back

A relation is in 1NF when each row-column position holds one value from its relevant domain, not a repeating group such as a list in one cell.

03
Front

What is the key requirement for 2NF?

Back

A relation must be in 1NF, and every non-key attribute must depend on the whole candidate key, not merely part of a composite key.

04
Front

How do superkeys, candidate keys, and primary keys differ?

Back

A superkey uniquely identifies each row; a candidate key is a minimal superkey; a primary key is the candidate key chosen to identify rows. A key can combine attributes.

05
Front

What formal condition must each nontrivial dependency satisfy for 3NF?

Back

A relation must be in 2NF and satisfy the 3NF condition: for each nontrivial dependency, the determinant is a superkey or the dependent attribute is prime.

06
Front

What must be true of every determinant in BCNF?

Back

For every nontrivial functional dependency, its determinant must be a superkey. BCNF is stricter than 3NF, but a BCNF decomposition may not preserve every dependency.

07
Front

What makes a decomposition lossless?

Back

A lossless decomposition lets joins on shared keys reconstruct the original information without losing facts or creating spurious rows.

08
Front

What does a functional dependency X→YX \to Y mean?

Back

For a functional dependency, any two rows that agree on attributes X must also agree on attributes Y. It expresses a rule about the data’s meaning.

09
Front

How does normalization help prevent database anomalies?

Back

Normalization stores each fact in an appropriate place, reducing unnecessary duplication and helping prevent insertion, update, and deletion anomalies. It does not eliminate all duplication or replace constraints.

10
Front

How should a repeating list in one cell be represented for 1NF?

Back

Represent repeating items as separate rows or in a related table. Whether something counts as one value depends on the application and how its parts are managed.

11
Front

When is 2NF automatically satisfied with respect to candidate keys?

Back

A relation whose candidate keys each consist of one attribute automatically satisfies 2NF, provided the relation meets the normal-form requirements.

12
Front

What establishes a functional dependency: domain meaning or a sample pattern?

Back

The dependency must follow from the meaning of the data. A pattern appearing in a sample alone does not establish a functional dependency.