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

Download PTU (I.K. Gujral Punjab Technical University Jalandhar (IKGPTU) ) MCA (Master of Computer Application) 2020 March 2nd Sem 72877 Relational Database Management System Previous Question Paper

1 | M-72877 (S6)-1936
Roll No. Total No. of Pages : 02
Total No. of Questions : 09
MCA (2015 & Onwards) (Sem.?2)
RELATIONAL DATABASE MANAGEMENT SYSTEM
Subject Code : MCA-202
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.
2. SECTION-E is COMPULSORY consisting of TEN questions carrying TWENTY
marks in all.

SECTION-A
1. What are the major factors to the 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
3. Compare the features of the following :
a) Relational and Network model.
b) Transitive dependency and Multivalued dependency.
4. What are the properties of transaction? How transaction management is done with SQL?
Explain.
SECTION-C
5. a) Differentiate centralized database design and distributed database design.
b) Compare the client server with DDBMS.
6. How different levels of Data and Process distribution are implemented? Explain.

FirstRanker.com - FirstRanker's Choice
1 | M-72877 (S6)-1936
Roll No. Total No. of Pages : 02
Total No. of Questions : 09
MCA (2015 & Onwards) (Sem.?2)
RELATIONAL DATABASE MANAGEMENT SYSTEM
Subject Code : MCA-202
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.
2. SECTION-E is COMPULSORY consisting of TEN questions carrying TWENTY
marks in all.

SECTION-A
1. What are the major factors to the 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
3. Compare the features of the following :
a) Relational and Network model.
b) Transitive dependency and Multivalued dependency.
4. What are the properties of transaction? How transaction management is done with SQL?
Explain.
SECTION-C
5. a) Differentiate centralized database design and distributed database design.
b) Compare the client server with DDBMS.
6. How different levels of Data and Process distribution are implemented? Explain.

2 | M-72877 (S6)-1936
SECTION-D
7. How decision support system is useful for data analysis? Illustrate.
8. Write short note on the following :
a) Tools for Database administration
b) Schemas

SECTION-E
9. Write briefly :
a) What is the role of strong entity?
b) Define the term degree of relation.
c) Compare 2
nd
and 3
rd
normal form.
d) List the significance of locks.
e) What is meant by Integrity constraint?
f) List the disadvantages of Distributed databases.
g) Define the term domain.
h) How business intelligence is employed?
i) What is the role of OLAP?
j) Write a short note on star schema.



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.
FirstRanker.com - FirstRanker's Choice