Exam 8: Database Redesign

When dropping a foreign key column from a table,which of the following steps is (are)included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )

Dependency graphs are graphical displays like bar charts.

SQL Server 2012 contains a system-stored procedure named sp_rename that can be used to change table names.

In a correlated subquery,the same table is used in the upper and lower SELECT statements.

What is a dependency graph,and what is it used for in database redesign?

In the database redesign process,two SQL tools are useful for testing whether or not certain conditions or assumptions are valid: uncorrelated subqueries and EXISTS/NOT EXISTS.

Adding new tables and relationships to a database is difficult.

When redesigning a database,how can we check assumptions about functional dependencies?

Typically,there are at least four different copies of the database schema used in the redesign process.

A continuous circular process of changes in user behaviors and change in the information systems they use is a natural outcome of information system use.

Why do databases need redesigning?

When changing column data types,which of the following data conversions will either usually or always succeed?

The EXISTS keyword will be true if any row in the subquery meets the condition.

The data model produced by reverse engineering is not truly a logical model because it will contain tables for ________.

To change the minimum cardinality on the parent side from zero to one,the foreign key,which would have been NULL,must be changed to NOT NULL.

Because of the need to know the functional dependencies in a database,it is a good idea to create a dependency graph.

The continuous circular process of changes is known as the Systems Development Life Cycle (SDLC).

The use of a double nested set of NOT EXISTS SELECT statements can be used to find rows that meet some specified condition for every row in a table.

When increasing cardinalities from 1:N to N:M,we basically create a new intersection table,fill it with data and drop the old foreign key.

A correlated subquery looks very different from a noncorrelated subquery.