Classical

Database MCQ - Database design

11:  

If every non-key attribute is functionally depedent primary key, then the relation will be in

A.

First normal form

B.

Second normal form

C.

Third form

D.

Fourth normal form

 
 

Option: B

Explanation :


12:  

 If a relation is in BCNF, then it is also in

A.

1 NF

B.

2 NF

C.

3 NF

D.

All of the above

 
 

Option: D

Explanation :


13:  

Consider the relation given below and ind 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 }

A.

1, 2 and 3 are in 3NF and 4 is in BCNF

B.

1 and 2 are in BCNF and 3 and 4 are in 3NF

C.

All are in 3NF

D.

All are in BCNF

 
 

Option: D

Explanation :


14:  

Consider the following

S1: Foreign key allows null values.

S2: Every binary tables is in BCNF

Which of the following is true 

A.

Both S1 and S2 are true

B.

S1 is true

C.

S2 is true

D.

None of these

 
 

Option: B

Explanation :


15:  

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

A.

in second normal form but not in third normal form

B.

in third normal form but not in BCNF

C.

in BCNF

D.

in none of the above

 
 

Option: D

Explanation :




Suggest an improvement