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
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
- Explain about different types of integrity constraints. [15]
- Draw the ER diagram for Hospital Management system. [15]
- 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] - Define Join? Explain different types of joins. [15]
- 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] - Explain Multi valued Dependencies and Fourth normal form with example. [15]
- Discuss in detail Multiple Granularity locking protocols. [15]
- Explain about Clustering File Organization and Heap File Organization. [15]
--- Content provided by FirstRanker.com ---
---00000---
--- 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 ---