Decomposition gives P→R and P→Q, so C holds and augmenting the latter gives D. Starting from PS, P yields R, and RS then yields T, proving A. R alone does not supply S and need not determine T. Thus A,C,D.
More Integrity Constraints and Normal Forms questions
GATE 2026 CS (CS1) Q31– In the context of relational database normalization, which of the following statements…
GATE 2026 CS (CS1) Q65– Consider a relational database schema with a relation R(A, B, C, D). If \A, B\ and \A, C\…
GATE 2026 CS (CS2) Q42– In the context of schema normalization in relational DBMS, consider a set F of functional…
GATE 2025 CS (CS2) Q46– Consider the following relational schema along with all the functional dependencies that…
GATE 2024 CS (CS1) Q22– Which of the following statements about a relation R in first normal form (1NF) is/are…
GATE 2024 CS (CS1) Q44– The symbol → indicates functional dependency in the context of a relational database.…