Database redesign is fairly easy when this is true.
What is there is no data in the database?
100
When running a correlated subquery, the DBMS always uses this.
What is nested processing?
100
The data model produced by reverse engineering is not truly a logical model because it will contain tables for these.
What are intersection tables?
100
This is the process to change a table name.
What is create a new table, move the data, and drop the old table?
100
Changing cardinalities.
What is commonly occurs in database redesign?
200
In the database redesign process, before proceeding with the redesign it is often useful to do this.
What is check whether certain conditions or assumptions about the data are valid?
200
When running a SQL query that uses EXISTS, the EXISTS keyword will be true if this is true.
What is any row in the subquery meets the condition?
200
The data model produced by reverse engineering.
What is a table-relationship diagram?
200
When making any change to the database structure, check for effects of the change on these.
What are data, foreign keys, constraints, and triggers?
200
When changing the minimum cardinality on the parent side of the relationship from zero to one, this must occur with regard to the foreign key.
What is must be changed from NULL to NOT NULL?
300
In the database redesign process, these SQL tools are useful for testing whether or not certain conditions or assumptions are valid.
What are correlated subqueries, EXISTS and NOT EXISTS?
300
When running a SQL query that uses NOT EXISTS, the NOT EXISTS keyword will be true if this is true.
What is all rows in the subquery fail to meet the condition?
300
Because of the need to know the functional dependencies in a database, it is a good idea to create this.
What is a dependency graph?
300
Use this command to add a NULL column to a table.
What is ALTER TABLE?
300
This difficulty occurs when changing the maximum cardinality from 1:1 to 1:N.
What is preserving the existing relationships?
400
In the SQL statement
SELECT C1.CustName, C1.SalesRepNo
FROM CUSTOMER C1;
this is what C1 is called.
What is an alias?
400
This is true in a double nested set of NOT EXISTS SELECT statements.
What is the condition if a row does not match any row, then it matches every row?
400
A dependency graph should include these.
What are tables, views & triggers?
400
If a DEFAULT constraint is included when a new column is added to a table, the default value is applied to this.
What are all new rows?
400
There will always be this when decreasing cardinalities.
What is data loss?
500
The DBMS alternates running the lower SELECT statement with running the upper SELECT statement based on each result of the lower SELECT statement when running this.
What is a correlated subquery?
500
The process of reading an actual database schema and producing a data model from that schema.
What is reverse engineering?
500
In order to make sure the database redesign is working properly during the redesign testing process, a means must be created to do this.
What is recover all test databases to their original state?
500
This is how to add a NOT NULL column to a table.
What is create a new NULL column, insert data values into every row, and change the NULL constraint to NOT NULL?
500
The steps in the process of increasing cardinalities from 1:N to N:M.
What is create an intersection table, populate the intersection table, and drop the old foreign key?