QUESTION 2

When one-to-many relationship in E-R model is mapped into relational data model, the one-to-many relationship is generally represented as

a. a primary key

b. a foreign key

c. a pair of primary key (in one table) and a foreign key (in another table or the same table),

d. a new table with a pair of foreign keys, each of which is associated with or references to the primary key in its parent table.

QUESTION 3

If there are only two attributes such as A and B in a database table, then a. there is a functional dependency A B that is held true.

b. there is a functional dependency B A that is held true.

c. there is a functional dependency AB AB that is held true.

d. none of a., b., and c. are true.

QUESTION 6

What justification can you give for normalizing a database if the database is designed only for SELECT query statements?

a. lack of redundancy eases understanding.

b. normalized tables may correspond more naturally to the types of queries to be posted.

c. both a. and b.

d. neither a. nor b.