Enrollment No:
PARUL UNIVERSITY
FACULTY OF ENGINEERING & TECHNOLOGY
B.TECH MIDSEM EXAMINATION
3'd SEMESTER (ACY- 2022-231
Subject Name 1203105251): DBMS
Date: 03/0812022
Time: 2:30PM to 4:00PM Total Marks: 40
Q.1
(A) One line Questions 5* 1
a) What is Primary I(ey?
:t
b) Define MultivalLred attribute rvith exarnple.
c) Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic
. values F={cH-rG,A-> BC, B->cFH, E->A, F-> EGiisasetof functional
dependencies (FDs) . find the closer of A
d) The maximum number of superkeys for the relation schema R(E,F,G,H)with E
as the key
e) Explain 3NF with an example ,
(li) Corn pulsory Qucstion 5* I
a)
-
attribute name could be structured as an attribute consisting of first
name, middle initial, and last name
b) Minimal Super key is known as
c) Normalization is used to eliminate
d) Attributes of relations which are part of candidate,key are known as
e) ALTER is _ command.
Q.2 Attenrpt any loLrr 4+ j
1) Explain trivial and non-trivial functional dependency with example
2) Define Super Key and Candidate key with example.
