Relation R has eight attributes ABCDEFGH. Fields contain only atomic values. F={CH→G,
How many candidate keys does relation R have?
If a relation R(A, B, C) has functional dependencies F = {A -> B, B -> C}, which of the following dependencies is inferred using A…
An index is clustered, if
Consider the following relational schema (primary keys: Students.rollno, Courses.courseno, and Registration.(rollno,courseno)): St…
Relation R has eight attributes ABCDEFGH. Fields contain only atomic values. F={CH→G, A→BC, B→CFH, E→A, F→EG} is a set of function…
Let P, Q, R and S be the attributes of a relation in a relational schema. Let X → Y indicate functional dependency in the context …
In the context of relational database normalization, which of the following statements is/are true?
Free account benefits
Public PYQs and reference pages stay free. Sign in when you want GATEverse to remember what you studied and guide what to practise next.