File:Referential integrity broken.png

From formulasearchengine
Jump to navigation Jump to search
    Original file (548 × 442 pixels, file size: 11 KB, MIME type: image/png)

    This file is from Wikimedia Commons and may be used by other projects. The description on its file description page there is shown below.

    Summary

    Description

    An example of a database that has not enforced referential integrity. In this example, there is a foreign key (artist_id) value in the album table that references a non-existent artist — in other words there is a foreign key value with no corresponding primary key value in the referenced table.

    This anomaly came about when the record for an artist called "Aerosmith", with an artist_id of "4", was deleted from the artist table, even though the album "Eat the rich" referred to this artist. If referential integrity had been enforced, the deletion of the main record would have been possible, but its associated record would have been deleted as well. Alternatively, the existence of an associated record would not allow the delete operation of the referenced record, and instead return an error code.
    Date
    Source en:Image:Referential integrity broken.PNG
    Author en:User:Ta bu shi da yu
    Permission
    (Reusing this file)    		 GFDL
    Other versions

    [edit]

    • English (original)
      English (original)
    • Ukrainian
      Ukrainian
    This diagram image could be re-created using vector graphics as a SVG file. This has several advantages; see Commons:Media for cleanup for more information. If a SVG form of this image is available, please upload it and afterwards replace this template with {{vector version available|new image name}}.
    It is recommended to name the SVG file “Referential integrity broken.svg”—then the template Vector version available (or Vva) does not need the new image name parameter.

    Licensing

    w:en:Creative Commons
    attribution share alike     		This file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported license. Subject to disclaimers.
    You are free:
    • to share – to copy, distribute and transmit the work
    • to remix – to adapt the work
    Under the following conditions:
    • attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
    • share alike – If you remix, transform, or build upon the material, you must distribute your contributions under the same or compatible license as the original.
    This licensing tag was added to this file as part of the GFDL licensing update.
    GNU head Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the section entitled GNU Free Documentation License. Subject to disclaimers.

    Captions

    Add a one-line explanation of what this file represents

    Items portrayed in this file

    depicts

    inception

    19 July 2005

    File history

    Click on a date/time to view the file as it appeared at that time.

    Date/TimeThumbnailDimensionsUserComment
    current10:35, 6 April 2007Thumbnail for version as of 10:35, 6 April 2007548 × 442 (11 KB)wikimediacommons>AutumnSnow{{Information| |Description= An example of a database that has not enforced referential integrity. In this example, there is a foreign key ('''artist_id''') value in the album table that references a non-existent artist &mdas

    The following page uses this file:

    Retrieved from "https://en.formulasearchengine.com/wiki/File:Referential_integrity_broken.png"