Purchase Solution

supporting data integrity in a database

Not what you're looking for?

Ask Custom Question

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?

Purchase this Solution

Solution Summary

Data integrity is examined.

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 ...

Purchase this Solution


Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Javscript Basics

Quiz on basics of javascript programming language.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

C# variables and classes

This quiz contains questions about C# classes and variables.