itss 4300 quizlet 2

Question 1

is defined as a key that is used strictly for data retrieval purposes.

Answer 1

secondary key

Question 2

is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype.

Answer 2

Specialization

Question 3

means that one entity occurrence requires a corresponding entity occurrence in a particular relationship.
EX: (A person cannot be an employee without being assigned to a company’s division.)

Answer 3

Mandatory participation

Question 4

is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.

Inheritance
Functional Dependency
Generalization
Specialization

Answer 4

Generalization

Question 5

is the condition in which each row (entity instance) in the table has its own unique identity.

Answer 5

entity integrity

Question 6

a join that yields all the rows in the left table, including those that have no matching values in the other table.

Answer 6

left outer join

Question 7

does not require a value and can be left empty

Answer 7

optional attribute

Question 8

attribute whose value is calculated from other attributes

Answer 8

derived attribute

Question 9

Foreign keys are used to ensure ____.

Answer 9

referential integrity