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 45 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 :)

alvinum

  • Member
  • Posts: 317
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Did you know?

People with high total cholesterol have about two times the risk for heart disease as people with ideal levels.

(a) Homologous traits are similar due to shared ancestry. (b) Analogous traits (bats’, birds’, and f (a) Homologous traits are similar due to shared ancestry. (b) Analogous traits (bats’, birds’, and f
NCC MERP Index for categorizing medication errors. NCC MERP Index for categorizing medication errors.
Rub the ears between your thumbs and index fingers. Follow the curves to rub the entire ear, ... Rub the ears between your thumbs and index fingers. Follow the curves to rub the entire ear, ...
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 ...
Pacific Decadal Oscillation: PDO index Pacific Decadal Oscillation: PDO index
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 ...
Video: Dietary Cholesterol & LDL

For a complete list of videos, visit our video library