Consider the following relational schemas and non-trivial functional dependencies: Schema I: Registration (rollno, courses) with r…
In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 …
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.