Misc

Question 1

Relational Algebra

Answer 1

Theoretical way of manipulating table contents using relational operators

Question 2

Relvar

Answer 2

Relation Variable
Variable that holds a relation
Table is the container (variable) that holds the data (relation)

Question 3

Closure

Answer 3

Use of relational algebra operators on existing relations produces new relations

Question 4

Union-compatible

Answer 4

When two or more tables share the same number of columns and share the same or compatible domains.

Question 5

Join Columns

Answer 5

Common columns between two tables that are joined.

Question 6

Data Dictionary

Answer 6

Provides a detailed description of all tables in the database created by the user and designer

Question 7

System Catalog

Answer 7

Detailed system data dictionary that describes all objects within the database including tables names, creation date, # of columns, data types, etc.

Question 8

Homonyms

Answer 8

Similar-sounding words with different meanings

Question 9

Synonym

Answer 9

Different names to describe the same attribute

Question 10

Index

Answer 10

Orderly arrangement of keys and pointers used to logically access rows in a table

Question 11

Index Key

Answer 11

Each key points to a location of the data identified by the key. Can be be composed of one or more attributes.

Question 12

Unique Index

Answer 12

Index key can only have one pointer value associated with it