A table is in Third Normal Form (3NF) if it is in 2NF and has absolutely no non-prime attributes that exhibit what type of dependency? MCQ with Answer and Explanation
A table is in Third Normal Form (3NF) if it is in 2NF and has absolutely no non-prime attributes that exhibit what type of dependency?
A. Transitive Dependency
B. Partial Dependency
C. Trivial Dependency
D. Join Dependency
Answer: Option A
Solution (By JKExamLibrary)
Third Normal Form (3NF) requires a relation to be in 2NF with no transitive dependencies, meaning non-prime attributes cannot be determined by other non-prime attributes.
Explanation:
The UNIQUE constraint prevents duplicate entries in a column. Unlike a Primary Key, a UNIQUE constraint typically allows one or more rows to store NULL values depending on the database engine.
Explanation:
A Cross Join returns the Cartesian product of the two tables, multiplying the total number of rows from the first table by the number of rows in the second table.
No comments yet. Be the first to start the discussion!