Seat No: ______________ Enrollment No: ____________________

PARUL UNIVERSITY
FACULTY OF ENGINEERING & TECHNOLOGY
B.Tech./ Int. BTech Winter 2023 - 24 Examination
Semester: 3,7 Date: 22-11-2023
Subject Code: 303105203 Time: 2:00 pm to 4:30 pm
Subject Name: Database Management System Total Marks: 60
Instructions:
1. All questions are compulsory.
2. Figures to the right indicate full marks.
3. Make suitable assumptions wherever necessary.
4. Start new question on new page.

Q.1 Objective Type Questions - (15) CO PO Bloom’s

Taxonomy
1. Typically, a database administrator (DBA) is responsible for: 1 1 Find
A. Schema definition
B. Schema modification
C. Granting of authorization for data access
D. All of the above
2. Consider an ER diagram given below for Bank database. 2 3 Identify

Identify the correct statement regarding the above diagram

A. Bank-Branch is the weak entity

B. Branch No of the Bank-Branch entity is a partial Key
C. The Participation of BANK in BRANCHES Relationship is
partial
D. All of the above
3. Consider the following statements: 3 2 Analyze
P. Tuple Relational Calculus (TRC) is a non-procedural query
language
Q. Tuple Relational Calculus (TRC) expression specifies what is to
be retrieved rather than how to retrieve it.
A. P is true and Q is false
B. Both P and Q are true and Q is the correct reason for P
C. Both P and Q are true and Q is not the correct reason for P
D. Both P and Q are false
4. The join operation on two relations can be regularly realized by 3 4 choose
doing
A. A cartesian product of the two relations followed by a
selection
B. A cartesian product of the two relations
C. A union of the two relations followed by a selection
D. A union of two relations
5. Which of the following SQL sub-language constructs are used to 6 5 choose
insert rows into tables?
A. DDL
B. DML
C. Transaction control language
D. None of the above
6. _____________ predicate is used to search for patterns in target 6 5 identify
string in SQL query.
Page 1 of 2
 7. _____________ command is used to delete a table with its structure. 6 5 identify
8. The difference relational algebra operator requires its operands to be 3 2 True/False
union-compatible (True/False).

9. Data about data is known as__________. 1 1 blanks

10. Define: Generalization 2 3 define

11. Compare: simple attributes Vs. composite attribute 2 2 compare

12. Which are transaction ACID properties? 4 8 write
13. What is Symmetric key encryption? 5 7 define

14. Define: SQL injection 5 7 define

15. What do you mean by view in database? Write the syntax for 6 5 write
creating a view.
Q.2 Answer the following questions. (Attempt any three) (15)
A) Explain different levels of database architecture with appropriate 1 1 Explain
example.
B) Write only name of different types of FDs. Consider a relation 3 3 Find
R(W, X, Y, Z) and the set of all FDs that hold on R as
{WX → YZ, Y → W, Z → X}
I. Closer set of WX, Y and Z
II. Find all possible candidate keys
III. Prime attributes
C) Define Transaction. Explain its life cycle with diagram. 4 4 define
D) What do you mean by cursor? Explain its types. 6 5
Q.3 A) Create following tables and then write given SQL queries. (07) 6 5 Write,
create
EMP (empno, ename, jobtitle, managerno, hiredate, sal, comm, implement
deptno)
DEPT (deptno, dname, loc)
Answer the following queries in SQL
1. Display the Employees working in the department 10, 20, 30
only.
2. Display Employees whose names start with letter ‘A’ or ‘a’.
3. List ename who are having job title as “project manager”.
4. Display the employee details whose joining date is in ‘JUNE’
month.
5. Display Employee names along with their department names.

B) Explain following integrity constraints with example. (08) 2 3 Explain

i) Primary key
ii) Foreign key
iii) Unique key
iv) Check
OR
B) What is normalization in DBMS? Also discuss the need of (08) 2 3 Discuss
normalization. Explain 2NF,3NF, BCNF with suitable example.
Q.4 A) Construct the chart of query processing. Also describe all phases of (07) 5 8 Construct
query processing techniques in detail.
OR
A) Compare following: (07) 5 7 Compare
1. Security Vs. Integrity
2. Authentication Vs Authorization

B) Discuss serializability with its type. Also state the advantages of (08) 4 8 Discuss
serializability.

Page 2 of 2