adplus-dvertising
frame-decoration

Question

A relation R={A,B,C,D,E,F} is given with following set of functional dependencies:

F={A→B,AD→C,B→F,A→E}.

Which of the following is Candidate Key?

a.

A

b.

AC

c.

AD

d.

None of these

Answer: (c).AD

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. A relation R={A,B,C,D,E,F} is given with following set of functional dependencies: F={A→B,AD→C,B→F,A→E}. Which of the following is Candidate Key?

Similar Questions

Discover Related MCQs

Q. Which statement is false regarding data independence?

Q. In DBMS, deferred update means:

Q. Which statement is false regarding data independence ?

Q. Two phase protocol in a database management system is:

Q. A relation R = {A, B, C, D, E, F} is given with following set of functional dependencies:

F = {A→B, AD→C, B→F, A→E}

Which of the following is candidate key ?

Q. Immediate updates as a recovery protocol is preferable, when:

Q. Which of the following statement is wrong ?

Q. A subclass having more than one super class is called .................

Q. A schema describes:

Q. One approach to standardizing storing of data:

Q. In a relational schema, each tuple is divided in fields called:

Q. An embedded pointer provides:

Q. A locked file can be:

Q. An Entity - relationship diagram is a tool to represent:

Q. Multi-valued dependency among attribute is checked at which level ?

Q. A WINDOW into a portion of a data base is:

Q. The E-R model is expressed in terms of:

(i) Entities
(ii) The relationship among entities
(iii) The attributes of the entities

Q. Specialization is a ............... process.

Q. The completeness constraint has rules:

Q. The entity type on which the ................. type depends is called the identifying owner.