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 }

Answer
Comment
Array

Option : D
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

12. Consider the following
S1: Foreign key allows null values.
S2: Every binary table is in BCNF
Which of the following is true

Answer
Comment
Array

Option : B
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

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

Answer
Comment
Array

Option : D
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

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:

Answer
Comment
Array

Option : B
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

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

Related Quiz.
Normalization for Relational Databases

Forgot your password?

I agree with the Terms.