Download PTU BMCI 2020 March 2nd Sem 72466 Data Base Management System Question Paper

FirstRanker.com

Roll No. Total No. of Pages : 02

Total No. of Questions : 09

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

BMCI (2014 & Onwards) (Sem.-2)

DATA BASE MANAGEMENT SYSTEM

Subject Code : BMCI-204

M.Code : 72466

Time : 3 Hrs. Max. Marks : 60

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

INSTRUCTIONS TO CANDIDATES :

1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks each.
2. SECTION-B contains FIVE questions carrying FIVE marks each and students have to attempt any FOUR questions.
3. SECTION-C contains THREE questions carrying TEN marks each and students have to attempt any TWO questions.

SECTION-A

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

1. Answer briefly :
   1. Differentiate File processing System v/s Database management System.
   2. Who is DBA? Write short note on it.
   3. What is mapping in three level architecture? Explain.
   4. Define the term schema in database.
   5. What is database integrity?

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

   6. Explain Self Join in SQL.
   7. What is database consistency?
   8. Explain the structure of distributed database.
   9. Define Multivalued Dependency.
   10. What is Concurrency? How one can achieve it in DBMS?

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

SECTION-B

2. Write about the following with suitable examples :
   1. Hierarchical Model
   2. Network Model
   3. Relational Model

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

3. Explain Entity Relationship model in detail.
4. Compare & Contrast Relational Algebra v/s Relational Calculus.
5. Write short notes on :
   1. Database Recovery
   2. Database Security

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

6. Explain disaster management which helps in database protection. Support your answer with suitable example.

SECTION-C

7. Draw & Explain three level architecture of DBMS in detail with different levels of independence.
8. Explain Normalization & its various forms in detail by taking suitable examples.

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

9. Write short notes on the following :
   1. Structure of distributed database
   2. Design of distributed database

NOTE : Disclosure of Identity by writing Mobile No. or Making of passing request on any page of Answer Sheet will lead to UMC against the Student.

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