Author Question: A lack of naming conventions can lead to confusion and make it harder to maintain or modify a ... (Read 60 times)

crobinson2013

  • Hero Member
  • *****
  • Posts: 535
A lack of naming conventions can lead to confusion and make it harder to maintain or modify a database.
 
  Indicate whether the statement is true or false

Question 2

Explain cross joins and how one might result by accident.
 
  What will be an ideal response?



Joy Chen

  • Sr. Member
  • ****
  • Posts: 354
Answer to Question 1

TRUE

Answer to Question 2

In a cross join each record of the first table is matched to every record in the second table. This can happen by accident in a equi join if the developer forgets to include the relationship between the tables in where clause of the join.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

The average person is easily confused by the terms pharmaceutics and pharmacology, thinking they are one and the same. Whereas pharmaceutics is the science of preparing and dispensing drugs (otherwise known as the science of pharmacy), pharmacology is the study of medications.

Did you know?

The effects of organophosphate poisoning are referred to by using the abbreviations “SLUD” or “SLUDGE,” It stands for: salivation, lacrimation, urination, defecation, GI upset, and emesis.

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

The U.S. Preventive Services Task Force recommends that all women age 65 years of age or older should be screened with bone densitometry.

Did you know?

The eye muscles are the most active muscles in the whole body. The external muscles that move the eyes are the strongest muscles in the human body for the job they have to do. They are 100 times more powerful than they need to be.

For a complete list of videos, visit our video library