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
Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Excel Introductory Quiz

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

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.