QUESTION 13 Please indicate what the highest normal form is for the given relati

Question

QUESTION 13

Please indicate what the highest normal form is for the given relation schema R(A, B, C, D), the key for the schema: AB, and the set of functional dependencies, A ? C, B ? D,

a.The first normal form (1NF)

b.The second normal form (2NF)

c.The third normal form (3NF)

d.The Boyce-Codd normal form (BCNF)

QUESTION 19

What kind of normal form data does the object-oriented database can handle?

a.BCNF, 3NF, 2NF, 1NF   

b.Non first normal form

c.both a. and b.

d.neither a. nor b.

QUESTION 20

Copy of

Given table R(A,B,C) and S(C,D,E), which of the following SQL statements would find the record(s) with null values on the column C in table S?

a.select * from R left outer join S where R.C = S.C;

b. select * from R right outer join S where R.C = S.C;

c.either a. or b.

d.neither a. nor b.

Explanation / Answer

Question 13: a.The first normal form (1NF)

The relation has partial dependency as A->C and not AB ->C. Also B->D and not AB ->D. So relation is not in 2NF. so it can only be in 1NF.

Question 19: d.neither a. nor b.

object oriented database can handle 1ONF,2ONF,3ONF

Question 20: b. select * from R right outer join S where R.C = S.C;

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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