GATE Databases: Integrity Constraints and Normal Forms – Previous Year Questions
16 GATE previous year questions on Integrity Constraints and Normal Forms (Databases, Computer Science) with answers and explanations, from every paper.
- GATE 2017 CS 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 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 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 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?