VTU Question Papers
Question Paper Code : 10CS54
Fifth Semester B.E. Degree Examination, Dec.2014/Jan.2015
Database Management System
Time: 3 hrs. Max. Marks: 100
Note: Answer FIVE full questions, selecting at least TWO questions from each part.
PART – A
1 a. Explain the typical components module of a DBMS, with a neat diagram. (10 Marks) b. Define the following with examples :
i) Value set ii) Complex attribute iii) Data model iv) Schema construct v) Metadata. (10 Marks)
2 a. What are structural constraints on a relation type? Explain with examples. (05 Marks) b. What is a weak entity type? Explain the role of partial key in design of weak entity type. (05 Marks)
c. Design an ER diagram for the mail order Database considering the following requirements. Here employees takes order for parts from customers.
Question Paper Code : 10CS54
Fifth Semester B.E. Degree Examination, Dec.2014/Jan.2015
Database Management System
Time: 3 hrs. Max. Marks: 100
Note: Answer FIVE full questions, selecting at least TWO questions from each part.
PART – A
1 a. Explain the typical components module of a DBMS, with a neat diagram. (10 Marks) b. Define the following with examples :
i) Value set ii) Complex attribute iii) Data model iv) Schema construct v) Metadata. (10 Marks)
2 a. What are structural constraints on a relation type? Explain with examples. (05 Marks) b. What is a weak entity type? Explain the role of partial key in design of weak entity type. (05 Marks)
c. Design an ER diagram for the mail order Database considering the following requirements. Here employees takes order for parts from customers.
0 comments:
Pen down your valuable important comments below