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

Complications of influenza include: bacterial pneumonia, ear and sinus infections, dehydration, and worsening of chronic conditions such as asthma, congestive heart failure, or diabetes.

Did you know?

Chronic necrotizing aspergillosis has a slowly progressive process that, unlike invasive aspergillosis, does not spread to other organ systems or the blood vessels. It most often affects middle-aged and elderly individuals, spreading to surrounding tissue in the lungs. The disease often does not respond to conventionally successful treatments, and requires individualized therapies in order to keep it from becoming life-threatening.

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?

Medication errors are more common among seriously ill patients than with those with minor conditions.

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Primary and secondary immune responses. Primary and secondary immune responses.
Lip Abnormalities, Chancre from Primary Syphilis Lip Abnormalities, Chancre from Primary Syphilis
Levels of protein structure: Primary structure Levels of protein structure: Primary structure
The locations of human primary somatosensory cortex (SI) and one area of secondary somatosensory ... The locations of human primary somatosensory cortex (SI) and one area of secondary somatosensory ...
Twelve primary energy channels and the Conception and Governing Vessels of Traditional Chinese ... Twelve primary energy channels and the Conception and Governing Vessels of Traditional Chinese ...
Satellite data on primary productivity in the equatorial Pacific Ocean Satellite data on primary productivity in the equatorial Pacific Ocean
Video: Cardiac Cycle (Part 3 of 4)

For a complete list of videos, visit our video library