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: 813AP R13
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
--- Content provided by 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
- a) What are the strong and weak entity sets? Explain.
b) Explain the ER diagram for Banking Enterprise. [6+6] - List and explain the different data models of databases. [12]
- 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] - a) What are the complex integrity constraints in SQL?
- With suitable example explain the difference between outer joins and Cartesian product operators in relational algebra. [6+6]
- What are the problems caused by redundancy? Explain the importance of schema refinement. [12]
- Explain the terms-INF, 2NF, 3NF and BCNF. [12]
- List and explain the ACID properties of Transactions.
--- Content provided by FirstRanker.com ---
Why does DBMS require concurrency control? Explain. [6+6] - Compare ISAM with B+ tree.
Define the following:
i) Clustered Indexes ii) Primary Indexes iii) Secondary Indexes [6+6]
--- 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 ---