itss 4300 exam #1 (quizlet 3)

Question 1

Since a partial dependency can exist only if a table’s primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF. (T/F)

Answer 1

T

Question 2

___ provide a description of the data characteristics and the set of relationships that link the data found within the database.

Answer 2

Metadata

Question 3

The database structure is a DBMS is stored as a ___.

Answer 3

collection of files.

Question 4

A database is an organized collection of __ related data.

Answer 4

logically

Question 5

In the __ model, the basic logical structure is represented as an upside-down tree.

Answer 5

Hierarchical.

Question 6

Which model implements the primary key?

Answer 6

Physical model

Question 7

The entity relationship diagram (ERD) represents the___ database as viewed by the end user.

Answer 7

conceptual

Question 8

If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have ___ based on this composite candidate key even when the primary key chosen in a single attribute.

Answer 8

Partial dependencies.

Question 9

Requiring a CustomerID to exist in a Primary table before it can exist in a foreign table is an example of:

Answer 9

referential integrity.