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 11 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

kusterl

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

« previous next »
 

Did you know?

All adverse reactions are commonly charted in red ink in the patient's record and usually are noted on the front of the chart. Failure to follow correct documentation procedures may result in malpractice lawsuits.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

When blood is exposed to air, it clots. Heparin allows the blood to come in direct contact with air without clotting.

What are examples of ideal forms? What are examples of ideal forms?
NCC MERP Index for categorizing medication errors algorithm. NCC MERP Index for categorizing medication errors algorithm.
A funnel is one way to visualize the diagnostic process. The purpose is to narrow the possible ... A funnel is one way to visualize the diagnostic process. The purpose is to narrow the possible ...
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.
Pacific Decadal Oscillation: PDO index Pacific Decadal Oscillation: PDO index
Satiety Index of Different Foods Subjects Satiety Index of Different Foods Subjects
Video: Anaphylaxis Animation

For a complete list of videos, visit our video library