Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900



Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900
Chapter 5, Problem 14RQ
Textbook Problem

What is a surrogate primary key, and when would you use one?

Program Plan Intro

Surrogate primary key:

  • A system assigned primary key in a relational database such as a serial number or any other which is not derived from any data in the database is known as surrogate primary key.
  • It is deputy of the primary key and will act as a primary key in the database and does not have any other significance.
  • To simplify the primary key structures in the database, surrogate primary keys are created, and this ensures unique identification process in a relation.

Explanation of Solution

Conditions to use the surrogate key:

The surrogate key for a relation is created when a primary key of a relation holds the below three conditions:

  • If the relation has a composite primary key, then surrogate key should be created.
    • If a primary key consists of more than attribute to uniquely identify a row or column in a relational database, it is known as composite primary key.
  • Presence of inefficient natural primary key...

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

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What are the potential costs of implementing a database system?

Database Systems: Design, Implementation, & Management

Do you think this event was caused by an insider or outsider? Explain your answer.

Principles of Information Security (MindTap Course List)

Briefly describe a gang drill press and its benefit.

Precision Machining Technology (MindTap Course List)

Refer to Tables 11.9 and 11.10 to answer this question. What is the maximum amount of energy released when a 10...

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

Define a use case and a use case diagram, and prepare a sample of each.

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

Determine the three forces acting on the plate that are equivalent to the force R - 210k kN.

International Edition---engineering Mechanics: Statics, 4th Edition

Can you configure your browser to automatically delete your browsing history? If so, how?

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)

Which type of hypervisor is installed on bare metal?

Network+ Guide to Networks (MindTap Course List)

What are taps on a welding transformer?

Welding: Principles and Applications (MindTap Course List)