Database Concepts (7th Edition)
Database Concepts (7th Edition)
7th Edition
ISBN: 9780133544626
Author: David M. Kroenke, David J. Auer
Publisher: PEARSON
bartleby

Concept explainers

Question
Book Icon
Chapter 2, Problem 2.13RQ
Program Plan Intro

Primary key:

  • In relational databases, a primary key is a key that is used for identifying and defining the characteristics uniquely of each row.
  • A primary key may have a single attribute or a multiple attributes.
  • Let us consider the “Student” table that consists of “Student_ID”, “First_Name”, “Last_Name”, and “Course_ID” as attributes.
    • Student_ID act as the primary key.

Candidate key:

  • Candidate key is an attribute or set of attributes from which a primary key can be selected.
  • It helps to identify the data uniquely from the table or relation without referring any other data.
  • One or more candidate keys can be present in a table or relation, but only one key is referred to as the primary key.
  • Candidate key must satisfy the subset of the properties of relation.

Blurred answer
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education