Relational Database

Question 1

Table

Answer 1

Two-dimensional structure composed of intersecting rows and columns.
aka Relation, Dataset
Physical concept is file

Question 2

Tuple

Answer 2

Row in a table
Each row must be uniquely identified by an attribute or combination of attributes
Physical concept is record

Question 3

Data Value

Answer 3

Intersection of row and column

Question 4

Key

Answer 4

Ensure that each row is uniquely identifiable and establish relationships among tables.
Consists of one or more attributes.

Question 5

Determination

Answer 5

Knowing the value of one attribute makes it possible to determine the value of another

Question 6

Functional Dependence

Answer 6

Value of one or more attributes determines the value of one or more others

Question 7

Determinant

Answer 7

Attribute whose value determines another

Question 8

Dependent

Answer 8

Attribute whose value is determined by another

Question 9

Full Functional Dependence

Answer 9

Entire collection of attributes in the determinant is necessary for finding the dependent

Question 10

Entity Integrity

Answer 10

Each row in table has its own unique identity. Requires: [1] all values in primary key must be unique and [2] no attribute in primary key can be null

Question 11

Null

Answer 11

Absence of any data value

Question 12

Referential Integrity

Answer 12

Every reference to an entity instance by another entity instance is valid

Question 13

Flags

Answer 13

Value that is outside of the used range to indicate the absence of a value

Question 14

Degree of a Relationship

Answer 14

Number of entity types that participate in the relationship

Question 15

Index

Answer 15

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