Correct answer: (A) R can have a multi-attribute key; (C) R cannot have a composite attribute
Explanation
1NF requires atomic attributes, so composite attributes are disallowed, but composite (multi-attribute) keys, foreign keys and multiple candidate keys are all allowed.
More Integrity Constraints and Normal Forms questions
GATE 2024 CS (CS1) Q44– The symbol → indicates functional dependency in the context of a relational database.…
GATE 2024 CS (CS2) Q56– A functional dependency F: X Y is termed as a useful functional dependency if and only if…
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;…
GATE 2021 CS (CS1) Q43– Consider the relation R(P,Q,S,T,X,Y,Z,W) with the following functional dependencies. PQ…
GATE 2020 CS Q46– Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following…