Follow Us :

Database - Normalization for Relational Databases

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

11. Consider the relation given below and find the maximum normal form applicable to them
1. R(A, B) with productions { A --> B }
2. R(A, B) with productions { B --> A }
3 R(A, B) with productions {A —> B, B --> A }
4 R(A, B, C) with productions {A -->B, B --> A, AB --> C }

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 *


12. Consider the following
S1: Foreign key allows null values.
S2: Every binary table is in BCNF
Which of the following 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 *


13. Consider the following functional dependencies in a database:
Date_of_Birth —> Age   Age —> Eligibility
Name —> Roll_number   Roll_number -> Name
Course_number ---> Course—> name   Course_number —> Instructor
(Roll number; Course_number) —> Grade
The relation (Roll_number; Name; Date_of birth, Age) 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 *


14. The relation scheme student performance (name, courseNo, rollNo, grade) has the following functional dependencies:
name, curseNo --> grade
RolINo, courseNo —> grade
name —> rollNo
rollNo —> name
The highest normal form of this relation scheme 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 *


15. Which one of the following statements about normal forms 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 *


Related Quiz.
Normalization for Relational Databases