Kerala University 2010-5th Sem B.Tech Computer Science and Engineering CS - Database Design - Question Paper
FIFTH SEMESTER B.TECH DEGREE EXAMINATION MODEL QUESTION PAPER Branch: Computer Science ft Engineering Subject: DATA BASE DESIGN
Tinner 3 Hours Man Marks 100 '
PART - A
Answer all questions. (4 x 10=40 Marks)
1. What is the role of a DBA?
2. Define the terms data integrity and data consistency with suitable examples.
3. Distinguish between schema and instance.
4. What are the advantages of index sequential file?
5. Whit are the differences between weak entity and strong entity?
6. What is normalization? What are the advantages of normalization?
7. Wiiat is functional dependency?
fi. What is lossless decomposition of relation?
9. What are the properties of transaction?
10. Define transaction log7
PART - B
Answer one from each Module, (20 x 36Q Marks)
MODULE - 1
11 a] Explain the features of relational model, network model and hierarchical model considering the structure and implementation,
t>) What are the advantages of DBM5 over conventional file processing?
12. a) Discuss the features of different types of files,
b) Draw the E-R diagram for an engineering college database by determining entities, attributes and their relations.
MODULE - 2
13, a) What are the various relational algebraic operations? Perform the algebraic
operation for the relations?
P[idr name), Q[idr dept)
assuming 5 tuples in each, b) Discuss the role of normal forms in the datab-ase design.
14. a) Define integrity constraints with respect to Codd's integrity rule.
b) Discuss domain calculus and tuple calculus features for realtional database processing.
MODULE - 3
15. a) Define concurrency In the database transaction. How to achieve concurrency *n the
transaction?
b) What is 2 PC protocol?
16. 3) Explain database recovery techniques in database management system? b) Wtiat are the security issues In the database transactions?
|
Attachment: |
| Earning: Approval pending. |
