Consider a relational database containing the following schemas: Suppliers(sno, sname, location) Parts(pno, pname, part_spec) Cata…
Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationsh…
Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?
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.