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

There are over 65,000 known species of protozoa. About 10,000 species are parasitic.

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

More than 20 million Americans cite use of marijuana within the past 30 days, according to the National Survey on Drug Use and Health (NSDUH). More than 8 million admit to using it almost every day.

For a complete list of videos, visit our video library