Data Management - Applications 1

Question 1

In DB2, a named section of permanent storage space that is reserved to store the database.

??? ??? = attributes that form a primary key.

Answer 1

AREA / key attribute

Question 2

An entity designed to transform an M:N relationship into two 1:M relationships. The ??? ??? primary key comprises at least the primary keys of the entities that it connects. Also known as a bridge entity or associative entity.

composite key = multiple-attribute key.

Answer 2

composite entity etc …

Question 3

In relational algebra, an operator used to yield all rows from one table that are not found in another union-compatible table.

Answer 3

DIFFERENCE

Question 4

In relational algebra, an operator that answers queries about one set of data being associated with all values of data in another set of data.

Answer 4

DIVIDE

Question 5

A join operator that links tables based on an equality condition that compares specified columns of the tables.

Answer 5

equijoin

Question 6

A join operation in which only rows that meet a given criterion are selected.

In relational algebra, a type of operator used to yield rows from two tables based on criteria.

Answer 6

inner join / join

Question 7

In relational algebra, an operator used to yield only the rows that are common to two union-compatible tables.

Answer 7

INTERSECT

Question 8

Columns that are used in the criteria of join operations. The join columns generally share similar values (have a compatible domain).

Answer 8

join columns

Question 9

In a pair of tables to be joined, a join that yields all the rows in the left table, including those that have no matching values in the other table. For example, a left outer join of CUSTOMER with AGENT will yield all of the CUSTOMER rows, including the ones that do not have a matching AGENT row.

Answer 9

left outer join

Question 10

A relational operation that yields a new table composed of only the rows with common values in their common attribute(s).

Answer 10

natural join