Relational Database Model Fundamentals

Relational Database Model Fundamentals

Assessment

Flashcard

Computers

University

Hard

Created by

nerlyn anulay

FREE Resource

Student preview

quiz-placeholder

28 questions

Show all answers

1.

FLASHCARD QUESTION

Front

Who introduced the relational model and in what year?

Back

E. F. Codd in 1970.

2.

FLASHCARD QUESTION

Front

What is predicate logic used for in the relational model?

Back

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

3.

FLASHCARD QUESTION

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.

4.

FLASHCARD QUESTION

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.

5.

FLASHCARD QUESTION

Front

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

Back

A two-dimensional structure composed of rows and columns.

6.

FLASHCARD QUESTION

Front

What does each row in a table represent?

Back

Data about an entity.

7.

FLASHCARD QUESTION

Front

What does each column in a table represent?

Back

An attribute, with a distinct name.

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?