Download JNTUH MCA 3rd Sem R13 2018 January 813AP Database Management Systems Question Paper

FirstRanker.com

Code No: 813AP R13

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

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

FirstRanker.com

MCA III Semester Examinations, January - 2018

DATABASE MANAGEMENT SYSTEMS

Time: 3 Hours Max. Marks: 60

Note: This question paper contains two parts A and B. Part A is compulsory which carries 20 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit. Each question carries 8 marks and may have a, b as sub questions.

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

PART - A 5 x 4 Marks =20

1. a) Give history of database systems. [4]
2. b) Explain set operations in relational algebra. [4]
3. b) What is normalization? What are useful normal forms? [4]
4. a) Explain about 2PL, serializability and recoverability. [4]

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

5. b) Distinguish between primary and secondary indices. [4]

PART -B 5 x 8 Marks = 40

1. a) Describe class hierarchies in ER model.
2. b) Give a brief note on database languages. [4+4]

   OR

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

3. What is a foreign key constraint? Why are such constraints important? What is referential integrity? Give examples.
4. What is DBA? Write DBA responsibilities. [4+4]
5. a) Explain various types of joins with examples.
6. b) Explain logical connectives with examples. [4+4]

   OR

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

7. Consider the following schema:
   Suppliers(sid: integer, sname: string, address: string)
   Parts(pid: integer, pname: string, color: string)
   Catalog(sid: integer, pid: integer, cost: real)
   The key fields are underlined, and the domain of each field is listed after the field name. Thus sid is the key for Suppliers, pid is the key for Parts, and sid and pid together form the key for Catalog. The Catalog relation lists the prices charged for parts by Suppliers. Write the following queries in relational algebra, tuple relational calculus, and domain relational calculus:
   

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

   a) Find the names of suppliers who supply some red part.
   b) Find the sids of suppliers who supply some red or green part.
   c) Find the sids of suppliers who supply some red part or are at 221 Packer Ave.
   d) Find the sids of suppliers who supply some red part and some green part. [8]
8. FirstRanker.com

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

9. b) Consider a relation R with attributes ABCDE. Let the following FDs be given: A -> BC, BC -> E, and E->DA. Similarly, let S be a relation with attributes ABCDE and let the following FDs be given: A -> BC, B -> E, and E -> DA. (Only the second dependency differs from those that hold over R.) You do not know whether or which other (join) dependencies hold.
   a) Is R in BCNF?
   b) Is R in 4NF?
   c) Is R in 5NF?
   d) Is S in BCNF?
   

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

   e) Is S in 4NF?
   f) Is S in 5NF? [8]

   OR

10. Consider a relation R with five attributes ABCDE. You are given the following dependencies: A -> B, BC -> E, and ED -> A.
    a) List all keys for R.
    

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

    b) Is R in 3NF?
    c) Is R in BCNF?
11. a) Explain about inclusion dependencies. [4+4]
12. b) Discuss about transaction support in SQL.

    OR

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

13. a) Explain about recovering from a crash recovery. [4+4]
14. b) Write some anomalies associated with interleaved execution.
15. a) Write a brief note on ARIES. [4+4]
16. Give comparison of three file organizations in detail. [8]

    OR

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

17. a) Distinguish between extendable and linear hashing.
18. b) Explain levels of redundancy. [4+4]