In the database redesign process, before proceeding with the ...

[AEWBW]

In the database redesign process, before proceeding with the redesign it is often useful to ________.
 
  A) check whether certain conditions or assumptions about the data are valid
  B) find out why the design was not done properly the first time
  C) stop information systems and users from influencing each other
  D) set standards for user behavior

Question 2

Briefly describe subqueries and joins. Explain when each is not an acceptable alternative for the other.
 
  What will be an ideal response?

[EAN94]

Answer to Question 1

A

Answer to Question 2

Subqueries and joins are both methods for retrieving data from multiple tables. Subqueries involve nesting one SELECT statement within another. The nested SELECT is used as part of a condition in the WHERE clause of the first SELECT statement. The nested SELECT statement can return a set of records from one table, which are then used in a logical operator within the parent SELECT query. A join combines records from each table into concatenated records containing the fields of both tables. The records are concatenated based on matching values in similar columns in the two tables. Subqueries cannot be used in situations where the results to be displayed include attributes from more than one table. Joins cannot be used as an alternative to a correlated subquery.