Jawaharlal Nehru Technological University Hyderabad 2010 Certification Computer Engieering Ii b.tech sem – regular/supplementary s, – , dtatbase management system - Question Paper
II B.TECH SEM - REGULAR/SUPPLEMENTARY EXAM MAY - 2010 DTATBASE MANAGEMENT SYSTEM TIME: 3 HOURS Max.Marks:80
Answer any FIVE questions All questions carry equal marks
1. a) Construct an ER diagram for a bank database. Bank maintains data about customers, their loans,
their deposits, lockers. Determine the entities and relationships. MARKS[8] b) What is the composite attribute? How to model it in the ER diagram ? Explain with an example MARKS[ 8]
2. a) Explain Log-Record Buffering? MARKS[8] b) Explain Database Buffering? MARKS[8]
3. a) What is grouping? Is there in Relational Algebra? Explain this feature and discuss the interaction of
the HAVING and WHERE clauses. Mention any restrictions that must be satisfied by the fields that appears in the GROUP BY clause. MARKS[10] b) What are the differences between Integrity Constraints and Triggers? MARKS[6]
4. a) Explain about the following:
i) Key constraints.
ii) Specifying foreign key constraints in SQL with an example. MARKS[8] b) What is a view? Explain about views in detail. MARKS[8]
5. a) Explain Third NF with examples? MARKS[8] b) Explain BCNF with examples? MARKS[8]
6. a) Explain Heap file with un clustered Tree index? MARKS[8]
b) Explain Heap file with un clustered Hash index? MARKS[8]
7. a) Explain validation protocol with example? MARKS[8]
b) Explain granularity and multiple granularity? MARKS[8]
8. a) Describe storage manager component of database system structure.
MARKS[8]
b) Explain levels of abstraction in DBMS? MARKS[8]
|
Attachment: |
| Earning: Approval pending. |
