GUJARAT TECHNOLOGICAL UNIVERSITY
MBA - SEMESTER 3 - EXAMINATION — WINTER 2018
--- Content provided by FirstRanker.com ---
Subject Code: 3539251 Date:07/12/2018Subject Name: Relational Database Management System (RDBMS)
Time: 10:30 AM To 01:30 PM Total Marks: 70
Instructions:
- Attempt all questions.
- Make suitable assumptions wherever necessary.
- Figures to the right indicate full marks.
--- Content provided by FirstRanker.com ---
Q:1 (a) Answer the following questions. 14
A. Database
B. Meta data
--- Content provided by FirstRanker.com ---
C. EntityD. Attribute
E. Cardinality
F. SQL
G. DML
--- Content provided by FirstRanker.com ---
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
--- Content provided by FirstRanker.com ---
(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
--- Content provided by FirstRanker.com ---
(b) Explain relational data structure with consideration of Employee database of any organization. 7
OR
Q:4 (a) Explain decomposition with proper example. 7
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.
--- Content provided by FirstRanker.com ---
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
--- Content provided by FirstRanker.com ---
This download link is referred from the post: GTU MBA Last 10 Years 2010-2020 Question Papers || Gujarat Technological University
--- Content provided by FirstRanker.com ---