Download PTU MCA 2020 March 2nd Sem 72877 Relational Database Management System Question Paper

FirstRanker's choice

FirstRanker.com

Roll No.

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

Total No. of Questions : 09

Total No. of Pages : 02

MCA (2015 & Onwards) (Sem.-2)

RELATIONAL DATABASE MANAGEMENT SYSTEM

Subject Code : MCA-202

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

M.Code: 72877

Time: 3 Hrs.

Max. Marks : 60

INSTRUCTIONS TO CANDIDATES :

1. SECTIONS-A, B, C & D contains TWO questions each carrying TEN marks each and students has to attempt any ONE question from each SECTION.

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

2. SECTION-E is COMPULSORY consisting of TEN questions carrying TWENTY marks in all.

SECTION-A

1. What are the major factors to be considered for the database design? How data abstraction is useful? Explain.
2. Explain the concept of entity relationship model for different types of relationship.

SECTION-B

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

1. Compare the features of the following :
   1. Relational and Network model.
   2. Transitive dependency and Multivalued dependency.
2. What are the properties of transaction? How transaction management is done with SQL? Explain.

SECTION-C

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

1. 1. Differentiate centralized database design and distributed database design.
   2. Compare the client server with DDBMS.
2. How different levels of Data and Process distribution are implemented? Explain.

SECTION-D

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

1. How decision support system is useful for data analysis? Illustrate.
2. Write short note on the following :
   1. Tools for Database administration
   2. Schemas

SECTION-E

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

1. Write briefly :
   1. What is the role of strong entity?
   2. Define the term degree of relation.
   3. Compare 2nd and 3rd normal form.
   4. List the significance of locks.
   5. What is meant by Integrity constraint?

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

   6. List the disadvantages of Distributed databases.
   7. Define the term domain.
   8. How business intelligence is employed?
   9. What is the role of OLAP?
   10. Write a short note on star schema.

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

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.