Author Question: Microsoft Access SQL commands are run in the ________ of a Query window. Fill in the blank(s) ... (Read 54 times)

Awilson837

  • Hero Member
  • *****
  • Posts: 509
Microsoft Access SQL commands are run in the ________ of a Query window.
 
  Fill in the blank(s) with correct word

Question 2

Explain the pragmatic reason for using surrogate keys.
 
  What will be an ideal response?



otokexnaru

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

SQL View

Answer to Question 2

Primary keys are commonly included in indexes, and are used to identify records to be retrieved by users. The ideal primary key is short, numeric and fixed. When the primary key contains a lengthy text field, this creates a large amount of duplicated data that must be frequently manipulated. For these reasons, it is often practical to use a surrogate key that is generated by the system and is relatively small and easy to manipulate.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

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 people with the highest levels of LDL are Mexican American males and non-Hispanic black females.

Did you know?

Autoimmune diseases occur when the immune system destroys its own healthy tissues. When this occurs, white blood cells cannot distinguish between pathogens and normal cells.

For a complete list of videos, visit our video library