Download Model question papers & previous years question papers

Posted Date: 09 May 2016      Posted By:: Krishna Teja Yeluripati    Member Level: Gold  Points: 3 (Rs. 3)

2015 B.Tech Computer Science and Engineering B.Tech - CSE - Question Paper - May 2015 - CS224 - Database Management Systems (DBMS) - Acharya Nagarjuna University Question paper



Course: B.Tech Computer Science and Engineering   University/board: Acharya Nagarjuna University

Here is the old question paper of Acharya Nagarjuna University - B.Tech - CSE - CS224 - Database Management Systems (DBMS). This is the original question paper of the exam conducted to 2/4 B.Tech - 2nd Semester students of Acharya Nagarjuna University in May 2015. If by any chance, you are looking for this paper, feel free to make a copy and use it in the preparation for your upcoming exams.




[Total No. of Questions : 09]

CS/IT 224 (CR)



II/IV B.Tech Degree Examinations, April - May 2015

Second Semester

CS/IT

Database Management Systems



Time : 3 hours

Maximum Marks : 70



Answer question No.1 Compulsory

Answer ONE question from each Unit


1. Briefly explain following [7 x 2 = 14M]
a) Advantages of Centralized Database.
b) Define entity, entity set and attribute.
c) Mention unary relational operators in relational algebra.
d) Data types supported in SQL 99.
e) Indexing.
f) Define multi-value dependency.
g) Purpose of LOG.

UNIT - I [1 x 14 = 14M]

2. Draw the architecture of a DBMS and explain the functionality of each component in it. (OR)
3. a) What is a data model? Explain the relational data model.
3. b) Define weak entity. Draw an ER diagram to explain how to present weak entity.

UNIT - II [1 x 14 = 14M]

4. a) Consider the following schema given. The primary keys are underlined.
PROJECT(Projectnum,Project Name, Chief Architect)
EMPLOYEE (Empnum,Empname)
ASSIGNEDTO(Projectnum,Empnum)
(i) Find Empnum of employee working on project "PROJ4".
(ii) Find the details of employees (both number and name) working on the project "PROJ15".
(iii) Find the details of employees working on the "PROJ99" project.
(iv) Find the Empnum's employees who do not work on project "PROJ88".
4. b) Explain UNION, INTERSECTION and MINUS operations in Relational algebra with suitable example. (OR)
5. a) Define view and what is meant by updatable and non-updatable views? Explain the advantages of view in maintaining the security.
5. b) Explain in brief different types of Joins with suitable examples.

UNIT - III [1 x 14 = 14M]

6. a) How does multi-level indexing improve the efficiency of searching an index file? Explain.
6. b) Write a brief on functional dependency and joint dependency. (OR)
7. Discuss BCNF and Third Normal Form and explain the procedure for converting the given relations schema to BCNF and 3NF with examples.

UNIT - IV [1 x 14 = 14M]

8. a) Develop an example showing how a single locking protocol could lead to a dead lock.
8. b) Define the concept of a schedule for a set of concurrent transactions and describe an algorithm to test the serializability of a schedule. (OR)
9. a) What is a log in the content of DBMS? How does check pointing eliminate some of the problems associated with log based recovery?
9. b) Write a brief on recoverable schedule and explain how cascading rollback works.





Return to question paper search

Next Question Paper: B.Tech - CSE - May 2015 - Question Paper - Object Oriented Programming Systems (OOPS) - CS225 - Acharya Nagarjuna University

Previous Question Paper: B.Tech - CSE - Question Paper - May 2015 - Computer Organization (CO) - CS223 - Acharya Nagarjuna University

Related Question Papers:


  • B.Tech - CSE - Software Engineering (SE) - CS316 - Question Paper - November 2015 - Acharya Nagarjuna University


  • Acharya Nagarjuna University, B.A. (Economics, History, Sociology) - II YEAR , MAY 2015 Question Paper (Distance Mode)


  • Acharya Nagarjuna University, B.A. (Economics, History, Sociology) - I YEAR , MAY 2015 Question Paper (Distance Mode)


  • Acharya Nagarjuna University, B.A. (Economics, Public Administration, Sociology) - III YEAR , May 2015 Question Paper (Distance Mode)


  • Acharya Nagarjuna University, B.A. (Economics, Public Administration, Sociology) - II YEAR , May 2015 Question Paper (Distance Mode)


  • Categories


    Submit Previous Years University Question Papers and make money from adsense revenue sharing program

    Are you preparing for a university examination? Download model question papers and practise before you write the exam.


    Awards & Gifts
    Top Contributors
    TodayLast 7 Daysmore...

     
    ISC Technologies, Kochi - India. © All Rights Reserved.