Follow Us :

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?

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


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?

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


18. Which one ofthe following statements is FALSE?

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


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?

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


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

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


Related Quiz.
Normalization for Relational Databases