Quiz Space

Database Management Systems · End Term · 13 Sept 2026 · May 2026 term

Question 3: Consider the relational schema R(A, B, C, D, E, F), where…

Question 3

+3 marksOne correct option

Consider the relational schema R(A, B, C, D, E, F), where the domains for A, B, C, D, E and F include atomic values only. If R satisfies the functional dependencies {AB → CDE, ABC → EF, E → F}, then identify the correct statement(s).

  1. A

    R is in 2NF and also in 3NF

  2. B

    R is in 2NF but not in 3NF

  3. C

    R is in BCNF but not in 3NF

  4. D

    R is in 3NF and also in BCNF

Show answer

Correct answer

  • B

    R is in 2NF but not in 3NF

See the whole paperTake it as a mock test

Question 3 of 18 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 13 Sept 2026, in the May 2026 term (Database Management 13 Sep 26). It carries 3 marks.

More questions from this paper

  1. Q1Figure question
  2. Q2Figure question
  3. Q4Figure question
  4. Q5Consider the following ER relationship: Which of the following statements is correct?
  5. Q6Figure question
  6. Q7Which of the following could be the hash function used by the file?
  7. Q8Figure question
  8. Q9Figure question
  9. Q10Figure question
  10. Q11Figure question
  11. Q12Figure question
  12. Q13Figure question
  13. Q14Consider the following schedule S and answer question Which of the following is/are correct?
  14. Q15Consider the following relation Employee. A bitmap index is constructed on the attribute Team, with one bitmap for each…
  15. Q16Consider the following statements.\ In RAID 2, the Hamming code is used for parity. 2. RAID 4 has a striping unit of di…
  16. Q17Consider a Block nested loop join for the two relations, employee and project. Assuming the worst-case memory availabil…
  17. Q18Consider the following backup schedule used by a company: If a system failure occurs on Sunday before the backup for th…