The Relational Database Model

introduced by E. F. Codd in 1970, is based on predicate logic and set theory.

• Relational Model

• Predicate Logic

• Set Theory

• Integrity Rules

is used extensively in mathematics to provide a framework in which an assertion (statement of fact) can be verified as either true or false.

• Relational Model

• Predicate Logic

• Set Theory

• Integrity Rules

y is a part of mathematical science that deals with sets, or groups of things, and is used as the basis for data manipulation in the relational model.

• Relational Model

• Predicate Logic

• Set Theory

• Integrity Rules

is as a two-dimensional structure composed of rows and columns.

• Table (relation)

• Tuple

• Attribute

• Domain

Each table row (_____) represents data about an entity

• Table (relation)

• Tuple

• Attribute

• Domain

Each table column represents an _______, and each column has a distinct name.

• Table (relation)

• Tuple

• Attribute

• Domain

All values in a column must conform to the same data format. Each column has a specific range of values known as the attribute _______.

• Table (relation)

• Tuple

• Attribute

• Domain

is an attribute or group of attributes that determines the values of other attributes.

• Key

• Determination

• Functional Dependence

• Determinant

is the state in which knowing the value of an attribute makes it possible to determine the value of another.

• Key

• Determination

• Functional Dependence

• Determinant

means that the value of one or more attributes determines the value of one or more other attributes.

• Key

• Determination

• Functional Dependence

• Determinant