Download AKTU B-Tech 7th Sem 2015-2016 ECS 702 Digital Image Processing Question Paper

ANIL NEERUKONDA INSTITUTE OF TECHNOLOGY & SCIENCES (AUTONOMOUS)

3/4 B. Tech I-Semester Regular Examinations December - 2023

DATABASE MANAGEMENT SYSTEMS

(CSE)

Date: 13-12-2023                                                                                                                      Max. Marks: 70

Time: 3 hours

Answer ONE Question from each Unit

--- Content provided by⁠ FirstRanker.com ---

All Questions Carry Equal Marks

UNIT-I

1. a) Define Database Management System. Explain the advantages of DBMS over file processing system. (7M)

   b) Discuss about different types of database users and their roles. (7M)

2. a) Explain different types of attributes with examples. (7M)

   --- Content provided by‍ FirstRanker.com ---

   b) Explain components of ER diagram and design an ER diagram for Banking Enterprise. (7M)

UNIT-II

3. a) Explain different types of operations in Relational Algebra. (7M)

   b) What is Normalization? Explain 1NF, 2NF and 3NF with examples. (7M)

--- Content provided by‍ FirstRanker.com ---

4. a) Define Functional Dependency. Explain different types of Functional dependencies with examples. (7M)

   b) Explain different set operations in SQL with examples. (7M)

UNIT-III

5. a) Explain different types of Integrity constraints with examples. (7M)

   b) Explain the structure of SQL query with example. (7M)

   --- Content provided by FirstRanker.com ---

6. a) Explain different types of Aggregate functions in SQL with examples. (7M)

   b) Explain different types of Joins in SQL with examples. (7M)

UNIT-IV

7. a) Define Transaction. Explain different states of Transaction with a state diagram. (7M)

   --- Content provided by​ FirstRanker.com ---

   b) Explain different types of problems due to concurrency. (7M)

8. a) Explain ACID properties of a Transaction. (7M)

   b) Explain different types of Lock based protocols. (7M)

--- Content provided by FirstRanker.com ---

UNIT-V

9. a) Explain different types of Storage devices. (7M)

   b) Explain Hash based indexing with example. (7M)

10. a) Explain B+ Tree indexing with example. (7M)

    b) Explain Static Hashing and Dynamic Hashing. (7M)

    --- Content provided by​ FirstRanker.com ---

FirstRanker.com