Download JNTUH MCA 3rd Sem R13 2020 November 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 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]

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

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

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

   Why does DBMS require concurrency control? Explain. [6+6]
9. 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