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 19 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
Wow, this really help

miss.ashley

  • Member
  • Posts: 371
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

Did you know?

The U.S. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

Heat Index Heat Index
Index card tickler file. Index card tickler file.
Interpret CPT Index Conventions Interpret CPT Index Conventions
Special Purpose Checks Special Purpose Checks
Body mass index table. Body mass index table.
Cultures Ideal Body Types Cultures Ideal Body Types
Video: Epidural Hematoma

For a complete list of videos, visit our video library