NPTEL Data Base Management System Week 4 Assignment Answers 2024

Join Our WhatsApp Group Join Now
Join Us On Telegram Join Now

NPTEL Data Base Management System Week 4 Assignment Answers 2024

1. Consider the relation R(X, Y,Z,V,W) which satisfies the following functional dependencies:
XY → Z
YZ → V
ZV → W
VW → X
XW → Y
Which of the following functional dependencies are also guaranteed to be satisfied by relation R?

a) XZ → V
b) YZV → X
c) Z → W
d) X → 2

Answer :- For Answer Click Here 

2. Consider the relation Student (Reg-No, Name, Address, Phone, Class_ID) and the set of
following functional dependencies:

  • FDI: Reg_No → Name
  • FD2: Address, Phone → Class_ID
  • FD3: Name → Phone
  • FD4: Class_ID → Reg-No, Address

    Which of the following are possible sets of candidate key(s) of Student?

    a) Reg_No
    b) Address, Phone
    c) Name
    d) Class_ID
Answer :- For Answer Click Here 

3.

NPTEL Data Base Management System Week 4 Assignment Answers 2024
Answer :- For Answer Click Here 

4.

NPTEL Data Base Management System Week 4 Assignment Answers 2024
Answer :- 

5. In a relation MountainTreking(Altitude, MName, Location, MType, TrekkerAge, Climate, TrekkerExp), Altitude identifies MName and Location. Also, MName, MType, TrekkerAge and Climate combined determines the TrekkerExp, MType. TrekkerAge of the MountainTreking are dependent on Altitude and Climate together. Which of the following are the non-prime attributes of Mountain?

a) Altitude
b) TrekkerAge
c) Climate
d) TrekkerExp

Answer :- 

6.

NPTEL Data Base Management System Week 4 Assignment Answers 2024
Answer :- For Answer Click Here 

7. Consider the relational schema Flight (FNo, SeatNo, Window, Pilot, Duration) with the following functional dependencies:
FNo {Pilot, SeatNo}
Duration →{FNo, Window}

Which of the following decomposition of Flight is lossless?

a) F1(FNo, Duration), F2(SeatNo, Window, Pilot, Duration)
b) F1(FNo, SeatNo), F2(Window, Pilot, Duration)
c) F1(FNo, Window), F2(SeatNo, Pilot, Duration)
d) F1(FNo, Pilot), F2(SeatNo, Window, Pilot, Duration)

Answer :- 

8.

NPTEL Data Base Management System Week 4 Assignment Answers 2024
Answer :- 

9.

NPTEL Data Base Management System Week 4 Assignment Answers 2024
Answer :- 

10. Determine the highest Normal Form of the relation Restaurant (Dish, Chef, Table, Price) having the following complete set of functional dependencies.
Dish → Chef, Table
Table → Price

a) 1 NF
b) 2 NF
c) 3 NF
d) BCNF

Answer :- For Answer Click Here