« previous next »

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

crobinson2013

  • Hero Member
  • *****
  • Posts: 535
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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
« previous next »
 

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

The human body's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

On average, the stomach produces 2 L of hydrochloric acid per day.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Steps in protein synthesis: The DNA is used as a template to make mRNA (transcription). The mRNA is ... Steps in protein synthesis: The DNA is used as a template to make mRNA (transcription). The mRNA is ...
Downward Spiral of Poverty and Hunger Lack of food can lead to numerous other symptoms Downward Spiral of Poverty and Hunger Lack of food can lead to numerous other symptoms
Severe arthritis can make everyday activities, like writing, typing, and handling objects Severe arthritis can make everyday activities, like writing, typing, and handling objects
Writing can lead to psychological benefits Writing can lead to psychological benefits
You make 4 semi-annual deposits starting at $350 and increasing at a constant rate of 2.14%. ... You make 4 semi-annual deposits starting at $350 and increasing at a constant rate of 2.14%. ...
Heart - All I Wanna Do Is Make Love To You (Official Music Video) Heart - All I Wanna Do Is Make Love To You (Official Music Video)
Video: Simple and Double Sugar

For a complete list of videos, visit our video library