Sathyabama University 2008 B.E Computer Science and Engineering Database Management System - Question Paper
SATHYABAMA UNIVERSITY
(Established under section 3 of UGC Act, 1956)
Course & Branch: B.E - CSE (Part Time)
Title of the paper: Database Management System
Semester: III Max. Marks: 80
Sub.Code: 6CPT0012 (2006/2007 JAN) Time: 3 Hours
Date: 25-04-2008 Session: FN
PART A (10 x 2 = 20)
Answer All the Questions
1. Give an example for derived attribute.
2. Give the advantages of hash indices.
3. Give an example for functional dependency.
4. What is ODBC?
5. What is trigger?
6. Give an example for equi-join.
7. Give tow issues related to multimedia databases.
8. What is the sue of Quadtree?
9. What is clot and blot?
10. Give two applications of data mining.
PART B (5 x 12 = 60)
Answer All the Questions
11. (a) Explain the database system architecture
with a block
diagram. (8)
(b) Explain the concept of aggregation with a example. (4)
(or)
12. Design and develop the E R diagram for an university.
13. Let R = (A, B, C) and let r1 and r2 be relations on schema R. Give expressions in SQL for the queries.
(i) r1 U r2 (ii) r1 r2
(iii) r1 Ո r2 (iv) pAB (r1) pBC (r2)
(or)
14. Assume a relation marks (student-id, score) and grades are assigned to students based on the scores as follows:
Grade F if Score < 40,
Grade C if 40 ≤ score < 60
Grade B if 60 ≤ score < 80
and Grade A if 80 ≤ score.
Write SQL queries for the following:
(a) Display the grade of each student based on the
marks
relation.
(b) Find the number of students with each grade.
15. (a) Explain lock-based concurrency control with example.
(b) How is crash recovery done in concurrent transactions?
(or)
16. Discuss in detail about database security and authorization.
17. Discuss about query processing in distributed databases and its related issues.
(or)
18. Discuss interquery parallelism and intraquery parallelism with examples.
19. Discuss about object oriented databases and object relational databases with suitable examples.
(or)
20. Give a brief overview of data ware housing and data mining.
| Earning: Approval pending. |
