Quiz Space

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

Question 14: Consider the relational schema R(A, B, C, D, E, F, G) wi…

Question 14

+4 marksWritten answer

Consider 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, F → E, G → A} How many functional dependencies are there in the canonical/minimal cover of the given FD set ? Note: Give answer considering that all dependencies have a single attribute on right side of arrow

Show answer

A written answer, not marked automatically.

See the whole paperTake it as a mock test

Question 14 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. Q13Consider a relation R(A, B, C, D, E, F, G, H, I, J) having functional dependencies as follows F = {AB → C, D → IJ, A → …
  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…