Download GTU MBA 2018 Summer 3rd Sem 2830401 Database Management Question Paper

FirstRanker.com

GUJARAT TECHNOLOGICAL UNIVERSITY
MBA - SEMESTER 03 - EXAMINATION - SUMMER-2018

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

Subject Code: 2830401 Date:03/05/2018
Subject Name: DATABASE MANAGEMENT
Time: 2:30 PM To 5:30 PM Total Marks: 70

Instructions:
1. Attempt all questions.

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

2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.

Q.1 (a) In DBMS what D Stands for 6
1. A. Dependency B. Distribution
C. Data D. Direct

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

2. In E-R Diagram, what is the symbol of Entity?
A. Rectangle B. Diamond
C. Circle D Eclipse
3. DQL Stands for
A. Direct Query B. Dependency Queuing

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

Language Language
C. Data Query Language D. Distribution Queuing Language
4. What is the use of Insert Command in SQL
A. To Insert the records B. To Modify the records
C. To Remove the D. To retrieve the records

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

records
5. Key is work as reference of another table
A. Primary B. Foreign
C. Composite D. Candidate
6. If user has inserted Birthdate as an attribute in his entity, the age is

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

considered as attribute
A. Strong B. Weak
C. Simple D. Derived

Q.1 (b) Define: 04
1. Metadata

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

ii. Foreign Key
iii. Composite Attribute
iv. Commit

Q.1 (c) List out the Database Models and Explain any one in 04
brief.

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

Q.2 (a) What is the need of Database system? Explain its 07
usefulness with suitable example.

(b) What do you mean by Entity and Attributes? Discuss 07
any three types of attributes with suitable example.

OR

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

FirstRanker.com

Q.3 (a) Mr. X wants to develop an online furniture shop 07
where the customer can register and make request for
the furniture product by the different categories and
can also place an order as per the need. Customer can

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

also make payment via online or offline ways. Draw
an Entity Relationship diagram for the above
problem.

(b) Discuss : Candidate Key and Primary Key 07

OR

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

Q.3 (a) Discuss DML in brief. 07

(b) Mr. Amar wanted to develop a hotel management 07
system, where customer can register and also able to
find whether the hotel or table is available or not on
specified date. Customer can also able to book table

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

on the specified date and also able to pay for the
same through online payment mode. Customer can
able to give feedback for the hotel or services only if
the user has booked.
Draw an E-R Diagram for the above problem.

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

Q4 (a) Discuss the use of Select Statement in brief. 07

(b) Discuss Data Independence with its different types. 07

OR

Q4 (a) How strong entity plays a significant role in E-R 07
diagram? Explain with suitable example.

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

(b) Discuss OLAP in brief. 07

Q.S The railway reservation system facilitates the 14
passengers to enquire about the trains available on
the basis of source and destination, booking and
cancellation of tickets, enquire about the status of the

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

booked ticket, etc. The aim of case study is to design
and develop a database maintaining the records of
different trains, train status, and passengers. The
record of train includes its number, name, source,
destination, and days on which it is available,

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

whereas record of train status includes dates for
which tickets can be booked, total number of seats
available, and number of seats already booked. The
database has been developed and tested on the
Oracle.

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

OR

Q.S Draw an E-R Diagram for Online Movie Booking 14
System.