Download PTU MBA 2020 March 3rd Sem 70760 Relational Database Management System Question Paper

Roll No. _______________ Total No. of Pages : 02

Total No. of Questions: 15

MBA (2016 to 2017) (Sem.-3)

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

RELATIONAL DATABASE MANAGEMENT SYSTEM

Subject Code: MBA-982

M.Code : 70760

Time: 3 Hrs. Max. Marks : 60

INSTRUCTION TO CANDIDATES :

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

1. SECTION-A contains SIX questions carrying FIVE marks each and students have to attempt any FOUR questions.
2. SECTION-B consists of FOUR Subsections: Units-I, II, III & IV. Each Subsection contains TWO questions each carrying EIGHT marks each and student has to attempt any ONE question from each Subsection.
3. SECTION-C is COMPULSORY carrying EIGHT marks.

SECTION-A

1. Q1) Define DBMS. Discuss the advantages of DBMS over traditional file system.

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

2. Q2) What is the difference between logical data independence and physical data independence? Which one is harder to achieve and why?

3. Q3) What is a functional dependency? List the conditions for a set of functional dependencies to be minimal.

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

4. Q4) Explain Insert, Delete, and Update statements in SQL with example.

5. Q5) Explain the ACID properties of a database transaction.

6. Q6 Define the following:

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

   1. Value set
   2. Complex Attribute
   3. Data model
   4. Schema
   5. Metadata

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

SECTION-B

UNIT-I

7. Q7) Explain 1NF, 2NF and 3NF with example.

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

8. Q8) What is a functional dependency and who specifies the functional dependencies that hold among the attributes of a relation schema?

UNIT-II

9. Q9) Explain Relation Algebra Operation with examples.

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

10. Q10) What is a data model? Compare and contrast hierarchical, network and relational data models.

UNIT-III

11. Q11) Discuss five components of DBMS environment and discuss how they relate to each other.

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

12. Q12) List certain advantages and disadvantages of DBMS.

UNIT-IV

13. Q13) What is meant by integrity constraint? Explain the importance of referential integrity constraint how referential integrity constraint is implemented in SQL.

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

14. Q14) Explain the Three phases of ARIES Recovery model.

SECTION-C

15. Q15)

    Book Title	Auth Name	Book Type	List Price	Affiliation	Publication

    FDS {Book_title ? Book_type, Publication

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

    Auth_name ? Affiliation

    Book_type ? List Price}

    Find the key and Normalize.

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

FirstRanker.com