Primary and Foreign Keys: [Essay Example], 437 words GradesFixer
exit-popup-close

Haven't found the right essay?

Get an expert to write your essay!

exit-popup-print

Professional writers and researchers

exit-popup-quotes

Sources and citation are provided

exit-popup-clock

3 hour delivery

exit-popup-persone
close
This essay has been submitted by a student. This is not an example of the work written by professional essay writers.

Primary and Foreign Keys

  • Category: Business
  • Subcategory: Corporation
  • Topic: Key
  • Page: 1
  • Words: 437
  • Published: 30 Jun 2018
  • Downloads: 24
Download Print

Pssst… we can write an original essay just for you.

Any subject. Any type of essay.

We’ll even meet a 3-hour deadline.

Get your price

121 writers online

blank-ico
Download PDF

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.

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.

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.

Remember: This is just a sample from a fellow student.

Your time is important. Let us write you an essay from scratch

100% plagiarism free

Sources and citations are provided

Find Free Essays

We provide you with original essay samples, perfect formatting and styling

Cite this Essay

To export a reference to this article please select a referencing style below:

Primary and Foreign Keys. (2018, Jun 30). GradesFixer. Retrieved October 31, 2020, 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 31 Oct. 2020].
Primary and Foreign Keys [Internet]. GradesFixer. 2018 Jun 30 [cited 2020 Oct 31]. Available from: https://gradesfixer.com/free-essay-examples/primary-and-foreign-keys/
copy to clipboard
close

Sorry, copying is not allowed on our website. If you’d like this or any other sample, we’ll happily email it to you.

    By clicking “Send”, you agree to our Terms of service and Privacy statement. We will occasionally send you account related emails.

    close

    Attention! this essay is not unique. You can get 100% plagiarism FREE essay in 30sec

    Recieve 100% plagiarism-Free paper just for 4.99$ on email
    get unique paper
    *Public papers are open and may contain not unique content
    download public sample
    close

    Sorry, we cannot unicalize this essay. You can order Unique paper and our professionals Rewrite it for you

    close

    Thanks!

    Your essay sample has been sent.

    Want us to write one just for you? We can custom edit this essay into an original, 100% plagiarism free essay.

    thanks-icon Order now
    boy

    Hi there!

    Are you interested in getting a customized paper?

    Check it out!
    Having trouble finding the perfect essay? We’ve got you covered. Hire a writer

    GradesFixer.com uses cookies. By continuing we’ll assume you board with our cookie policy.