NPTEL Introduction to Database Systems Week 8 Assignment Answers 2025

By /

NPTEL Introduction to Database Systems Week 8 Assignment Answers 2025

1. Consider the following statements:

S1: All normal-forms are defined using functional dependencies.
S2: Normalization is a top-down process to deal with redundancy in data representation.

Choose the correct option:

  • S1: True; S2: True
  • S1: True; S2: False
  • S1: False; S2: False
  • S1: False; S2: True
Answer :- For Answers Click Here

2. Fill in the blanks:

S1: An attribute of a relation schema R is called a prime-attribute of R if it is a member of some _ _ _ _ _ of R.
S2: An attribute of a relation schema R is called a non-prime-attribute of R if it is NOT a member of any _ _ _ _ of R

  • S1: Candidate-key; S2: Candidate-key
  • S1: Candidate-key; S2: Super-key
  • S1: Super-key; S2: Candidate-key
  • S1: Super-key; S2: Super-key
Answer :-

3. Consider a relation R(A, B, C, D, E, F, G) and the following FDs:

{AB → CD, AF → D, DE → F, C → G, F → E, G → A}. Find out {C​ , F }+ :

  • {C, F}
  • {C, F, G, E}
  • {C, F, G, E, A}
  • {C, F, G, E, A, D}
Answer :-

4. Consider a relation R(A, B, C, D, E, F) and the given FDs

{AB → C, C → D, B → E, DE → F, F → AB}.

Choose the incorrect option:

  • AB is a candidate key of R
  • F is a candidate key of R
  • BC is a candidate key of R
  • CD is a candidate key of R
Answer :-

5. Consider a relation R(part_no, part_description, part_price, supplier_id, supplier_address).

The following FDs hold on R:

part_no → part_description supplier_id → supplier_address {part_no, supplier_id} → part_price

Find the candidate key of relation R:

  • part_no
  • supplier_id
  • {supplier_id, part_no}
  • None of the above
Answer :-

6. Consider the relation given in the Question 5, and find out which of the following statement is TRUE about R:

  • R is in 1NF only
  • R is in 2NF but not in 3NF
  • R is in 3NF but not in BCNF
  • R is in BCNF
Answer :- For Answers Click Here

7. Consider the following statements:

S1: A relation in which every key contains only one attribute is in 2NF.
S2: In a 3NF relation, a non-key attribute may be transitively dependent on the primary key.

Choose the correct option:

  • S1: True; S2: True
  • S1: False; S2: True
  • S1: False; S2: False
  • S1: True; S2: False
Answer :-

8. Consider a relation R(A, B, C, D, E, F, G) and the FD set

F1 = {B → ACD, DE → F, F → D, E → FGB, BCG → CE, EG → CD}.

Let F’ be a minimal cover of F1. Find out the incorrect statement about F’ :

  • F’ contains F → D
  • F’ does not contain DE → F
  • F’ does not contain EG → CD
  • F’ does not contain BG → E
Answer :-

9. Consider a relation R(A, B, C, D, E, F) and the FD set given below

F1 = { AB → C, B → D, D → E, AE → F, C → A }

Choose the correct option:

  • R is in 2NF, but not in 3NF
  • R is not in 2NF
  • R is in 3NF, but not in BCNF
  • R is in BCNF
Answer :-

10. Consider the decomposition of a relation R(A, B, C) into two relations R1(A, B) and R2(B, C) and the given instances of R, R1, and R2. Suppose FD set for R is :{B → A, B → C}.What is TRUE with respect to the decomposition:

  • Lossy; Dependency preserving
  • Lossless; Dependency preserving
  • Lossy; Not Dependency preserving
  • Lossless; Not Dependency preserving
Answer :- For Answers Click Here

Related Posts

Scroll to Top