Database - Normalization for Relational Databases

Avatto > > UGC NET COMPUTER SCIENCE > > PRACTICE QUESTIONS > > Database > > Normalization for Relational Databases

16. Consider a relation scheme R = (A, B, C, D, E, H) on which the following functional dependencies hold:
{A —> B, BC ---> D, E, —> C, D —> Al .
What are the candidate keys of R?

Answer
Comment
Array

Option : D
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

17. The following functional dependencies are given:
AB -> CD, AF —> D, DE --> F, C —> G, F —› E, G --> A
Which one of the following options is false?

Answer
Comment
Array

Option : C
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

18. Which one ofthe following statements is FALSE?

Answer
Comment
Array

Option : D
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

19. Consider the following relational schemes for a library for a library database:
Book (Title, Author, Catalog_no, Publisher, Year, Price)
Collection (Title, Author, Catalog_no)
Which of the following functional dependencies:
I. Title Author —› Catalog no.
II. Catalog_no ---> Title Author Publisher Year
III. Publisher Title Year --> Price.
Assume {Author, Title) is the key for both schemes:
which of the following statements is true?

Answer
Comment
Array

Option : C
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

20. Manager's salary details are hidden from the employee. This is

Answer
Comment
Array

Option : A
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

Related Quiz.
Normalization for Relational Databases

Forgot your password?

I agree with the Terms.