When assessing the table structure of an acquired set of tables with d – McqOptions

MCQOPTIONS

1.	When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:$?
A.	first step.
B.	second step.
C.	third step.
D.	fourth step.
Answer» C. third step.

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.%!