Consider relations r(A, B) and s(B, C), where s.B is primary key and r.B is foreign key referencing s.B. Consider query Q: r ⋈ (σ_…
Consider the following relational schemas and non-trivial functional dependencies: Schema I: Registration (rollno, courses) with r…
Consider the following two tables and four queries in SQL: Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.cop…
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?
Consider a relational database schema with two relations R(P,Q) and S(X,Y). Let E = {<u> | there ∃ v, there ∃ w, <u,v> in R and <v…
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.