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

In 2006, a generic antinausea drug named ondansetron was approved. It is used to stop nausea and vomiting associated with surgery, chemotherapy, and radiation therapy.

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

Did you know?

Malaria mortality rates are falling. Increased malaria prevention and control measures have greatly improved these rates. Since 2000, malaria mortality rates have fallen globally by 60% among all age groups, and by 65% among children under age 5.

Primary production is constrained by the most limiting factor. Primary production is constrained by the most limiting factor.
Annual net primary productivity on Earth. Annual net primary productivity on Earth.
Products of the Root's Primary Meristems Products of the Root's Primary Meristems
Primary School Attendance in World Regions Attending primary school is common but not universal, wo Primary School Attendance in World Regions Attending primary school is common but not universal, wo
Primary Visual Cortex Primary Visual Cortex
Primary growth in a root Primary growth in a root
Video: Role of complement proteins

For a complete list of videos, visit our video library