This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Distinguish between the primary key and a candidate key. What will be an ideal ... (Read 22 times)

Collmarie

  • Hero Member
  • *****
  • Posts: 569
on: Jul 7, 2018
Distinguish between the primary key and a candidate key.
 
  What will be an ideal response?

Question 2

Database designs are created during the component design step.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

ashely1112

  • Sr. Member
  • ****
  • Posts: 347
Reply #1 on: Jul 7, 2018
Answer to Question 1

Both the primary key and a candidate key can uniquely identify the rows in a table. The primary key is the candidate key that is chosen by the database designer, working with the users, to uniquely identify rows and to represent relationships. Although any candidate key could, by definition, be selected to act as the primary key, the choice of primary key is often based on design decisions such as the amount of foreign key data that would be generated.

Answer to Question 2

TRUE


Collmarie

  • Hero Member
  • *****
  • Posts: 569
Reply #2 on: Jul 7, 2018
Thank you :)


ashely1112

  • Sr. Member
  • ****
  • Posts: 347
Reply #3 on: Jul 7, 2018
Happy to help you


« previous next »
 

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

In women, pharmacodynamic differences include increased sensitivity to (and increased effectiveness of) beta-blockers, opioids, selective serotonin reuptake inhibitors, and typical antipsychotics.

Did you know?

The first-known contraceptive was crocodile dung, used in Egypt in 2000 BC. Condoms were also reportedly used, made of animal bladders or intestines.

Estimated terrestrial net primary productivity across Canada. Estimated terrestrial net primary productivity across Canada.
Primary pulse points of the body. Primary pulse points of the body.
Activation of the Primary Gustatory Cortex by Taste Stimuli Activation of the Primary Gustatory Cortex by Taste Stimuli
Primary Motor Cortex and Seizures Primary Motor Cortex and Seizures
Harvey Milk was the first openly gay candidate to be elected to office in California. Harvey Milk was the first openly gay candidate to be elected to office in California.
Formation of primary and secondary lysosomes and their role in cellular digestive Formation of primary and secondary lysosomes and their role in cellular digestive
Video: Language Areas Animation

For a complete list of videos, visit our video library