Logical Database Design

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

True

False

ANSWER DOWNLOAD EXAMIANS APP

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

True

False

ANSWER DOWNLOAD EXAMIANS APP

Logical Database Design
If no multivalued attributes exist in a relation, then the relation is in what normal form?

First normal form

Third normal form

Fourth normal form

Second normal form

First normal form

Third normal form

Fourth normal form

Second normal form

ANSWER DOWNLOAD EXAMIANS APP

Logical Database Design
If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

First normal form

Third normal form

Second normal form

Fourth normal form

First normal form

Third normal form

Second normal form

Fourth normal form

ANSWER DOWNLOAD EXAMIANS APP

Logical Database Design
A primary key may be null.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Logical Database Design
A null value is assigned when no other value applies.

True

False

ANSWER DOWNLOAD EXAMIANS APP

MORE MCQ ON Logical Database Design

↑