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 41 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
YES! Correct, THANKS for helping me on my review

milbourne11

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Body mass index table. Body mass index table.
NCC MERP Index for categorizing medication errors algorithm. NCC MERP Index for categorizing medication errors algorithm.
NCC MERP Index for categorizing medication errors. NCC MERP Index for categorizing medication errors.
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 ...
A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ... A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ...
For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately
Video: Neurotransmission at chemical synapses & Excitory and inhibitory potentials

For a complete list of videos, visit our video library