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

EAN94

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

« previous next »
 

Did you know?

The strongest synthetic topical retinoid drug available, tazarotene, is used to treat sun-damaged skin, acne, and psoriasis.

Did you know?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

Did you know?

Approximately 500,000 babies are born each year in the United States to teenage mothers.

Did you know?

Addicts to opiates often avoid treatment because they are afraid of withdrawal. Though unpleasant, with proper management, withdrawal is rarely fatal and passes relatively quickly.

Did you know?

On average, someone in the United States has a stroke about every 40 seconds. This is about 795,000 people per year.

NCC MERP Index for categorizing medication errors algorithm. NCC MERP Index for categorizing medication errors algorithm.
Apply light tapotement on the head. Tapping lightly with the fingertips works well for this purpose. Apply light tapotement on the head. Tapping lightly with the fingertips works well for this purpose.
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; ...
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 ...
Body Mass Index (IBM) Body Mass Index (IBM)
The purpose of mitosis is to take diploid cells and make two identical clones. A shows a simplified The purpose of mitosis is to take diploid cells and make two identical clones. A shows a simplified
Video: Biological organic compounds

For a complete list of videos, visit our video library