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.
Answer: B
No answer description available for this question.
Enter details here
Surrogate keys have much meaning for users.
Answer: B
No answer description available for this question.
Enter details here
When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
Answer: B
No answer description available for this question.
Enter details here
We use the SQL construct COUNT(*) to count the number of rows in a table.
Answer: A
No answer description available for this question.
Enter details here
The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
Answer: A
No answer description available for this question.
Enter details here
When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
Answer: C
No answer description available for this question.
Enter details here
Most of the time, modification anomalies are serious enough that tables should be normalized into:
Answer: D
No answer description available for this question.
Enter details here
When building a database from an existing set of tables, we still need to consider normalization principles.
Answer: A
No answer description available for this question.
Enter details here
Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
Answer: D
No answer description available for this question.
Enter details here
In all cases, normalization into BCNF is desirable.
Answer: B
No answer description available for this question.
Enter details here