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

FirstRanker.com

Seat No.: Enrolment No.

GUJARAT TECHNOLOGICAL UNIVERSITY

--- Content provided by FirstRanker.com ---

MBA — SEMESTER 3 - EXAMINATION - WINTER 2015

Subject Code:2830401 Date: 03/12/2015

Subject Name: Database Management

Time: 10.30 AM to 01.30 PM Total Marks: 70

Instructions:

--- Content provided by⁠ FirstRanker.com ---

1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.

Q.1 (a)

1. Entity is a
   1. Object of relation

   --- Content provided by‍ FirstRanker.com ---

   2. Present working model
   3. Thing in real world
   4. Model of relation
2. A relational database consists of a collection of
   1. Tables

   --- Content provided by‍ FirstRanker.com ---

   2. Fields
   3. Records
   4. Keys
3. Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
   1. DML(Data Manipulation Language)

   --- Content provided by​ FirstRanker.com ---

   2. DDL(Data Definition Language)
   3. Query
   4. Relational Schema
4. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
   1. DML(Data Manipulation Language)

   --- Content provided by‌ FirstRanker.com ---

   2. DDL( Data Definition Language)
   3. Query
   4. Relational Schema
5. The entity set person is classified as student and employee. This process is called
   1. Generalization

   --- Content provided by​ FirstRanker.com ---

   2. Specialization
   3. Inheritance
   4. Constraint generalization
6. Which of the following is not modification of database
   1. Deletion

   --- Content provided by⁠ FirstRanker.com ---

   2. Insertion
   3. Sorting
   4. Updating

Q.1 (b) Define: 04

--- Content provided by⁠ FirstRanker.com ---

1. Entity
2. Referential Integrity
3. Candidate Key
4. Meta data

Q.1 (c) Explain Multitier Client/Server Databases 04

--- Content provided by‌ FirstRanker.com ---

Q.2 (a) Explain Working of Two tier client/server database architecture with reference to an Educational Institution. 07

OR

Q.2 (b) Clearly define the ER diagram for database of Paper manufacturing company with cardinality ratio. 07

Q.3 (a) Explain Insert, Delete and Update command in SQL and give example for every command. 07

Q.3 (b) Write down the steps in building the data model by using E-R Diagram Approach. 07

--- Content provided by‌ FirstRanker.com ---

OR

Q.4 (a) Explain TCL and DQL with proper syntax 07

Q.4 (b) Explain SQL and How it is used to create and edit database. 07

Q.5 (a) Explain base table and virtual table. Discuss Dynamic view with Pros and Cons. 07

Q.5 (b) Describe the JOIN operation. What does it accomplish? Explain with Example. 07

--- Content provided by‌ FirstRanker.com ---

OR

Q.5 (a) Write Short note on 07

1. Network model
2. Hierarchical Model

Q.5 (b) Who is DBA? Explain the functions of DBA in Automobile parts manufacturing company. 14

--- Content provided by​ FirstRanker.com ---

Q.6 (a) Develop a Database application for Stationary Supplier by considering Software development life cycle approach. 14

OR

Q.6 (b) Develop an E-R diagram to keep record of the patients admitted to the hospital. 14