MST-1(RDBMS-II)

Subject Name : RDBMS-11                                 Subject Code : BTCS-602

Semester : 6th                                                      Branch : CSE

Sessional Test : 1^st                 

Time Duaration : 1.30 hr                                     Max Marks : 24

Section A

Do any two :

1.     What do you mean by FFD? Explain with an example.                             (2)

2.     Explain the term BCNF.                                                                             (2)

3.     Write down the definition of MVD. Give an example.                      (2)

Section B

Each question carries 5 marks:

1.     What do you mean by DDL? Explain the function of  ALTER & DROP commands with an example.

2.     Discuss the anomalies in 2^nd NF.

Section C

Each question carries 10 marks. Do any one :

1.     Compare the different types of Data Models.

2.     What are the various phases of Query Processing? Discuss the concept of Heuristic Query Optimization.