Q.1
Relations are:
Q.2
If no multivalued attributes exist in a relation, then the relation is in what normal form?
Q.3
A primary key is which of the following?
Q.4
The relational model consists of:
Q.5
When mapping a binary many-to-many relationship into a relation which of the following is true?
Q.6

A candidate key must uniquely identify each row.

  • True
  • False
Q.7

A null value is assigned when no other value applies.

  • True
  • False
Q.8

Well-structured relations encourage anomalies of data.

  • True
  • False
Q.9

A synonym is two or more attributes that have different names but the same meaning.

  • True
  • False
Q.10

A foreign key may be null and still adhere to the referential integrity constraint.

  • True
  • False
Q.11

If a relation is in third normal form, it does not need to be in second normal form.

  • True
  • False
Q.12

The primary key in a relation does not need to be underlined.

  • True
  • False
Q.13

The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.

  • True
  • False
Q.14

In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.

  • True
  • False
Q.15

Normalization is a formal process for deciding which attributes should be grouped together in a relation.

  • True
  • False
Q.16

An enterprise key is a primary key whose value is unique for a given relation.

  • True
  • False
Q.17

A composite attribute does not get mapped into a relation.

  • True
  • False
Q.18

A relation is a two-dimensional table.

  • True
  • False
Q.19

Weak entities do not get mapped into a relation.

  • True
  • False
Q.20

A primary key may be null.

  • True
  • False
0 h : 0 m : 1 s