Data Integrity And Normalization

OVERVIEW:

Data Integrity:

Database integrity refers to the correctness and consistency of data. It is another form of database protection. While it is related to security and precision, it has some broader implications as well. Security involves protecting the data from unauthorized operations, while integrity is concerned with the quality of data itself. Integrity is usually expressed in terms of certain constraints which are the consistency rules that the database is not permitted to violate. Following two are the most important constraints in relational database:

(i)       Entity Integrity: is a constraint on primary values that states that no attribute of a primary key            should contain nulls.
(ii)      Referential integrity: is a constraints on foreign key values that states that if a foreign key                  exist in a relation, then either the foreign key value must match the primary key value of some            tuple in its home relation or the foreign key value must be completely null.

Normalization:

Normalization is the process of converting complex data structures into simple and stable data structures. It is based on the analysis of functional dependence.
             In other  words, Normalization is a technique for reviewing the entity/attribute lists to ensure that attributes are stored "where they belong".

Comments

Post a Comment

Popular posts from this blog

Microsoft Access-Forms And Reports

OVERVIEW Access Forms creates the user interface to your table. Although you can use Datasheet to perform many of the same functions as forms. Forms are used as an alternative way to enter data into a database table. It provides a different way of viewing table data. Access enables us to create forms that can be used to enter, maintain, view, and print data.               The Form is constructed from a collection of individual design elements called controls or control objects. Control are the components we see in the windows dialog boxes of the access and other windows applications like buttons, check boxes etc. We use text boxes to enter and edit data, labels to hold field names and object frame to display graphics.               A Form Wizard is provided to assist you in the construction of forms. Four types of forms can be created. These include single-column ( displaying one record at a time in a vertical format ) , tabular ( displaying multiple records in a row-and-col
Read more »facebook

Data Base

 A   Data Base is a collection logically related data sets or file . No r maly, these files /data sets are of different nature, used for specific purposes. these may be organized in various ways to meet processing and retrieval requirements of the organizations or users.                                      A  Data base system is just a computerized record keeping system. A data base itself can be regarded as a kind of electronic file cabinet, a warehouse or a repository for a collection of computerized data files. the user of he database normally has he following facilities to enjoy. Adding new , blank file to the database. Inserting new data into the existing files. Retrieving data from existing files. Updating data in existing files. Deleting data from existing files. Removing existing files, empty or otherwise from the database. A database system involves four major components, namely.             Data                   The Information             Har
Read more »facebook