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 21 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?

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Did you know?

Vampire bats have a natural anticoagulant in their saliva that permits continuous bleeding after they painlessly open a wound with their incisors. This capillary blood does not cause any significant blood loss to their victims.

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Illustration showing how the primary breast tumor metastasized through the lymphatic and blood vesse Illustration showing how the primary breast tumor metastasized through the lymphatic and blood vesse
Primary pulse points of the body. Primary pulse points of the body.
Primary cilium and the Hedgehog pathway Primary cilium and the Hedgehog pathway
Schools are a primary agent of socialization. One of their functions is to teach children the ... Schools are a primary agent of socialization. One of their functions is to teach children the ...
Primary motor area of cerebral cortex Primary motor area of cerebral cortex
Remote satellite monitoring of gross primary productivity across the United States. The differences Remote satellite monitoring of gross primary productivity across the United States. The differences
Video: Embryonic development - Weeks 5 to 8

For a complete list of videos, visit our video library