Chapter 3 & 5 Terms

Question 1

Primary Key

Answer 1

An attribute or combination of attributes that uniquely identifies any given row.

Question 2

Determination

Answer 2

The state in which knowing one attributes value makes it possible to determine the other attributes value.

Question 3

Functional Dependence

Answer 3

The value of one or more attributes determines the value of one or more other attributes

Question 4

Composite Key

Answer 4

A key thats composed of more than one attribute.

Question 5

Super Key

Answer 5

A key that can uniquely identify any row in the table

Question 6

Flags

Answer 6

A special code to indicate the absence of a value in a space.

Question 7

Homonyms

Answer 7

Similar sounding words with different meanings.

Question 8

Composite Entity

Answer 8

An entity designed to transform a M:N relationship into a 1:M relationship.

Question 9

Design Trap

Answer 9

When a relationship is improperly identified and doesn’t adequately represent the real world.

Question 10

Generalization

Answer 10

The grouping of shared attributers in a specialization hierarchy.

Question 11

Specialization Hierarchy

Answer 11

A top-down approach to identifying lower level specific subtypes from a super type.