Database Redesign Questions

• The data model produced from the reverse engineering process does not include intersection table data.
• The NOT EXISTS keyword will be true if any row in the subquery meets the condition.
• It is not easy to build a database correctly the first time.
• Adding null columns to a table is straightforward.
• Some organizations take the stand that no application should ever employ the true name of a table.
• Information systems and organizations do not just influence each other; they create each other.
• Reverse engineering is the process of reading a database schema and producing a data model from that schema.
• Typically, there should be at least two different copies of the database schema used in the redesign process.
• Although creating test databases is a critical and necessary job, there are few career opportunities in this area.
• A regular subquery is processed from the bottom up.
• Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.
• The EXISTS keyword will be true if any row in the subquery meets the condition.
• Correlated subqueries are similar to a regular subquery.
• Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
• If a database is built correctly the first time, it will not have to be redesigned.
• Database redesign is especially difficult if the database has no data.
• The data model produced from the reverse engineering process is a true logical model.
• A correlated subquery is processed as a nested subquery.
• The SQL-92 command to change a table name is RENAME TABLE.
• The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.