mod 5

Question 1

A named two-dimensional data

Answer 1

Relation

Question 2

A component of a relational model that provides mechanisms for implementing business rules in a relational database to ensure that manipulated data maintains its integrity.

Answer 2

Data integrity

Question 3

Identifiers that enable a dependent relation to refer to its parent relation.

Answer 3

Foreign Keys

Question 4

Allowable values for an attribute

Answer 4

Domain constraints

Question 5

Keys usually are used as indexes to speed up the response to user queries.

Answer 5

True

Question 6

A component of a relational model that uses SQL operations for retrieving and modifying data.

Answer 6

Data manipulation

Question 7

Unique identifiers of the relation

Answer 7

Primary keys

Question 8

A component of a relational model that refers to tables and its relations, rows, and columns.

Answer 8

Data structure

Question 9

All tables are considered as relations.

Answer 9

False

Question 10

A table will qualify as a relation if the following are satisfied.

Answer 10

All rows are unique
It has a unique name
Column names are unique