GATE Databases: Integrity Constraints and Normal Forms – Previous Year Questions
33 GATE previous year questions on Integrity Constraints and Normal Forms (Databases, Computer Science) with answers and explanations, from every paper.
33 questions worth 50 marks in all (16 1-mark, 17 2-mark). Asked between 2007 and 2026, so you can see how the topic has been tested over time.
- GATE 2007 CS Q62 – Which statement is FALSE?
- GATE 2008 CS Q69 – Schemas: Book(Title, Author, Catalog no, Publisher, Year, Price); Collection(Title, Author, Catalog no). FDs: Title Author→Catalog no; Catalog…
- GATE 2009 CS Q56 – Relations: Suppliers(sid:integer, sname:string, city:string, street:string), Parts(pid:integer, pname:string, color:string), Catalog(sid:integer,…
- GATE 2021 CS (CS2) Q50 – On U(P,Q,R,S,T), dependencies P→QR and RS→T hold. Which can be inferred?
- GATE 2015 CS (CS3) Q13 – For X(P,Q,R,S,T,U), F=PR→ST, PSU→QR. Which dependency in F⁺ is trivial?
- GATE 2011 CS Q22 – A student table has one record per student: Registration Num unique per student; UID unique nationally per citizen; BankAccount Num is the primary…
- GATE 2013 CS Q64 – R(A,B,C,D,E,F,G,H) has atomic fields. Exactly the dependencies implied by F=CH→G,A→BC,B→CFH,E→A,F→EG hold. How many candidate keys exist?
- GATE 2013 CS Q65 – R(A,B,C,D,E,F,G,H) has atomic fields. Exactly the dependencies implied by F=CH→G,A→BC,B→CFH,E→A,F→EG hold. What is the highest normal-form description…
- GATE 2012 CS Q12 – Which statement is true?
- GATE 2012 CS Q53 – R₁(A,B) and R₂(C,D) have instances r₁,r₂. B references C as a foreign key and referential integrity holds. Which always holds?
- GATE 2017 CS (CS2) Q29 – Tables T₁(P,Q) = (2,2),(3,8),(7,3),(5,8),(6,9),(8,5),(9,8) and T₂(R,S) = (2,2),(8,3),(3,2),(9,7),(5,7),(7,2). P and R are primary keys. T₁.Q…
- GATE 2014 CS (CS3) Q32 – A prime attribute of relation schema R appears .
- GATE 2014 CS (CS2) Q31 – Find the maximum number of superkeys of R(E,F,G,H) with E as the key.
- GATE 2014 CS (CS2) Q32 – STUDENTS has rows (StudentID,StudentName,StudentEmail,StudentAge,CPI): (2345,Shankar,shankar@math,X,9.4), (1287,Swati,swati@ee,19,9.5),…
- GATE 2014 CS (CS1) Q31 – Relation R=(E,F,G,H,I,J,K,L,M,N) has dependencies EF G, F IJ, EH KL, K M, L N. Find its key.
- GATE 2014 CS (CS1) Q32 – S1: A foreign-key declaration can always be replaced by an equivalent SQL CHECK assertion. S2: Given R(a,b,c) with primary key (a,b), the following is…
- GATE 2014 CS (CS1) Q40 – S1: Every table with two single-valued attributes is in 1NF, 2NF, 3NF and BCNF. S2: AB → C, D → E, E → C is a minimal cover of AB → C, D → E, AB → E,…
- GATE 2017 CS (CS1) Q26 – The following functional dependencies hold true for the relational schema R\V, W, X, Y, Z\: V W VW X Y VX Y Z Which of the following is irreducible…
- GATE 2016 CS (CS1) Q31 – Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key VY?
- GATE 2016 CS (CS1) Q33 – A database of research articles in a journal uses the following schema. (Volume, Number, StartPage, EndPage, Title, Year, Price) The primary key is…
- GATE 2018 CS Q52 – Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed. The underlined attributes are the…
- GATE 2019 CS Q42 – Let the set of functional dependencies F=\QR S,\ R P,\ S Q\ hold on a relation schema X=(PQRS). X is not in BCNF. Suppose X is decomposed into two…
- GATE 2026 CS (CS2) Q42 – In the context of schema normalization in relational DBMS, consider a set F of functional dependencies. The set of all functional dependencies implied…
- GATE 2026 CS (CS1) Q31 – In the context of relational database normalization, which of the following statements is/are true?
- GATE 2026 CS (CS1) Q65 – Consider a relational database schema with a relation R(A, B, C, D). If \A, B\ and \A, C\ are the only two candidate keys of the relation R, then the…
- GATE 2025 CS (CS2) Q46 – Consider the following relational schema along with all the functional dependencies that hold on them. R1(A, B, C, D, E): D E,\ EA B,\ EB C R2(A, B,…
- GATE 2024 CS (CS2) Q56 – A functional dependency F: X Y is termed as a useful functional dependency if and only if it satisfies: X is not the empty set, Y is not the empty…
- GATE 2024 CS (CS1) Q22 – Which of the following statements about a relation R in first normal form (1NF) is/are TRUE?
- GATE 2024 CS (CS1) Q44 – The symbol → indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?
- GATE 2022 CS Q14 – In a relational data model, which one of the following statements is TRUE?
- GATE 2022 CS Q31 – Consider a relation R(A,B,C,D,E) with the following three functional dependencies. AB C; BC D; C E; The number of superkeys in the relation R is .
- GATE 2021 CS (CS1) Q43 – Consider the relation R(P,Q,S,T,X,Y,Z,W) with the following functional dependencies. PQ X;\ P YX;\ Q Y;\ Y ZW Consider the decomposition of the…
- GATE 2020 CS Q46 – Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?