Conceptual Models

Question 1

Table

Answer 1

Two-dimensional structure that is a persistent representation of a logical relation. Contains a group of related entity occurrences.
aka Relation, Entity Set, Dataset

Question 2

Tuple

Answer 2

Single entity occurrence within the entity set

aka Row

Question 3

Column

Answer 3

Represents an attribute in a table

Question 4

PK

Answer 4

Primary Key

Attribute, or combination of, that uniquely identifies any given row.

Question 5

Key

Answer 5

One or more attributes that determine other attributes. Establish relationships among tables and ensure data integrity.

Question 6

Determination

Answer 6

The state in which knowing the value of one attribute makes it possible to determine the value of another.

Question 7

Functional Dependence

Answer 7

Value of one or more attributes determines the value of one ore more other attributes

Question 8

Determinant

Answer 8

Attribute whose value determines another

Question 9

Dependent

Answer 9

Attribute whose value is determined by another

Question 10

Full Functional Dependence

Answer 10

Functional dependencies in which the entire collection of attributes in determinant is necessary for the relationship

Question 11

Key Attribute

Answer 11

Attribute that is part of a key

Question 12

Entity Integrity

Answer 12

Each row in the table has its own unique identify.

Question 13

NULL

Answer 13

The absence of any data. Create problems with functions such as COUNT, AVERAGE, and SUM. Create logical problems when relational tables are linked.

Question 14

Referential Integrity

Answer 14

Every reference to an entity instance by another entity instance is valid. Every FK must either be NULL or point to a valid PK.

Question 15

Flags

Answer 15

Special codes used to indicate the absence of data without leaving nulls in the table