Download JNTUA MCA 2019 May Reg-Supply 3rd Sem 9F00301 Database Management Systems Question Paper

FirstRanker.com

Firstranker's choice

FirstRanker.com

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

Code: 9F00301

MCA II Semester Supplementary Examinations May 2019

DATABASE MANAGEMENT SYSTEMS

(For 2009, 2010, 2011, 2012 (LC), 2013, 2014, 2015 & 2016 admitted batches only)

Time: 3 hours Max. Marks: 60

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

Answer any FIVE questions

All questions carry equal marks

1. Explain the major functions of a database management system with examples.
2. Define and give an example for each of the following terms:
   1. Data.
   2. Field.

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

   3. Record.
   4. File.
3. Explain in detail with suitable examples, about the various issues to be considered while selecting the primary keys.
4. Explain the requirements that two relations must satisfy in order to be considered union-compatible.

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

5. Using the STUDENT and PROFESSOR tables illustrate the difference between natural join, equi join and outer join. (Assume the fields and records in the table as per your convenience, as required by the question).
6. Explain the difference between an inner join and outer join with suitable examples.
7. Explain the difference between a column constraint and a table constraint with examples.
8. Consider the following dependency diagram, which indicates that the authors are paid royalties for each book that they write for a publisher. The amount of royalty can vary by author, by book and by edition of the book.
   

   Based on the dependency diagram, create a database whose tables are at least in 2NF, showing the dependency diagram for each table.

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

   Create a database whose tables are at least in 3NF, showing the dependency diagram for each table.

   (Note: Illustrate the steps followed wherever necessary.)

9. Explain the following statements and give an example:
   1. A transaction is a logical unit of work.
   2. Transactions T1, T2 and T3 are executing in parallel and the schedule is serializable.

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

10. Using an example, explain the use of binary and shared/exclusive locks in DBMS.
11. Explain in detail about the log based recovery in a DBMS.