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 13 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
Excellent

adf223

  • Member
  • Posts: 304
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Nitroglycerin is used to alleviate various heart-related conditions, and it is also the chief component of dynamite (but mixed in a solid clay base to stabilize it).

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Did you know?

Asthma-like symptoms were first recorded about 3,500 years ago in Egypt. The first manuscript specifically written about asthma was in the year 1190, describing a condition characterized by sudden breathlessness. The treatments listed in this manuscript include chicken soup, herbs, and sexual abstinence.

NCC MERP Index for Categorizing Medication Errors NCC MERP Index for Categorizing Medication Errors
Cultures Ideal Body Types Cultures Ideal Body Types
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
A funnel is one way to visualize the diagnostic process. The purpose is to narrow the possible ... A funnel is one way to visualize the diagnostic process. The purpose is to narrow the possible ...
Satiety Index of Different Foods Subjects Satiety Index of Different Foods Subjects
The Glycemic Index of Commonly Eaten Foods The glycemic index of a variety of foods The Glycemic Index of Commonly Eaten Foods The glycemic index of a variety of foods
Video: Oral Hygiene & Braces Animation

For a complete list of videos, visit our video library