Printed Page: 1 of 1
Subject Code: KMBNIT03
0Roll No: 0 0 0 0 0 0 0 0 0 0 0 0 0
MBA
(SEM IV) THEORY EXAMINATION 2023-24
DATA BASE MANAGEMENT SYSTEM
TIME: 3 HRS [Link]: 100
Note: 1. Attempt all Sections. If require any missing data; then choose suitably.
SECTION A
1. Attempt all questions in brief. 2 x 10 = 20
Q no. Question Marks C
O
a. Define DML 02 1
b. What do you understand by DBMS? 02 1
c. Define primary key. 02 2
d. Differentiate Super key and Candidate key. 02 2
e. Discuss the concept of indexes in SQL. 02 3
f. List out the types of Functional Dependencies. 02 3
g. What is Log based Recovery? 02 4
h. Explain Concurrency control. 02 4
i. Expand OODB. 02 5
j. Write down the problem areas of distributed data base system. 02 5
0
13
11
SECTION B
7.
_3
2. Attempt any three of the following: 3 x 10 = 30
.6
P1
a. Define E-R model with example. How to convert an E-R model into relational 10 1
45
schema?
4E
.2
b. Describe the tuple relational calculus with example. 10 2
15
P2
c. Explain 1NF, 2NF and 3NF with example. 10 3
|1
Q
d. Discuss the concept of serializability with the help of inferring serial and 10 4
non-serial schedules.
PM
e. “Data Mining is the backbone of Data Warehousing”. Explain. 10 5
SECTION C
51
3. Attempt any one part of the following: 1 x 10 = 10
3:
a. Draw the overall structure of DBMS and explain its various components. 10 1
3
b. Distinguish strong entity set with weak entity set? Draw an ER diagram to 10 1
1:
illustrate weak entity set?
4. Attempt any one part of the following: 1 x 10 = 10
4
02
a. Define relational algebra. Explain various relational algebraic operations with 10 2
example.
l-2
b. Discuss various types of schemas in Database management system with diagram. 10 2
Ju
5. Attempt any one part of the following: 1 x 10 = 10
a. What are the various data types in SQL? Explain them with example? 10 3
3-
b. Explain functional dependencies? Write the types of functional dependencies, 10 3
|0
also.
6. Attempt any one part of the following: 1 x 10 = 10
a. List the ACID properties. Explain the usefulness of each with example. 10 4
b. Explain Deadlock in detail with an example. 10 4
7. Attempt any one part of the following: 1 x 10 = 10
a. Explain in detail the Client - Server Architecture for DDBMS 10 5
b. List out the differences between spatial and geographical databases. 10 5
1|Page
QP24EP1_311 | 03-Jul-2024 1:33:51 PM | [Link]