« previous next »

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

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

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.

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

Did you know?

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

Allows access to the nut that has a stud plus other locations needing great depth, such as spark ... Allows access to the nut that has a stud plus other locations needing great depth, such as spark ...
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 ...
Vehicles equipped with onboard refueling vapor recovery usually have a reduced-size fill tube. Vehicles equipped with onboard refueling vapor recovery usually have a reduced-size fill tube.
Removing the bed from a pickup truck makes gaining access to the fuel pump a lot easier. Removing the bed from a pickup truck makes gaining access to the fuel pump a lot easier.
Apply deep effleurage to triceps. Position arm with elbow pointing upward to access the triceps ... Apply deep effleurage to triceps. Position arm with elbow pointing upward to access the triceps ...
Video: Ventilation - phases and driving forces

For a complete list of videos, visit our video library