Chapter 6-Logical Database Design

Question 1

NO CHECK is the same as…

Answer 1

RESTRICT

Question 2

Entity integrity

Answer 2

Ensures that all primary key attributes are not null.

Question 3

Enterprise Constraint

Answer 3

Ensuring that all business rules concerning database are adhered to.

Question 4

NO CHECK

Answer 4

When the parent key is deleted, does not check that referential integrity is maintained.

Question 5

SET DEFAULT

Answer 5

When the parent key is deleted, the child keys will all be set to a default value.

Question 6

SET NULL

Answer 6

When the parent key is deleted, all referenced child keys are automatically set to null.

Question 7

CASCADE

Answer 7

If the parent key is deleted, any child keys that are referenced by the parent key are automatically deleted. If the child key is a parent key in another relationship, then the deletion will be applied to the child keys in a cascading manner.

Question 8

NO ACTION

Answer 8

Prevents a record from being deleted if any child relations reference the parent key.

Question 9

Referential Integrity

Answer 9

Ensures that all foreign keys reference an existing parent key in a parent relation.

Question 10

Domain Constraints

Answer 10

A set of permissible values for one or more attributes.

Question 11

Intermediate Entity

Answer 11

An entity created as a result of the decomposition of a relation while resolving a m:n relationship.

Question 12

Necessary Data

Answer 12

Any attributes that cannot be left blank or null under any circumstances.