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

FirstRanker.com

Roll No. [T | Total No. of Pages : 02

Total No. of Questions : 09

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

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

RELATIONAL DATABASE MANAGEMENT SYSTEM

Subject Code : BMCI-301

M.Code : 72582

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. What are the log files?
   2. What is Normalization?
   3. What are accidental security threats?
   4. What is degree of relation?
   5. What is the fifth-normal form?

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

   6. Describe type of relationship.
   7. What do you understand by Functional dependency?
   8. What is Key?
   9. What is importance of ERD?
   10. What is Referential Integrity Constraint?

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

SECTION-B

2. Describe keys with help of an example :
   1. Primary key
   2. Foreign key
   3. Candidate key

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

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.

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

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:
   1. Distributed database management systems (DDBMS)
   2. MPSD

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

   3. 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.