Himachal Pradesh University (HPU) 2008-5th Sem B.Tech Computer Science and Engineering - Question Paper
Tuesday, 22 January 2013 07:40Web
B.Tech. Vth Semester exam
Database Management System(2008)
(EC/CSE/IT)
Note: Attempt 5 ques. in all, selecting 1 every from parts A,B,C and D. part E is compulsory.
Section-A
1.(a) Why would you select a database system instead of simply storing data in system files?
[10] (b) What is a Data model? provide a brief overview of Hierarchical data model.
[10]
2. (a) discuss the difference ranging from Internal, External and Conceptual schema. How are these various schema layers related to the concept of logical and physical data independence?
[20]
Section-B
3. (a) Construct an ER diagram for the database of a departmental store.
[10]
(b) discuss all variations of join operation with suitable examples.
[10]
4. Specify the subsequent relational algebra operations in both tuple and domain relational calculus:
(a) R(A,B) x S(C,D)
(b) R(A,B,C) /S(B)
(c) R(A,B) – S(A,B)
(d) Pie (R(A,B,C))
[4x5=20]
Section-C
5. (a) elaborate the methods to handle collisions generated by Hashing?
[12]
(b) Write SQL constructs for the subsequent operations:
(i) Modification of relation instances.
(ii) Deletion of a view.
(iii) Enforcing integrity constraints.
(iv) Grouping of data. [8]
6. (a) Show the 5NF implies 4NF. [15]
(b) What is the highest normal form for the subsequent relations:
(i) R(A,B,C,D) with A->BC, CD->B.
(ii) R(A,B,C,D,E) with A->BC, E->A, CD->E. [5]
Section- D
7. (a) discuss the major problems related to Database security. [10]
(b) How are nested sub-queries optimized and evaluated? [10]
8. Describe the architecture for a distributed DBMS and identify the additional function it requires over a centralized DBMS. [20]
Section- E
9. Attempt the subsequent questions:
(i) Define the term Data Dictionary.
(ii) What are the properties of relational model?
(iii) Give any 4 differences ranging from sequential and direct files?
(iv) Explain the Null value and Dangling tuple issues.
(v) In which step of database design is the ER model mainly used?
(vi) Give a comparison ranging from RDBMS and OODBMS.
(vii) What are the characteristics of Knowledge Base Database?
(viii) Why Denormalization is required?
(ix) How recovery is implemented using shadow paging
(x) discuss the inference rules for functional dependencies
[2*10=20]
| Earning: Approval pending. |
