Seat No.: Enrolment No.
GUJARAT TECHNOLOGICAL UNIVERSITY
--- Content provided by FirstRanker.com ---
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:
--- Content provided by FirstRanker.com ---
- Attempt all questions.
- Make suitable assumptions wherever necessary.
- Figures to the right indicate full marks.
Q.1 (a) What is three-schema architecture for database development? Discuss the difference between 07 user views, a conceptual schema, and an internal schema as different views of the same database.
(b) Explain data, information and metadata with examples. 07
--- Content provided by FirstRanker.com ---
Q.2 (a) Differentiate between attribute, entity and entity instance. Explain the different types of attributes 07 with examples.
(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
--- Content provided by FirstRanker.com ---
(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 07 to other approaches.
Q4 (a) Define join. Explain in brief the various types of joins. 07
--- Content provided by FirstRanker.com ---
(b) Explain cardinality constraints..List different types of cardinality constraints, and draw an 07 example of each.
OR
Q4 (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 07 dynamic views.
Q.5 (a) Briefly describe problems that often arise in merging relation and common techniques for 07 addressing those problems.
--- Content provided by FirstRanker.com ---
(b) Explain relational database management system and also discuss the advantages gained by the 07 adoption of the standardized relational language.
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
--- 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 ---