close
test_template

Primary and Foreign Keys

  • Categories: Key
download print

About this sample

About this sample

close

Words: 437 |

Page: 1|

3 min read

Published: Sep 4, 2018

Words: 437|Page: 1|3 min read

Published: Sep 4, 2018

Table of contents

  1. Introduction
  2. A primary key follows these rules
  3. Referential Integrity

Introduction

A primary key is an exclusive data item that allows the user to identify any piece of the record. When you specify a primary key constraint for a table, the Database Engine enforces data exclusivity by automatically creating a unique index for the primary key columns. This is useful to identify the data you need fast and efficiently. For example, you can identify a student in a database full of students with just their ID rather than their details.

'Why Violent Video Games Shouldn't Be Banned'?

A primary key follows these rules

A table can only have one primary key, this is usually the “ID” key. It cannot exceed 16 columns and a key length of 900 bytes. The index generated by a primary key constraint cannot cause the number of indexes on the table to exceed 999 non-clustered indexes and 1 clustered index. If clustered or non-clustered is not specified for a primary key constraint, clustered is used if there no clustered index on the table.

All columns defined within a primary key constraint must be defined as not null. If nullability is not specified, all columns participating in a primary key constraint have their nullability set to not null. If a primary key is defined on a CLR user-defined type column, the implementation of the type must support binary ordering. A foreign key is a column or combination of columns that are used to establish and enforce a link between the data in two tables to control the data that can be stored in the foreign key table. A link is created between two tables when the column or columns that hold the primary key value for one table are referenced by the column or columns in another table. This column becomes a foreign key in the second table.

Referential Integrity

Referential integrity is a relational database concept, which states that table relationships must always be consistent. In other words, any foreign key field must agree with the primary key that is referenced by the foreign key. Therefore, any primary key field changes must be applied to all foreign keys, or not at all. The same restriction also applies to foreign keys in that any updates (but not necessarily deletions) must be propagated to the primary parent key.

Get a custom paper now from our expert writers.

For example, deleting a record that contains a value referred to by a foreign key in another table would break referential integrity. Some relational database management systems can enforce referential integrity, either by deleting the foreign key rows as well to maintain integrity or by returning an error and not performing the delete. Which method is used may be determined by a referential integrity constraint defined in a data dictionary.

Image of Prof. Linda Burke
This essay was reviewed by
Prof. Linda Burke

Cite this Essay

Primary and Foreign Keys. (2018, Jun 30). GradesFixer. Retrieved June 14, 2024, from https://gradesfixer.com/free-essay-examples/primary-and-foreign-keys/
“Primary and Foreign Keys.” GradesFixer, 30 Jun. 2018, gradesfixer.com/free-essay-examples/primary-and-foreign-keys/
Primary and Foreign Keys. [online]. Available at: <https://gradesfixer.com/free-essay-examples/primary-and-foreign-keys/> [Accessed 14 Jun. 2024].
Primary and Foreign Keys [Internet]. GradesFixer. 2018 Jun 30 [cited 2024 Jun 14]. Available from: https://gradesfixer.com/free-essay-examples/primary-and-foreign-keys/
copy
Keep in mind: This sample was shared by another student.
  • 450+ experts on 30 subjects ready to help
  • Custom essay delivered in as few as 3 hours
Write my essay

Still can’t find what you need?

Browse our vast selection of original essay samples, each expertly formatted and styled

close

Where do you want us to send this sample?

    By clicking “Continue”, you agree to our terms of service and privacy policy.

    close

    Be careful. This essay is not unique

    This essay was donated by a student and is likely to have been used and submitted before

    Download this Sample

    Free samples may contain mistakes and not unique parts

    close

    Sorry, we could not paraphrase this essay. Our professional writers can rewrite it and get you a unique paper.

    close

    Thanks!

    Please check your inbox.

    We can write you a custom essay that will follow your exact instructions and meet the deadlines. Let's fix your grades together!

    clock-banner-side

    Get Your
    Personalized Essay in 3 Hours or Less!

    exit-popup-close
    We can help you get a better grade and deliver your task on time!
    • Instructions Followed To The Letter
    • Deadlines Met At Every Stage
    • Unique And Plagiarism Free
    Order your paper now