QUESTION 41 The reason why a database table is in the second normal form (2NF),

Question

QUESTION 41

The reason why a database table is in the second normal form (2NF), but not in the third form (3NF) is because:

a.   There is a non-prime attribute that is transitively dependent on the key of the table.

b.   There is a one-to-many relationship embedded in the table.

c.   both a. and b.

d.   neither a. nor b.

QUESTION 44

If there is a many-to-many relationship between entity A and B, then

a.   there exists a functional dependency from the primary key in A to the primary key in B, i.e.,
PK(A) ? PK(B).

b.   there exists a functional dependency from the primary key in B to the primary key in A, i.e.,
PK(B) ? PK(A).

c.   both a. and b.

d.   neither a. nor b.

QUESTION 45

A key in a relational database table

a.   is a minimal set of attributes.

b.   uniquely identifies a tuple (record) in a relation table.

c.   both a. and b.

d.   neither a. nor b.

Explanation / Answer

Question 41

Answer

a)There is a non-prime attribute that is transitively dependent on the key of the table.

Question 45

Answer:

C.both a and b

Explanation:

A key is also know as superkey which is used to identifies a tuple in a table.a candidate key is a minimal set of attributes which is also used to identify the tuples.is know as minimal super key.

Question 44

Answer

C.both a and b

Many to many relationship get a depencies over any entity.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.