EXAMIANS
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.
YOUR ANSWER : ?
YOUR ANSWER : ?
When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
YOUR ANSWER : ?
The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
YOUR ANSWER : ?
We use the SQL construct COUNT(*) to count the number of rows in a table.
YOUR ANSWER : ?
When building a database from an existing set of tables, we still need to consider normalization principles.
YOUR ANSWER : ?
We can eliminate modification anomalies with proper normalization that results in tables in BCNF.
YOUR ANSWER : ?
Normalization ________ data duplication.
YOUR ANSWER : ?
One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.
YOUR ANSWER : ?
For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
YOUR ANSWER : ?
When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.
YOUR ANSWER : ?