In relational databases, if relation is in , then which of the following is true about relation R ?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: D. R is in 2NF and 3NF
Explanation
BCNF implies 3NF, which implies 2NF. It does not imply 4NF.
More Database Management Systems questions
- Which of the following key constraints is required for functioning of foreign key in the context of relational databases?
- In relational database management, which of the following is/are property/properties of candidate key? P : Uniqueness Q : Irreducibility
- Which of the following statements are DML statements? (a) Update [tablename] = Set [ columnname] VALUE (b) Delete [tablename] (c) Select *…
- Hadoop (a big data tool) works with number of related tools. Choose from the following, the common tools included into Hadoop :
- A table has attributes Employee_id (primary key) and Manager_id (foreign key referencing Employee_id with ON DELETE CASCADE), with tuples (…
- An attribute A of datatype varchar(20) has the value 'xyz', and the attribute B of datatype char(20) has the value 'lmnop'. Then attribute…