« previous next »

Author Question: In the database redesign process, before proceeding with the redesign it is often useful to ... (Read 115 times)

AEWBW

  • Hero Member
  • *****
  • Posts: 579
on: Jul 7, 2018
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

  • Sr. Member
  • ****
  • Posts: 307
Reply #1 on: Jul 7, 2018
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.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Critical thinking and the process of planning care Critical thinking and the process of planning care
Nursing diagnositic process - risk for infection Nursing diagnositic process - risk for infection
This graphic illustrates the original systems model of politics advanced by David Easton. Politics This graphic illustrates the original systems model of politics advanced by David Easton. Politics
After all valves have been properly measured and adjusted as necessary, start the reassembly process ... After all valves have been properly measured and adjusted as necessary, start the reassembly process ...
Research Methods: A Process of Inquiry Research Methods: A Process of Inquiry
Macrophage caught in the process of engulfing tuberculosis bacteria. Macrophage caught in the process of engulfing tuberculosis bacteria.
Video: Supine Position

For a complete list of videos, visit our video library