Relational Database Model Fundamentals

Front

Who introduced the relational model and in what year?

Back

E. F. Codd in 1970.

Front

What is predicate logic used for in the relational model?

Back

It provides a framework to verify assertions as true or false.

Front

What does set theory deal with?

Back

Sets, or groups of things, and is used as the basis for data manipulation in the relational model.

Front

What are the three components of the relational model?

Back

1. A logical data structure represented by relations. 2. A set of integrity rules to enforce data consistency. 3. A set of operations that defines how data is manipulated.

Front

What is a table in the context of a relational database?

Back

A two-dimensional structure composed of rows and columns.

Front

What does each row in a table represent?

Back

Data about an entity.

Front

What does each column in a table represent?

Back

An attribute, with a distinct name.

Front

What is the primary key in a database?

Back

An attribute that uniquely identifies each row in a table.

Front

Why is STU_NUM considered the primary key in the STUDENT table?

Back

Because it is guaranteed to be unique for each student.

Front

What is functional dependence in a relational database?

Back

The value of one or more attributes determines the value of one or more other attributes.