Author Question: Microsoft Access SQL commands are run in the ________ of a Query window. Fill in the blank(s) ... (Read 55 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?

Cutaneous mucormycosis is a rare fungal infection that has been fatal in at least 29% of cases, and in as many as 83% of cases, depending on the patient's health prior to infection. It has occurred often after natural disasters such as tornados, and early treatment is essential.

Did you know?

The human body produces and destroys 15 million blood cells every second.

Did you know?

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

Did you know?

This year, an estimated 1.4 million Americans will have a new or recurrent heart attack.

Did you know?

Signs and symptoms of a drug overdose include losing consciousness, fever or sweating, breathing problems, abnormal pulse, and changes in skin color.

For a complete list of videos, visit our video library