Database Management Extra 9

Question 1

An entity that displays existence dependence and inherits the primary key of its parent entity. For example, a DEPENDENT requires the existence of an EMPLOYEE.

Answer 1

Weak Entity

Question 2

A relationship in which the primary key of the related entity does not contain a primary key component of the parent entity.

Answer 2

Weak Relationship

Question 3

The transaction property that requires all parts of a transaction to be treated as a single, indivisible, logical unit of work. All parts of a transaction must be completed or the entire transaction is aborted.

Answer 3

Atomicity

Question 4

A special type of third normal form (3NF) in which every determinant is a candidate key. A table in ??? must be in 3NF.

Answer 4

BCNF

Question 5

A process by which a table is changed from a higher-level normal form to a lower-level normal form, usually to increase processing speed. ??? potentially yields data anomalies.

Answer 5

Denormalization

Question 6

A representation of all data dependencies (primary key, partial, or transitive) within a table.

Answer 6

Dependency Diagram

Question 7

Any attribute in a specific row whose value directly determines other values in that row.

Answer 7

Determinant

Question 8

The ??? ??? in the normalization process. It describes a relation depicted in tabular format, with no repeating groups and a primary key identified. All nonkey attributes in the relation are dependent on the primary key.

Answer 8

first stage (1NF)

Question 9

A table is in ??? if it is in 3NF and contains no multiple independent sets of multi-valued dependencies.

Answer 9

4NF

Question 10

The level of detail represented by the values stored in a table’s row. Data stored at its lowest level of ??? is said to be atomic data.

Answer 10

Granularity