FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE

📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

Download JNTUH MCA 3rd Sem R13 2020 November 813AP Database Management Systems Question Paper

Download JNTUH (Jawaharlal nehru technological university) MCA (Master of Computer Applications) 3rd Sem (Third Semester) Regulation-R13 2020 November 813AP Database Management Systems Previous Question Paper

This post was last modified on 17 March 2023

This download link is referred from the post: JNTUH MCA 3rd Sem Last 10 Years 2023-2013 Question Papers R20-R09 || Jawaharlal nehru technological university


FirstRanker.com

Code No: 813AP R13

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

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

FirstRanker.com

MCA 111 Semester Examinations, October/ November - 2020

DATABASE MANAGEMENT SYSTEMS

Time: 2 Hours Max. Marks: 60

Answer any five questions

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

All questions carry equal marks

  1. a) What are the strong and weak entity sets? Explain.
    b) Explain the ER diagram for Banking Enterprise. [6+6]
  2. List and explain the different data models of databases. [12]
  3. Consider the following employee database and give SQL expressions for each of the following queries.

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

    Employee (Employee-name, street, city)
    Works (Employee-name, Company-name, salary)
    Company (Company-name, City)
    a) Find the names and cities of residence of all employees work for First Bank Corporation.
    b) Find the names, street and cities of residence of all employees who work for first Bank Corporation. [6+6]
  4. --- Content provided by FirstRanker.com ---

  5. a) What are the complex integrity constraints in SQL?
  6. With suitable example explain the difference between outer joins and Cartesian product operators in relational algebra. [6+6]
  7. What are the problems caused by redundancy? Explain the importance of schema refinement. [12]
  8. Explain the terms-INF, 2NF, 3NF and BCNF. [12]
  9. List and explain the ACID properties of Transactions.

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

    Why does DBMS require concurrency control? Explain. [6+6]
  10. Compare ISAM with B+ tree.
    Define the following:
    i) Clustered Indexes ii) Primary Indexes iii) Secondary Indexes [6+6]

---00000---

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

FirstRanker.com



This download link is referred from the post: JNTUH MCA 3rd Sem Last 10 Years 2023-2013 Question Papers R20-R09 || Jawaharlal nehru technological university

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