Relational Database Model

Each table _______ represents an attribute.

• Dimension

• Value

• Column

• Row

You can think of a table as a persistent representation of a logical relation.

• True

• False

The order of rows and columns is important to the DBMS.

• True

• False

What plays an important role in implementing primary keys in DBMS?

• Data dictionary

• Attributes

• Entities

• Indexes

When there is too much data redundancy in the database information, what is caused?

• Data overcrowding

• Anomalies

• Error

• Indexes

The proper use of this primary key can minimize data redundancy anomalies appearing.

• True

• False

Three relational database operators are:

• Restrict

  Indexes

  Join

• Divide

  Product

  Difference

• Union

  Intersect

  Data dictionary

• Project

  Select

  addition

Homonyms and Synonyms are recommended to be used in a DBMS.

• True

• False

Which relational database operator yields values for all rows found in a table that satisfies a given condition?

• Intersect

• Join

• Select

• Project

What is the heart of the Relational Database Model?

• A collection of rows

• A collection of columns

• A collection of attributes

• A collection of tables