Kuvempu University 2008 B.Sc Information Technology BASICS OF DBMS - Question Paper

BTB - 24/BSIT - 24
Second Semester B.Sc. (IT) Examination, November 2008
Directorate of Distance Education Course
BASICS OF DBMS
Time: three Hours Max. Marks: 100
Instructions: 1) Part A - ans all the ques..
2) Part B - ans any 5 full ques..
PART- A
I. ans all the following: (5x2=10)
1) discuss briefly the tasks of DBMs packages. 2
2) describe Field and Record with an example. 2
3) discuss briefly 3 important data models. 2
4) What is the difference ranging from single-valued of multi valued attributes. 2
5) What is Candidate Key ? provide example. 2
II. ans all the questions: (5x3=15)
1) discuss various role of DB Administrator.
2) List out advantage and disadvantage of sequestial organization.
3) discuss any 2 mapping cardinalities with example.
4) List out advantages of Relational model.
5) What is collision? Name various collision resolution methods.
16
PART - B
ans any 5 full question: (5x15=75)
1. a) discuss various kinds of databases. 7
b) elaborate the disadvantages of file oriented approaches? discuss. 8
2. a) discuss the structure of index sequential file ? elaborate the various
components of it ? 7
b) discuss the subsequent terms : 8
1) Ternary relationship
2) Cardinality ratio
3. a) List and discuss the rules of relational model. 7
b) discuss structure of Hierarchical model with an example. 8
4. a) What is Hashing? define various hashing with suitable examples. 8
b) What do you mean by DB security ? discuss problems to be addressed in
DB Security. 7
5. a) discuss the steps to create. Form in MS Access. 7
b) discuss the steps to create report. 8
6. a) discuss briefly discretionary and mandatory access control methods. 8
b) discuss the various phases of DB development life cycle. 7
7. a) discuss briefly various kinds of attributes occur in the ER model. 7
b) discuss various kinds of indexes with example. 8
8. Write short note on : (5x3=15)
a) Record and Record organization
b) E-R diagram
c) Object relational and object oriented model
* * * * * * *

Earning:   Approval pending.