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 17 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
Gracias!

rachel

  • Member
  • Posts: 323
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

The senior population grows every year. Seniors older than 65 years of age now comprise more than 13% of the total population. However, women outlive men. In the 85-and-over age group, there are only 45 men to every 100 women.

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

Did you know?

A good example of polar molecules can be understood when trying to make a cake. If water and oil are required, they will not mix together. If you put them into a measuring cup, the oil will rise to the top while the water remains on the bottom.

Did you know?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Purpose of the nursing interventions Purpose of the nursing interventions
(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
Example of the Index to Diseases and Injuries. Example of the Index to Diseases and Injuries.
Example of CPT conventions in the Index. Example of CPT conventions in the Index.
NCC MERP Index for categorizing medication errors algorithm. NCC MERP Index for categorizing medication errors algorithm.
Calculation of body mass index. To determine your BMI, find the value for your height on the left ... Calculation of body mass index. To determine your BMI, find the value for your height on the left ...
Video: Sperm Formation

For a complete list of videos, visit our video library