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 44 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
Thanks for the timely response, appreciate it

Zebsrer

  • Member
  • Posts: 284
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

Did you know?

Vampire bats have a natural anticoagulant in their saliva that permits continuous bleeding after they painlessly open a wound with their incisors. This capillary blood does not cause any significant blood loss to their victims.

Did you know?

The familiar sounds of your heart are made by the heart's valves as they open and close.

Therapeutic index: (a) drug X has a therapeutic index of 4; (b) drug Z has a therapeutic index of 2 Therapeutic index: (a) drug X has a therapeutic index of 4; (b) drug Z has a therapeutic index of 2
Example of Index entry for an anatomic site with a cross-reference. Example of Index entry for an anatomic site with a cross-reference.
Example of Index entry with Main Term and indented subterms. Example of Index entry with Main Term and indented subterms.
Special Purpose Checks Special Purpose Checks
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 ...
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 ...
Video: Hormonal regulation of blood pressure - RAA system

For a complete list of videos, visit our video library