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

Download PTU (I.K. Gujral Punjab Technical University Jalandhar (IKGPTU) ) MBA (Master of Business Administration) 2020 March 3rd Sem 70760 Relational Database Management System Previous Question Paper

1 | M-70760 (S13)-2023

Roll No. Total No. of Pages : 02
Total No. of Questions : 15
MBA (2016 to 2017) (Sem.?3)
RELATIONAL DATABASE MANAGEMENT SYSTEM
Subject Code : MBA-982
M.Code : 70760
Time : 3 Hrs. Max. Marks : 60

INSTRUCTION TO CANDIDATES :
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
Q1) Define DBMS. Discuss the advantages of DBMS over traditional file system.
Q2) What is the difference between logical data independence and physical data
independence? Which one is harder to achieve and why?
Q3) What is a functional dependency? List the conditions for a set of functional dependencies
to be minimal.
Q4) Explain Insert, Delete, and Update statements in SQL with example.
Q5) Explain the ACID properties of a database transaction.
Q6 Define the following :
a) Value set
b) Complex Attribute
c) Data model
d) Schema
e) Metadata
FirstRanker.com - FirstRanker's Choice
1 | M-70760 (S13)-2023

Roll No. Total No. of Pages : 02
Total No. of Questions : 15
MBA (2016 to 2017) (Sem.?3)
RELATIONAL DATABASE MANAGEMENT SYSTEM
Subject Code : MBA-982
M.Code : 70760
Time : 3 Hrs. Max. Marks : 60

INSTRUCTION TO CANDIDATES :
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
Q1) Define DBMS. Discuss the advantages of DBMS over traditional file system.
Q2) What is the difference between logical data independence and physical data
independence? Which one is harder to achieve and why?
Q3) What is a functional dependency? List the conditions for a set of functional dependencies
to be minimal.
Q4) Explain Insert, Delete, and Update statements in SQL with example.
Q5) Explain the ACID properties of a database transaction.
Q6 Define the following :
a) Value set
b) Complex Attribute
c) Data model
d) Schema
e) Metadata
2 | M-70760 (S13)-2023

SECTION-B
UNIT-I
Q7) Explain 1NF, 2NF and 3NF with example.
Q8) What is a functional dependency and who specifies the functional dependencies that hold
among the attributes of a relation schema?
UNIT-II
Q9) Explain Relation Algebra Operation with examples.
Q10) What is a data model? Compare and contrast hierarchical, network and relational data
models.
UNIT-III
Q11) Discuss five components of DBMS environment and discuss how they relate to each
other.
Q12) List certain advantages and disadvantages of DBMS.
UNIT-IV
Q13) What is meant by integrity constraint? Explain the importance of referential integrity
constraint how referential integrity constraint is implemented in SQL.
Q14) Explain the Three phases of ARIES Recovery model.

SECTION-C
Q15)
Book_Title Auth_Name Book Type List Price Affiliation Publication
FDS {Book_title ? Book_type, Publication
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.
FirstRanker.com - FirstRanker's Choice