Download AKTU B-Tech 5th Sem 2016-2017 Database Management Systemdbms Ncs 502 Question Paper

Printed Pages - 4

(Following Paper ID and Roll No. to be filled in your Answer Books)

Paper ID: 2012279                                          Roll No.

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

NCS-502

B.TECH

Regular Theory Examination (Odd Sem -V), 2016-17

DATABASE MANAGEMENT SYSTEM (DBMS)

Time: 3 Hours                                                                      Max. Marks: 100

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

Section - A

Attempt all parts. All parts carry equal marks.

Write answer of each part in short.

1. (10×2=20)
   1. What is data model? List the types of data model used.
   2. Give example for one to one and one to many relationship.

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

   3. With an example show how a referential integrity can be implemented.
   4. Write the purpose of trigger.
   5. What is normalization?
   6. Define the term ACID properties.
   7. State the properties of transaction.

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

   8. What is serializability? How it is tested?
   9. Why is concurrency control needed?
   10. Define timestamp.

Section - B

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

Attempt any five questions from this section. (5×10=50)

2. 1. Consider the following relational database
      employee (employee-name, street, city works
      (employee-name, company-name, salary) company
      (company-name, city) manages (employee-name,
      

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

      manager-name).
      Give an expression in SQL to express each of the
      following queries:
      i) Find the names and cities of residence of all
      employees who work for XYZ bank.
      

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

      ii) Find the names, street address, and cities of
      residence of all employees who work for XYZ
      Bank and earn more than Rs. 10,000 per annum.
      iii) Find the names of all employees in this
      database who live in the same city as the
      

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

      company for which they work.
   2. Discuss about the deadlock prevention schemes.
      Note: FirstRanker.com
   3. Explain the differences between physical level, conceptual level and view level of data abstraction.
   4. Explain embedded SQL and dynamic SQL in detail.

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

   5. Describe shadow paging recovery technique.
   6. Write down in detail about deadlock and serializability.

Section - C

Attempt any 2 questions from this section. (2×15=30)

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

3. 1. What are the relational algebra operations supported in SQL? Write the SQL statement for each operation.
   2. Draw an E-R diagram for a small marketing company database, assuming your own data requirements.
4. 1. Explain 1NF, 2NF, 3NF and BCNF with suitable example.
   2. Consider the universal relational schema R (A, B, C, D, E, F, G, H, I, J) and a set of following functional dependencies.
      

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

      F = {AB ? C, A ? DE,B ? F,F ? GH, D ? IJ}
      Determine the keys for R? Decompose R into 2nd Normal Form.
5. Explain the following protocols for concurrency control.
   1. Lock based protocols
   2. Time Stamp based protocols

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

FirstRanker.com