Download GTU MBA 2016 Winter 3rd Sem 2830401 Database Management Dm Question Paper

Download GTU (Gujarat Technological University) MBA (Master of Business Administration) 2016 Winter 3rd Sem 2830401 Database Management Dm Previous Question Paper

Page 1 of 1

Seat No.: ________ Enrolment No.___________

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

Subject Code: 2830401 Date: 03/01/2017
Subject Name: Database Management (DM)
Time: 02:30 pm - 05: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) What is three-schema architecture for database development? Discuss the difference between
user views, a conceptual schema, and an internal schema as different views of the same database.
07
(b) Explain data, information and metadata with examples. 07
Q.2 (a) Differentiate between attribute, entity and entity instance. Explain the different types of attributes
with examples.
07
(b) Discuss the COMMIT and ROLLBACK command in SQL with examples. 07
OR
(b) Explain DDL, DML and DCL in detail. 07
Q.3 (a) Discuss different types of databases and parameters affecting their implementation. 07
(b) What are the special guidelines for naming relationships? 07
OR
Q.3 (a) Explain Attribute inheritance in detail and also discuss Generalization & Specialization rule. 07
(b) What is client/server architecture? List major advantages of the three-tier architecture compared
to other approaches.
07
Q.4 (a) Define join. Explain in brief the various types of joins. 07
(b) Explain cardinality constraints. List different types of cardinality constraints, and draw an
example of each.
07
OR
Q.4 (a) Discuss degree of relationships. Explain Unary, Binary and Ternary relationships in detail. 07
(b) What is the difference between base table and virtual table? Discuss pros and cons of using
dynamic views.
07
Q.5 (a) Briefly describe problems that often arise in merging relation and common techniques for
addressing those problems.
07
(b) Explain relational database management system and also discuss the advantages gained by the
adoption of the standardized relational language.
07
OR
Q.5 (a) Define Referential Integrity Constraints. Explain Insert, Delete, Update anomalies with example. 07
(b) Compare SDLC with RAD and Agile software development approach.
***************
07

FirstRanker.com - FirstRanker's Choice