BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 5, Problem 11RQ
Textbook Problem
736 views

What primary key characteristics are considered desirable? Explain why each characteristic is considered desirable.

Program Plan Intro

Primary key (PK):

  • To identify each record in a table, at least there must be one data field, which should be unique.
    • That is corresponding data field of every record should be unique.
    • It is called primary key.
  • Primary key is used to identify the unique record from a collection of records.

Explanation of Solution

Characteristics of desirable primary key (PK):

A primary key characteristic consists of six types. They are:

  • Unique values
  • Nonintelligent
  • No change over time
  • Preferably single-attribute
  • Preferably numeric
  • Security-compliant

Explanation of desirable primary key characteristics:

Unique values:

Each entity instance is uniquely identified by the primary key. It must be able to security unique values and it can’t contain null values.

Nonintelligent:

The embedded semantic meaning can’t contain by the PK other than to uniquely identify every entity instance. Embedded semantic meaning attribute is possibly better used as an expressive characteristic of the entity compared to an identifier.

No change over time:

In this type of PK, if the attribute contains semantic meaning, then it possibly focuses to updates that are modification...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 5 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
add

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What is a table, and what role does it play in the relational model?

Database Systems: Design, Implementation, & Management

Explain the purpose of homing.

Precision Machining Technology (MindTap Course List)

Solve Problem 20.1 using Excel.

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

What type of information should go into your employment plan?

Automotive Technology: A Systems Approach (MindTap Course List)

Is it ethical to use a fake name online? Why or why not? List techniques to protect yourself from identity thef...

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

What is a combination welding and cutting torch?

Welding: Principles and Applications (MindTap Course List)