Himachal Pradesh University (HPU) 2007-5th Sem B.Tech Computer Science and Engineering - Question Paper

B.Tech. Vth Semester Examination(2007)
Data- Base Management system(IT/CSE/EE)
Paper: IT(ID)-5002
Note: Attempt 5 ques. in all, selecting 1 every from parts A,B,C and D. part E is compulsory.

Section-A
1. What do you understand by DBMS? elaborate its components? [20]
2. Differentiate between:
(a) File-oriented approach vs Database-oriented approach.
(b) File processing versus Data Management. [2x10=20]

Section-B
3. Define Boyce-Codd Normal form. How does it differ from three NF? Why is it considered stronger form of three NF? [20]
4. Design ER diagrams for a particular enterprise. You have several options from which to select.
(a) What criteria should you consider in deciding on the improper model? [10]
(b) Design several option E-R diagrams to represent a university registrar system. The office maintains data about every class including the instructor, the enrolment and the time and the place of the class meetings. For every learner class-pair, a grade is recorded. [10]

Section-C
5. (a) Why do we use heuristics in query optimization? [10]
(b) explain key features and advantages of B-tree indexes. What is the difference ranging from B-tree and its various versions? [10]

6. Why do most computer systems support several file organization techniques? explain different organization with examples. [20]


Section- D

7. (a) explain the relative advantages of centralized and distributed database. [10]
(b)How does the concept of an object in object-oriented model differ from the concept of an entity in entity-relationship model? [10]
8. Write short notes on the following:
(i) Query optimization . [7]
(ii) Recovery and security. [7]
(iii) Knowledge-based database. [6]


Section- E

9. Define the subsequent :
(i) Database
(ii) Record
(iii) Field
(iv) Primary key
(v) Redundancy
(vi) DDL
(vii) DCL
(viii) DML
(ix) DOL
(x) Schema [2x10=20]

Earning:   Approval pending.