Download PTU BMCI 2020 March 3rd Sem 72582 Relational Database Management System Question Paper

Download PTU (I.K. Gujral Punjab Technical University Jalandhar (IKGPTU) BMCI 2020 March (Bachelor in Mobile Computing & Internet) 3rd Sem 72582 Relational Database Management System Previous Question Paper

1 | M-72582 (S2)-1414
Roll No. Total No. of Pages : 02
Total No. of Questions : 09
BMCI (2014 & Onwards) (Sem.?3)
RELATIONAL DATABASE MANAGEMENT SYSTEM
Subject Code : BMCI-301
M.Code : 72582
Time : 3 Hrs. Max. Marks : 60
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
1. Answer briefly :
a) What are the log files?
b) What is Normalization?
c) What are accidental security threats?
d) What is degree of relation?
e) What is the fifth normal form?
f) Describe type of relationship.
g) What do you understand by Functional dependency?
h) What is Key?
i) What is importance of ERD?
j) What is Referential Integrity Constraint?
FirstRanker.com - FirstRanker's Choice
1 | M-72582 (S2)-1414
Roll No. Total No. of Pages : 02
Total No. of Questions : 09
BMCI (2014 & Onwards) (Sem.?3)
RELATIONAL DATABASE MANAGEMENT SYSTEM
Subject Code : BMCI-301
M.Code : 72582
Time : 3 Hrs. Max. Marks : 60
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
1. Answer briefly :
a) What are the log files?
b) What is Normalization?
c) What are accidental security threats?
d) What is degree of relation?
e) What is the fifth normal form?
f) Describe type of relationship.
g) What do you understand by Functional dependency?
h) What is Key?
i) What is importance of ERD?
j) What is Referential Integrity Constraint?
2 | M-72582 (S2)-1414
SECTION-B
2. Describe keys with help of an example :
a) Primary key
b) Foreign key
c) Candidate key
3. Explain three types of normalization in RDBMS.
4. What is ER model? Explain the ER diagram with example.
5. Explain architecture of a DBMS.
6. What do you mean by DSS? Explain different requirements of DSS database.

SECTION-C
7. What do you mean by concurrency? Explain different Locking Methods.
8. What is relational algebra? Explain types of JOIN operations.
9. Explain :
a) Distributed database management systems (DDBMS)
b) MPSD
c) OLAP.



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