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 46 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

milbourne11

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

« previous next »
 

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Did you know?

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

Did you know?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Heat Index Heat Index
Index card tickler file. Index card tickler file.
Interpret CPT Index Conventions Interpret CPT Index Conventions
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
Apply L stroke on terminus. Place your index and middle fingers on the left and right terminus; ... Apply L stroke on terminus. Place your index and middle fingers on the left and right terminus; ...
Pacific Decadal Oscillation: PDO index Pacific Decadal Oscillation: PDO index
Video: Mechanisms of capillary exchange

For a complete list of videos, visit our video library