CSCI 4402: Database Systems - Module 6/Quiz 6

Consider the relation R={A,B,C,D,E,F} and the set of functional dependencies {A→DE, B→C, DE→F, F→AB}.

How many different keys for the relation R?

a. one

b. Four

c. Three

d. Two

Three

Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups?

a. 1NF

b. 2NF

c. 3NF

d. Normal forms do not reduce the redundancy

3NF

If the attribute of relation schema R is not a member of some candidate key then this type of attributes is classified as ______________

a. atomic attribute

b. candidate attribute

c. nonprime attribute

d. prime attribute

nonprime attribute

Considering the relational database, the functional dependency between two attributes A and B is denoted by ______

a. B←AB←A

b. R←ABR←AB

c. AB→RAB→R

d. A→B

A→B

The joining property which guarantees that spurious tuple generation problem is not created after decomposition is called _______________

a. lossless join property

b. outer join property

c. inner join property

d. additive join property

lossless join property

In the functional dependency between two sets of attributes A and B then the set of attributes A of database is classified as _________________

a. down left side

b. left hand side

c. right hand side

d. top right side

left hand side

In the __________ normal form, a composite attribute is converted to individual attributes.

a. BCNF

b. First

c. Third

d. Second

First

In the tuples, the interpretation of the values of the attribute is considered as __________

a. semantics of relation

b. clauses of relation

c. schema of relation

d. commands of relation

semantics of relation

The normalization form which is based on the transitive dependency is classified as _______________

a. third normal form

b. second normal form

c. first normal form

d. no relation between normalization and transitive dependency

third normal form

The normal form which only includes indivisible values or single atomic values is classified as __________

a. BCNF

b. third normal form

c. first normal form

d. second normal form

first normal form

Considering the functional dependency, the one in which removal from some attributes must affect dependency is called __________________

a. partial dependency

b. prime functional dependency

c. transitive dependency

d. full functional dependency

full functional dependency

Consider the relation R={A,B,C,D,E,F} and the set of functional dependencies {A→DE, B→C, DE→F, F→AB}.

Which one of the following is not considered a key for the relation R?

a. FF

b. AA

c. DEDE

d. AC

AC