Download GTU MBA 2018 Winter 3rs Sem 3539251 Relational Database Management System Rdbms Question Paper

Download GTU (Gujarat Technological University) MBA (Master of Business Administration) 2018 Winter 3rs Sem 3539251 Relational Database Management System Rdbms Previous Question Paper

1 | P a g e


Seat No.: ________ Enrolment No.___________

GUJARAT TECHNOLOGICAL UNIVERSITY
MBA ? SEMESTER 3 ? EXAMINATION ? WINTER 2018

Subject Code: 3539251 Date:07/12/2018
Subject Name: Relational Database Management System (RDBMS)
Time: 10:30 AM To 01:30 PM Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.

Q: 1 (a) Answer the following questions.
A. Database
B. Meta data
C. Entity
D. Attribute
E. Cardinality
F. SQL
G. DML
14

Q: 2 (a) Explain disadvantages of conventional file based system over DBMS. 7
(b) Explain the database architecture with necessary examples. 7
OR
(b) Explain various components of database management system. 7

Q: 3 (a) Explain Hierarchical database model with proper example. 7
(b) Explain various keys available in ER diagram. 7
OR
(a) Explain Normalization process with suitable examples. 7
(b) Explain Logical database model with example. 7

Q: 4 (a) Explain Codd?s rule with proper examples. 7
(b) Explain relational data structure with consideration of Employee database of
any organization.
7
OR
Q: 4 (a) Explain decomposition with proper example. 7
FirstRanker.com - FirstRanker's Choice
1 | P a g e


Seat No.: ________ Enrolment No.___________

GUJARAT TECHNOLOGICAL UNIVERSITY
MBA ? SEMESTER 3 ? EXAMINATION ? WINTER 2018

Subject Code: 3539251 Date:07/12/2018
Subject Name: Relational Database Management System (RDBMS)
Time: 10:30 AM To 01:30 PM Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.

Q: 1 (a) Answer the following questions.
A. Database
B. Meta data
C. Entity
D. Attribute
E. Cardinality
F. SQL
G. DML
14

Q: 2 (a) Explain disadvantages of conventional file based system over DBMS. 7
(b) Explain the database architecture with necessary examples. 7
OR
(b) Explain various components of database management system. 7

Q: 3 (a) Explain Hierarchical database model with proper example. 7
(b) Explain various keys available in ER diagram. 7
OR
(a) Explain Normalization process with suitable examples. 7
(b) Explain Logical database model with example. 7

Q: 4 (a) Explain Codd?s rule with proper examples. 7
(b) Explain relational data structure with consideration of Employee database of
any organization.
7
OR
Q: 4 (a) Explain decomposition with proper example. 7
2 | P a g e

(b) What is DML? Explain various commands available under DML with suitable
examples.
7

Q: 5 Homefab is one of the leading furniture showrooms in Ahmedabad. They have
their own designing workshop for different furniture requirements. Now
owner Mr. Virendra wants to digitalize all the available database of sales
people, employee, customer, product line, vendor list & details of raw
material.

Using this information create ER diagram for Homefab furniture.
14
OR
Q: 5 (a) For the above case, write various SQL database definition commands 7
(b) For the above case, write various SQL transactional control commands. 7


*************
Best of Luck
FirstRanker.com - FirstRanker's Choice