Question 19
Consider the relation R(A, B, C, D, E, F) and the following functional dependencies set F = {AB → C, C → D, D → E, E → F} Find the total number of super keys of R.
Question 19: Consider the relation R(A, B, C, D, E, F) and the follow…
Show answer
A written answer, not marked automatically.
Question 19 of 20 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 10 May 2026, in the January 2026 term (Database Management Systems 06 May 26). It carries 2 marks.
More questions from this paper
- Consider a B-tree index to be built on the attribute EmployeeID of a table Employees, with the following properties: • …
- Consider the table BandRecords as given below: Let us create two different bitmap indices, one on the Tour attribute an…
- Consider the relational schemas Student, Course and Enrolled: Now consider the following SQL query: The query returns:
- Consider the hash functions given below. • • • • Identify the hash function(s) that can generate unique hash values for…
- Consider the definition of the table Products: The following sequence of queries is executed on this table: Which of th…
- Schedule S is as given: Which of the following options is/are correct?
- Consider a relation schema T(A,B,C,D,E,F) and the set of functional dependencies, F= {A → BC, C → D, D → C, B → E, E → …
- Consider the following monthly backup schedule used by a company: If a failure occurs on the 24th day of the month afte…
- Consider the instance of a relation V. Which among the following functional dependency set(s) can be inferred from the …
- Consider the following relational schema: Choose the correct SQL query to find the names of departments where the total…
- Choose the relational algebra expression that is equivalent to the following tuple calculus expression:
- Consider a B+ tree index built on the key attribute of a data file having 62,50,000 records. Let the order of the B+ tr…
- Choose the correct statement(s).
- Consider the ER Diagram as shown below: Which of the following statement(s) is/are correct?
- Consider the given log records at an instance of time: Suppose there is a system crash after the last log record. What …
- Consider you have a file in your hard disk of size 900 KB. Seek time of your hard disk read head is 5 ms and rotational…
- Consider a system using the Most Recently Used (MRU) page replacement policy. The system has a main memory buffer with …
- Consider the following schedule S with five transactions T1, T2, T3, T4, T5: Where, Ri(X) denotes a read operation by t…
- Consider a block nested-loop join for the two relations students and enrollments: Assuming the worst-case memory availa…