MCQ Subject: Database Management Systems

Which database normalization form ensures that if a table is in 2NF, non-key attributes depend only on the entire primary key?

Which normalization form ensures that a non-prime attribute depends on the entire primary key, eliminating transitive dependencies?

Which database normalization form ensures that if a table is in 2NF, all non-prime attributes depend on the whole primary key?

Which normalization form ensures that if a table is in 2NF, a non-prime attribute depends on only one prime attribute?

In a relational database, which of the following best describes a primary key?

Which normalization form ensures that a non-prime attribute in a relation depends on the entire primary key?