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

AEWBW

  • Hero Member
  • *****
  • Posts: 579
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
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
 

Did you know?

Pink eye is a term that refers to conjunctivitis, which is inflammation of the thin, clear membrane (conjunctiva) over the white part of the eye (sclera). It may be triggered by a virus, bacteria, or foreign body in the eye. Antibiotic eye drops alleviate bacterial conjunctivitis, and antihistamine allergy pills or eye drops help control allergic conjunctivitis symptoms.

Did you know?

Liver spots have nothing whatsoever to do with the liver. They are a type of freckles commonly seen in older adults who have been out in the sun without sufficient sunscreen.

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

For a complete list of videos, visit our video library