This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: What is the purpose of an index? What will be an ideal ... (Read 26 times)

Bernana

  • Hero Member
  • *****
  • Posts: 530
on: Jul 7, 2018
What is the purpose of an index?
 
  What will be an ideal response?

Question 2

What is necessary redundancy in a relational database?
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Li Jun

  • Sr. Member
  • ****
  • Posts: 335
Reply #1 on: Jul 7, 2018
Answer to Question 1

An index is a mechanism for increasing the speed of data search and data retrieval on relations with a large number of records.

Answer to Question 2

Multiple appearances of foreign key values in the 3NF set of relational tables represent necessary redundancy, which is essential for connecting the tables.


Bernana

  • Member
  • Posts: 530
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)

mammy1697

  • Member
  • Posts: 341
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

Thyroid conditions cause a higher risk of fibromyalgia and chronic fatigue syndrome.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

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.

Did you know?

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

Digital rectal exam (DRE). The physician’s index finger is inserted into the rectum and pressed agai Digital rectal exam (DRE). The physician’s index finger is inserted into the rectum and pressed agai
Purpose of the nursing interventions Purpose of the nursing interventions
Index of seed size and hardiness prior to, during, and after drought. Index of seed size and hardiness prior to, during, and after drought.
What are examples of ideal forms? What are examples of ideal forms?
Cranial polarization. Lightly place both thumbs on the anterior fontanel, with both index fingers ... Cranial polarization. Lightly place both thumbs on the anterior fontanel, with both index fingers ...
If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas? If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas?
Video: Exocytosis - secretion

For a complete list of videos, visit our video library