NPTEL Data Base Management System Week 4 Assignment Answers 2025
1. Consider the relation MchineParts(PartNo, MachineNo, 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 :- For Answers Click Here
2. Consider the following relational schema: Airway(Flno, Finame, Source, Destination).
The following functional dependencies hold:
FD1: Flname → Source
FD2: Source → Flno
FD3: Source → Destination
What is the highest normal form of Airway?
a) 1NF
b) 2NF
c) 3NF
d) BCNF
Answer :-
3. Consider the relational schema Investor (InvestmentNo, Amount, Tenure). Two organisations iden- tify 2 different sets of Functional Dependencies for Investor:
OrganisationA={|
FD1: InvestmentNo → {Amount, Tenure}
FD2: Amount → InvestmentNo
FD3: Tenure → InvestmentNo
OrganisationB={
FD1: InvestmentNo → Amount
FD2: Amount → Tenure
FD3: Tenure → InvestmentNo
Which of the following statements is(are) true?
a) Only OrganisationA covers OrganisationB.
b) Only OrganisationB covers OrganisationA.
c) OrganisationA and OrganisationB are equivalent.
d) OrganisationA and OrganisationB cannot be compared.
Answer :-
4.
Answer :-
5. In a relation BloodDonation, the attributes are: Donor ID, DonorName, DonorAddress, and DonorBloodGroup. Donor ID can uniquely identify DonorName, DonorAddress. DonorName can uniquely identify DonorBloodGroup. If the first donor, having Donor ID = A1, DonorName = Aman, DonorAddress = Kolkata and DonorBloodGroup = A+ was registered and recorded under the schema, which of the following records will be invalid as another entry in BloodDonation?
a) Donor having Donor ID=A2, DonorName=Aman, DonorAddress-Mumbai, DonorBloodGroup=B+.
b) Donor having Donor ID=A2, DonorName=Aman, DonorAddress=Kolkata, DonorBloodGroup=A+.
c) Donor having Donor ID=A2, DonorName=Nikhil, DonorAddress=Mumbai, DonorBloodGroup=B+.
d) Donor having Donor ID=A2, DonorName=Nikhil, DonorAddress=Mumbai, DonorBloodGroup=A+.
Answer :- For Answers Click Here
6. A software company maintains a relation OnlineRace with attributes like GameID, Player, Car Type, CarColor, RaceTime, Laps. GameID can uniquely identify all other attributes. Player can uniquely identify CarType and Laps is identified by RaceTime. What is the highest normal form of OnlineRace?
a) 1NF
b) 2NF
c) 3NF
d) BCNF
Answer :-
7. Consider the relation PollutionControl (FactoryID, EmissionLevel, EmissionEffect, Locality) with the following Functional Dependencies:
FD1: {FactoryID, EmissionLevel} → {EmissionEffect, Locality}
FD2: (EmissionLevel, EmissionEffect) → Locality
PollutionControl is decomposed into the following:
ollutionControl1(FactoryID, EmissionLevel, EmissionEffect) and
PollutionControl2(FactoryID, EmissionLevel, Locality)
Which of the following statements is(are) true?
a) The decomposition is lossless but not dependency preserving.
b) The decomposition is dependency preserving but not lossless.
c) The decomposition is both lossless and dependency preserving.
d) The decomposition is neither lossless nor dependency preserving.
Answer :-
8. Consider the relation TeaMfd, Origin, Type, Flavor, Rating) with the following Functional De-
pendencies:
FD1: Mfd → {Origin, Type}
FD2: Origin → Flavor
FD3: Type, Flavor, → Rating
FD4: Rating → Mfd
What is the maximum number of candidate keys for the relation Tea?
a) 2
b) 3
c) 4|
d) 5
Answer :-
9. Consider the relation TimeCounter (LogID, Days, Hours, Mins, Secs) with the following func-
tional dependencies:
FD1: LogID→Days, Hours}
FD2: Days-Mins
FD3: {Hours, Mins)-Secs
FD4: Secs→LogID
Which of the following functional dependencies violate the BCNF form?
a) FD1
b) FD2
c) FD3
d) FD4
Answer :-
10. Consider the relation Carnival (CID, Location, Span, RideCount, ShowCount, StartTime, EndTime, Crowd) with the following functional dependencies:
FD1: CID→>(Location, Span, RideCount}
FD2: (CID, RideCount)ShowCount
FD3: {ShowCount, StartTime, EndTime}→Crowd
FD4: StartTime→>{EndTime, Crowd}
Which of these functional dependencies can be eliminated without changing the primary key of the relation?
a) FD1
b) FD2
c) FD3
d) FD4
Answer :- For Answers Click Here
