The relational mode

Question 1

The relational data model was introduced in June 1970 by

Answer 1

Edgar Frank Codd

Question 2

is a mathematical concept based on the ideas of sets.

Answer 2

Relation

Question 3

is a table wherein a structure satisfies all the characteristics of a relation except some of the entries contain repeating groups and thus are not single-valued.

Answer 3

Unnormalized Relation

Question 4

in a relation are often called records or tuples.

Answer 4

Rows

Question 5

in a relation are often called fields or attributes.

Answer 5

Columns

Question 6

not all Tables are considered Relations

Answer 6

true

Question 7

is the set of allowable values for one or more attributes. It is a set of atomic values (an indivisible value as far as the relational data model is concerned).

Answer 7

Domain D

Question 8

is a named column of a relation.

Answer 8

attribute

Question 9

is a row of a table which contains a single record for that relation

Answer 9

tuple

Question 10

is the number of attributes it contains.

Answer 10

degree or arity

Question 11

is the number of tuples it contains.

Answer 11

cardinality

Question 12

specifies the name of the relation, plus name, and the domain type of each column.

Answer 12

Relation Schema

Question 13

A relation instance r of the relation schema R

Answer 13

Relation Instance

Question 14

Table

Answer 14

Relation

Question 15

Column/Field

Answer 15

Attribute

Question 16

Row/Record

Answer 16

Tuple

Question 17

Values in a column

Answer 17

Domain

Question 18

Table Definition

Answer 18

Schema of Relation

Question 19

Table Data

Answer 19

Instance of Relation

Question 20

Number of Columns

Answer 20

Degree of Relation

Question 21

Number of Rows

Answer 21

Cardinality of Relation