Module 7 - Normalization Flashcards

1
Q

What is an independent entity?

A

An entity that can exist without a parent entity (Identifier is created from own attributes)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a dependent entity?

A

An entity that cannot exist without a parent entity (Identifier is consists of at least one attribute from parent entity)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is normalization?

A

A method to create a consistent model by reducing redundancy and inconsistent data. Think of converting repetition into a value that spans across multiple rows in a table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How can you tell if a table is in first normal form? (1NF)

A

If it does not contain attributes that have multiple values for a single instance of the entity (i.e. the instance of an entity does not span multiple rows)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is second normal form?

A

No partial dependencies, repeating groups of attributes are reduced by breaking up a compound identifier to create two more entities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is third normal form?

A

No transient dependencies, attributes that depend on another attribute are removed and placed in a new entity with the parent attribute as the identifier.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are three ways to validate an ERD?

A

Normalization
Design guidelines
Balancing ERDs with DFDs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is partial dependency of an attribute?

A

When non-identifier attributes are dependent on only part of a compound identifier. This means you should split the compound identifier into two separate entities. Carry the dependent attribute over to the new entity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a transitive dependency of an attribute?

A

When an attribute depends on a non-identifier attribute. This suggests that the dependent attribute should be in another entity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is third normal form (3NF) and how can we create it?

A

Third normal form is the result of partial and transitive dependencies being resolved. We resolve transitive dependencies by creating a new entity and transferring the transitive dependency. NOTE: The parent attribute will remain in the original and be an identifier for the new table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly