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 R15 2020 November 823AC Database Management Systems Question Paper

Download JNTUH (Jawaharlal nehru technological university) MCA (Master of Computer Applications) 3rd Sem (Third Semester) Regulation-R15 2020 November 823AC 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: 823AC

R15

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

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA 111 Semester Examinations, October/ November - 2020

DATABASE MANAGEMENT SYSTEMS

Time: 2 Hours Max.Marks:75

Answer any five questions

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

All questions carry equal marks

  1. Explain about different types of integrity constraints. [15]
  2. Draw the ER diagram for Hospital Management system. [15]
  3. Consider the following schema and write the SQL statements for the queries given below:
    SAILORS(Sid, Sname, rating, age)

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

    BOATS(bid, bname, color)
    RESERVES(sid, bid,day)
    a) Find names of sailors who reserved green boat
    b) Find the colors of boats reserved by β€œRam”
    c) Find names of sailors who have reserved a red or a green boat.

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

    d) Find the β€œsids” of sailors with age over 20 who have not registered a red boat. [15]
  4. Define Join? Explain different types of joins. [15]
  5. Consider the universal relation R = {A;B, €, D, E, F, G, H, I, J} and the set of functional dependencies
    F:{ {A;B} -> {C}, {A} -> {D,E}, {B}->{F}, {F} ->{G;H}, {D} -> {I;J}}
    What is the key for R? Decompose R into 2NF, then 3NF relations. [15]
  6. --- Content provided by FirstRanker.com ---

  7. Explain Multi valued Dependencies and Fourth normal form with example. [15]
  8. Discuss in detail Multiple Granularity locking protocols. [15]
  9. Explain about Clustering File Organization and Heap File Organization. [15]

---00000---

FirstRanker.com

--- Content provided by 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 ---