NPTEL Data Base Management System Week 4 Assignment Answers 2024
1.
Answer :- For Answer Click Here
2. Consider the relation Email(Sender, Receiver, Date, Time, Subject) with the following
functional dependencies.
FD1: (Receiver, Date)-Time
FD2: [Sender, Date) →(Receiver, Subject)
FD3: Receiver Subject
What is the highest normal form for the given relation?
a) 1 NF
b) 2 NF
c) 3 NF
d) BCNF
Answer :- For Answer Click Here
3. Consider the relation Office(OID, Emp, Branch, Dept) with the following functional depen-dencies:
FD1: (OID, Emp) -Branch
FD2: Branch-Dept
FD3: Dept →01D
How many candidate keys are there for the given relation?
a) 1
b) 2
c) 3
d) 4
Answer :-
4. Consider the relation TICKET(PNR, DERARTURE, ARRIVAL, SEATNO, COACHNO) with the fol-lowing functional dependencies.
FD1: (PNR, DEPARTURE) ARRIVAL
FD2: ARRIVAL SEATNO
FD3: (DEPARTURE, SEATNO) -COACHNO
Which of the following attributes cannot functionally determine COACHNO?
a) {ARRIVAL}
b) {PNR, DEPARTURE)
c) {PNR, DEPARTURE, ARRIVAL)
d) {DEPARTURE, ARRIVAL)
Answer :- For Answer Click Here
5. Find the canonical cover of Relation R=(A, B, C) where F=(A-›BC, B»C, A»в, AB+C)?
a) A-BC
b) A→B, B→C
c) А→В, AB-С
d) A→BC, АВ→›С
Answer :-
6.
Answer :-
7. Consider a relation Customer (CID, NAME, ADDRESS) with the following functional dependen-
cies.
FD1: CID→›NAME
FD2: NAME→ ADDRESS
The current instance of this schema contains the tuple {121, Lucy, Delhi}.
Which of the following tuples can be inserted?
a) (255, Tom, Kolkata}
b) {137, Lucy, Delhi}
c) {233, Lucy, Mumbai}
d) {121, Jenny, Kolkata)
Answer :-
8. The relation RA,B, C, D, E, F, G) with the functional dependencies: ( A → B, A → C, AE – D, AEF → G } is normalised into BCNF.
Which of the following decomposition is obtained as a result of this normalisation?
a) R, (A, B, F), Re(E, C, D), Ra(A, G)
b) Ri(A, B, C), R2(A, E, D), R3(A, E, F, G)
c) Ri(A. D, C), R2(A, B, D), R3(A, D, F, G)
d) Ri (A. B, C, F, G), R2(A, E, D)
Answer :- For Answer Click Here
9.
Answer :-
10. Consider the relation DVDLibrary (Name, Company, Format, Price) with the following Func- tional Dependencies:
FD1: (Name, Company) → (Format, Price)
FD2: Company → Format
FD3: Format → Price
Which of the following statements is (are) true?
a) The primary key for DVDLibrary is Company.
b) DVDLibrary is in 2NF.
c) Decomposition of DVDLibrary into DVDLibrary1 (Name, Company, Format), DVDLibrary2 (Company, Price) will not be dependency preserving.
d) Decomposition of DVDLibrary into DVDLibrary1(Name, Company, Format), DVDLibrary2 (Company, Price) will be lossy.
Answer :- For Answer Click Here
