Author Question: A lack of naming conventions can lead to confusion and make it harder to maintain or modify a ... (Read 38 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?

Persons who overdose with cardiac glycosides have a better chance of overall survival if they can survive the first 24 hours after the overdose.

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

For a complete list of videos, visit our video library