itss 4300 exam #1 (quiz 2)

Question 1

A ___ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Answer 1

weak

Question 2

A relationship is an association between___.

Answer 2

entities

Question 3

An attribute that is part of a key is known as a(n) ___ attribute.

Answer 3

prime

Question 4

Data warehouse routinely uses ___ structures in its complex, multilevel, multisource data environment.

Answer 4

2NF

Question 5

Normalization is a process that is used for changing attributes to entities. (T/F)

Answer 5

F

Question 6

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____.

Answer 6

1NF.

Question 7

some very specialized applications may require normalization beyond the ___.

Answer 7

4NF

Question 8

Why do we need normalization?

Answer 8

To remove redundant data

Question 9

The term__ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.

Answer 9

database system