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

The U.S. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

Computer programs are available that crosscheck a new drug's possible trade name with all other trade names currently available. These programs detect dangerous similarities between names and alert the manufacturer of the drug.

Did you know?

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Injecting an IV push (bolus) medication; B, into a primary infusion line Injecting an IV push (bolus) medication; B, into a primary infusion line
The respiratory system. (a) Sagittal section of the head and neck, revealing the organs of the upper The respiratory system. (a) Sagittal section of the head and neck, revealing the organs of the upper
Primary neurulation Primary neurulation
The Primary Sensory Regions of the Brain The Primary Sensory Regions of the Brain
Where Professional Psychologists Work Primary employment settings for PhD recipients in psychology. Where Professional Psychologists Work Primary employment settings for PhD recipients in psychology.
What type of online info about a job candidate should employment mgmt consider when screening What type of online info about a job candidate should employment mgmt consider when screening
Video: Muscular Dystrophy

For a complete list of videos, visit our video library