Match the Following Terms on the Left with the Correct Definitions on the Right:

 

18.  Candidate key

07.  Composite key

09.  Data Type

14.  Determination

26.  Entity

23.  Entity Integrity

06.  Fields

25.  Foreign Key

11.  Fully Relational

21.  Functional Dependence

02.  Join

04.  Minimally relational

15.  Natural Joins

24.  Primary Key

22.  Record

16.  Relational Integrity

19.  Relationally Complete

12.  RDBMS

08.  RDBMS Convention

01.  Secondary key

05.  Select

17.  Super Key

03.  Table

20.  Table Products

13.  Tuple

10.  Union

01.

02.

03.

04.

05.

06.

07.

08.

09.

10.

11.

12.

13.

14.

15.

16.

17.

18.

19.

20.

21.

22.

23.

24.

25.

26.

A key which can not uniquely determine other values

Merging values from tables based on a common attribute

A two dimensional array of data

Supports Select, Product, and Join operations only

Extraction of values from a table

A named column

A concatentation of keys to form a unique identifier

An example is that all field names must be unique

The manner is which specific data is stored

Combines the results of two unrelated queries into a single output

Supports all algebraic operations as well as entity and referential integrity

A DBMS Approach that manages data as a collection of tables

A column in a relational table

Knowing the value of one key means you know the others

Only common values from related tables are included

An example is that a foreign key must have a valid entry in the referring table

Either a composite key of primary key

A key or combination of keys that may become a unique identifier

Supports all algebraic operations but not entity and referential integrity

The union of all possible combinations of table elements

When every nonkey is dependent upon a unique identifier

An entity instance

An example is that primary keys can not be null

A unique record identifier

A key which is used to relate tables together

Anything about which we wish to keep information