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

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

For a complete list of videos, visit our video library