supporting data integrity in a database
Not what you're looking for?
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.