Quiz Space

Database Management Systems · Quiz 2 · 16 Aug 2026 · May 2026 term

Question 13: Consider a relation R(A, B, C, D, E, F, G, H, I, J) havi…

Question 13

+4 marksOne correct option

Consider a relation R(A, B, C, D, E, F, G, H, I, J) having functional dependencies as follows F = {AB → C, D → IJ, A → DE, F → GH}. Select all the correct statements regarding normalization of R.

  1. A

    R can not be normalized completely into BCNF while preserving all the dependencies.

  2. B

    R can not be normalized completely into 3NF while preserving all the dependencies.

  3. C

    If R is completely normalized into BCNF then 5 subtables are formed all in BCNF.

  4. D

    If R is completely normalized into BCNF then 4 subtables are formed all in BCNF.

Show answer

Correct answer

  • C

    If R is completely normalized into BCNF then 5 subtables are formed all in BCNF.

See the whole paperTake it as a mock test

Question 13 of 16 in the IIT Madras BS Database Management Systems (DBMS) Quiz 2 paper sat on 16 Aug 2026, in the May 2026 term (Database Management Indian Institute Of Technology, Madras - Bs In Data Science/ Electronic Systems Systems 14 Aug 26). It carries 4 marks.

More questions from this paper

  1. Q1The relation Students(Name, Total_Marks) contains the names and marks of different students where no two students have …
  2. Q2Consider a relation R(A, B, C, D, E) with following functional dependency set FD : {A → BC, CD → E, B → D, E → A} What …
  3. Q3Consider the relation R(A, B, C, D, E, F) with dependency set FD: {AB → C, E → F, AC → B, BC → A, B → D, AD → E} Follow…
  4. Q4Consider a relation Student(studID, Sname, Age, Sex) where studID is the primary key. How many superkeys are possible f…
  5. Q5Assume no functional dependencies other than those listed hold. Consider relation R(StudentID, StudentName, ClubID, Clu…
  6. Q6A DBMS stores its database on a magnetic disk. While reading a required sector, the disk arm has already moved to the c…
  7. Q7Consider a relation R(A, B, C, D, E) with the following multivalued dependencies: ●A →→ B● B →→ D Suppose relation R co…
  8. Q8Which of the following are correct probe sequences in Binary Search Trees?
  9. Q9Consider the relation schema R(A,B,C) with functional dependency set F = {A → B, B → C} Two database instances I1 and I…
  10. Q10In Python Postgres database connectivity the cursor.fetchmany() method is used to retrieve data from a table. What does…
  11. Q11Consider the above two tables belonging to University database. Select all the SQL queries that would fetch distinct na…
  12. Q12Consider the following ER diagram representing a Library Management System. Select all the correct statements regarding…
  13. Q14Consider the relational schema R(A, B, C, D, E, F, G) with the given dependency set FD: {AB → CD, AF → D, DE → F, C → G…
  14. Q15Consider a string of pending block references in the order given: 4, 2, 3, 4, 5, 2, 7, 3, 5, 2, 5, 3, 4, 2. The system …
  15. Q16Consider the relation R(A, B, C, D, E) with dependency set FD: {A → B, C → D, D → AE, EB → C} How many candidate keys a…