« previous next »

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

Awilson837

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

Did you know?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

Did you know?

The first war in which wide-scale use of anesthetics occurred was the Civil War, and 80% of all wounds were in the extremities.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Oval window Oval window
Microsoft Word Attachments Microsoft Word Attachments
Suzuki Harunobu, Two Courtesans, Inside and Outside the Display Window, Japanese. Suzuki Harunobu, Two Courtesans, Inside and Outside the Display Window, Japanese.
Two stubby screwdrivers used to access screws that have limited space above. A straight blade is on ... Two stubby screwdrivers used to access screws that have limited space above. A straight blade is on ...
Reinstall the spark plug wires and all brackets that were removed to gain access to the valve ... Reinstall the spark plug wires and all brackets that were removed to gain access to the valve ...
X-ray showing pneumonia. Fluid and blood cells fill the lungs X-ray showing pneumonia. Fluid and blood cells fill the lungs
Video: Barriers - eye structures, digestive mucosa, respiratory mucosa & genitourinary mucosa

For a complete list of videos, visit our video library