Explore BrainMass

Explore BrainMass

    supporting data integrity in a database

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Explain the key concepts that are involved in supporting data integrity in a database. How is integrity enforced? What are the advantages of enforcing integrity? What are the disadvantages? How do integrity constraints impact the overall application design?

    © BrainMass Inc. brainmass.com June 3, 2020, 5:23 pm ad1c9bdddf
    https://brainmass.com/computer-science/sql/supporting-data-integrity-in-a-database-24328

    Solution Preview

    Explain the key concepts that are involved in supporting data integrity in a database.
    ======================================================================================

    Data integrity is one of the cornerstone of any relational databases. Simply state, data integrity means that the data values in the database must be correct and consistent.

    "Normalization" is a model used to avoid redundancy ... don't put the same information in more than one place!

    Keys: Keys are used to index (or sort) tables and to reference information in other tables.
    A primary key requires unique data in that specific field and is sorted in the current table; it can be used as a foreign key reference from another table. A foreign key references data in a different table. A composite key consists of more than one field.

    Data relationships: Data file relationships are generally recognized as "1:1"; "1:many"; or "many:many".

    How is integrity enforced?
    ==========================

    Data integrity is enforced by means of "entity" and "referential" integrity rules. Although not part of the relational model, most database software enforce ...

    Solution Summary

    Data integrity is examined.

    $2.19

    ADVERTISEMENT