« previous next »

Author Question: In the database redesign process, before proceeding with the redesign it is often useful to ... (Read 54 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?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

Did you know?

In 2006, a generic antinausea drug named ondansetron was approved. It is used to stop nausea and vomiting associated with surgery, chemotherapy, and radiation therapy.

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?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Nursing process as a system Nursing process as a system
Nursing diagnostic process Nursing diagnostic process
The respiratory system and the process of gas exchange. The respiratory system and the process of gas exchange.
Thoracic cage. Avoid heavy pressure over the sternum and xiphoid process; caution over rib cage. Thoracic cage. Avoid heavy pressure over the sternum and xiphoid process; caution over rib cage.
The political process is fraught with opportunities for opponents of climate legislation The political process is fraught with opportunities for opponents of climate legislation
The policymaking process The policymaking process
Video: How do the different types of chromatography work? (No Audio)

For a complete list of videos, visit our video library