quiz 4

Question 1

Which term defines the smallest number of permitted records in a related entity?

Answer 1

Minimum cardinality

Question 2

Which of the following is a term for the number of permitted records in a related entity?

Answer 2

Cardinality

Question 3

Which of the following is a term for an entity that stores values to help enforce consistency in database entry?

Answer 3

Lookup

Question 4

Which of the following best defines the function of a linking entity?

Answer 4

An entity used to resolve a many to many relationship into two one to many relationships

Question 5

Which term defines the highest number of permitted records in a related entity?

Answer 5

Maximum cardinality

Question 6

Which of the following is the term for a key that is composed of an arbitrary or random value?

Answer 6

Surrogate key

Question 7

What is a weak entity?

Answer 7

it is an entity that cannot be uniquely identified by its attributes alone; therefore, it must use a foreign key in conjunction with its attributes to create a primary key. The foreign key is typically a primary key of an entity it is related to.