Data Base Management System Week 4 NPTEL Assignment Answers 2025

Need help with this week’s assignment? Get detailed and trusted solutions for Data Base Management System Week 4 NPTEL Assignment Answers. Our expert-curated answers help you solve your assignments faster while deepening your conceptual clarity.

✅ Subject: Data Base Management System (nptel dbms answers)
📅 Week: 4
🎯 Session: NPTEL 2025 July-October
🔗 Course Link: Click Here
🔍 Reliability: Verified and expert-reviewed answers
📌 Trusted By: 5000+ Students

For complete and in-depth solutions to all weekly assignments, check out 👉 NPTEL Data Base Management System Week 4 Assignment Answers

🚀 Stay ahead in your NPTEL journey with fresh, updated solutions every week!

NPTEL Data Base Management System Week 4 Assignment Answers 2025

1.

Answer : See Answers

2. Consider the relation MachineParts (MachineNo, PartNo, Color, Shape, Position) with the fol-lowing Functional Dependencies:
FD1: PartNo → {MachineNo, Color}
FD2: MachineNo → Shape
FD3: {Color, Shape} → Position
FD4: Position → PartNo
Which of the following is not a candidate key?

a) (Color, Shape,
b) {MachineNo, Shape}
c) {MachineNo, Color}
d) Position

Answer :

3. Consider the relation MachineParts (MachineNo, PartNo, Color, Shape, Position) with the fol-lowing Functional Dependencies:
FD1: PartNo → {MachineNo, Color}
FD2: MachineNo → Shape
FD3: {Color, Shape} → Position
FD4: Position → PartNo
Which of the following attributes is(are) present both in the closure of Position and MachineNo?

a PartNo
b) Color
c) Shape
d) Position

Answer :

4. A online game maker company maintains a relation OnlineRace with attributes like GameID, Player,
CarType, CarColor, RaceTime, Laps. GameID can uniquely identify all other attributes. Player
can uniquely identify CarType. Laps is identified by RaceTime. What is the highest normal form of OnlineRace?

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

Answer :

5. In a relation Donor, the attributes are: donorID, dName, dAddress, and dBloodGroup. The at-tribute donorID can uniquely identify dName, dAddress. The attribute dName can uniquely iden-tify dBloodGroup. If a donor, having donor ID = D01, dName = Kiran, dAddress = Kolkata and
dBloodGroup = A+ was registered and recorded under the schema, which of the following records will be invalid as another entry in Donor?

a) Donor having donor ID=D02, dName=Kiran, dAddress=Mumbai, dBloodGroup=B+.
b) Donor having donor ID=D02, dName=Kiran, dAddress=Kolkata, dBloodGroup=A+.
c) Donor having donorID=D02, dName=Nikhil, dAddress=Mumbai, dBloodGroup=B+.
d) Donor having donor ID=D02, dName=Nikhil, dAddress=Mumbai, dBloodGroup=A+.

Answer : See Answers

6. Consider the relational schema Seminar (SType, SDate, Venue, Topic, Candidates) with the fol-lowing functional dependencies:
FD1: SType → {SDate, Venue, Topic}
FD2: {SDate, Venue, Topic, → Candidates
FD3: Candidates → Venue, Topic}
If FD1 is removed, what will be the correct representation of the schema for Seminar?

a) Seminar(SType, SDate, Venue, Topic, Candidates)
b) SeminarSType, SDate, Venue, Topic, Candidates)
c) Seminar(SType, SDate, Venue, Topic, Candidates)
d) SeminarSType, SDate, Venue, Topic, Candidates)

Answer :

7. Consider the relation PhotoAlbum (Page, Topic, Camera, Locality) with the following Functional
Dependencies:
FD1: {Page, Topic} → {Camera, Locality}
FD2: {Topic, Camera) → Locality
PhotoAlbum is decomposed into the following:
PhotoAlbum (Page, Topic, Camera) and
PhotoAlbum2 (Page, Topic, Locality)
Which of the following statements is(are) true?

a) The decomposition is lossless but not dependency preserving.
b) The decomposition is not lossless but dependency preserving.
c) The decomposition is both lossless and dependency preserving.
d) The decomposition is neither lossless nor dependency preserving.

Answer :

8. Consider the relation Chocolate(MR, Name, Type, Flavor, Rating) with the following Func-
tional Dependencies:
FD1: MFR → {Name, Type)
FD2: Name → Flavor
FD3: {Type, Flavor) → Rating
FD4: Rating → MFR
What is the maximum number of candidate keys for the relation Chocolate?

a) 2
b) 3
c) 4
d) 5

Answer :

9.

Answer :

10. Consider the relation TravelGuide(TravelID, Days, Location, Type, Budget) with the follow-ing functional dependencies:
FD1: TravelID→{Days, Location}
FD2: Days→Type
FD3: {Location, Type)→Budget
FD4: Budget → {Days, TravelID}
Which of the following functional dependencies violate the BCNF form?

a) FD1
b) FD2
c) FD3
d) FD4

Answer : See Answers