1
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MBA SEMESTER 03- • EXAMINATION SUMMER-2018
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.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1
In DBMS what D Stands for
6
1.
A.
Dependency
B.
Distribution
C.
Data
D.
Direct
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 Language
B.
Dependency Queuing 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 records
D.
To retrieve the 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 considered as attribute
A.
Strong
B.
Weak
C.
Simple
D.
Derived
Q.1

Define:
i. Metadata
ii. Foreign Key
iii. Composite Attribute
iv. Commit
04
Q.1

List out the Database Models and Explain any one in brief.
04
Q.2

What is the need of Database system? Explain its usefulness with suitable example.
07

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

What do you mean by Instance and Schema? Explain with suitable example.
07
Q.3

Mr. X wants to develop an online furniture shop 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 also make payment via online or offline ways. Draw an Entity Relationship diagram for the above problem.
07

Discuss Candidate Key and Primary Key
07
OR
Q.3

Discuss DML in brief.
07

Mr. Amar wanted to develop a hotel management 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 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.
07
Q.4

Discuss the use of Select Statement in brief.
07

Discuss Data Independence with its different types.
07
OR
Q.4

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

Discuss OLAP in brief.
07
Q.5
The railway reservation system facilitates the 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 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, 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.
14
OR
Q.5
Draw an E-R Diagram for Online Movie Booking System.
14