*/*_If a table has been normalized so that all determinants are candid – McqOptions

MCQOPTIONS

1.	/_If a table has been normalized so that all determinants are candidate keys, then that table is in:?
A.	1NF.
B.	2NF.
C.	3NF.
D.	BCNF.
Answer» E.

Discussion

No Comment Found

Related MCQs

When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.%!
Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.%!
Proper normalization eliminates duplicated data.%!
We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.%!
One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.%!
When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.%!
We can eliminate modification anomalies with proper normalization that results in tables in BCNF.%!
We have normalized a table into BCNF if all candidate keys are determinants.%!
Normalization requires programmers to write more complex SQL.%!
We use the SQL construct COUNT(*) to count the number of rows in a table.%!