Chapter 12

single

A ____ database server architecture is the simplest to build and operate if sufficient network capacity is already available for database access.

partitioned

A ____ database server architecture stores different parts of a database on different servers.

RDBMS (Relational Database management system)

A ________________is the information about the structure of the database, including the tables, the attributes, the keys, etc.

second

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key.

first

A relational database table is in ____ normal form if it has no repeating fields or groups of fields, and hence all rows have the same columns.

third

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.

foreign key

A(n) ____ is a field or set of fields stored in one table that also exists as a primary key in another table.

primary key

A(n) ____ is a field or set of fields used to uniquely identify each row

rows

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.

table

Each class on a class diagram is represented by a(n) ____ in a relational database.

primary key

Every table in a relational database must have a

tuple

In a relational database, a row can be referred to as a(n) ____.

End-user query processor Application program interface Administrative interface

List three typical database management system (DBMS) functions?

foreign keys

One-to-many and many-to-many relationships are both represented by __________ in a relational database.

external activity.

The primary purpose of integrity controls is to track

Record and process these transactions correctly Provide a recovery mechanism Protect all assets of the organization

What are the three objectives of integrity controls?

Data validation control

What is the name of a general control technique used to ensure that entered data is correct?

Keys

____ are a critical element of relational database design because they are the bases for representing relationships among tables