0
Still curious? Ask our experts.
Chat with our AI personalities
Steve
Ezra
TaigaAdd your answer:
Earn +20 pts
What do you mean by data integrity?
Data integrity is a term used in databases. In its broadest use, "data integrity" refers to the accuracy and consistency of data stored in a database, data warehouse, data mart or other construct. The term - Data Integrity - can be used to describe a state, a process or a function - and is often used as a proxy for "data quality".
Why is it important to have integrity?
its important because your stupid
Can be defined as?
Weaknesses in the integrity of a person or thing.
How many times the word integrity in the king James Version Bible?
The word integrity appears 16 times in the king James Version Bible.
Two principal integrity rules for the relational model?
Integrity Rules Although integrity rules are not part of normal forms, they are definitely part of the database design process. Integrity rules are broken into two categories. They include overall integrity rules and database-specific integrity rules. == The two types of overall integrity rules are referential integrity rules and entity integrity rules. Referential integrity rules dictate that a database does not contain orphan foreign key values. This means thatEntity integrity dictates that the primary key value cannot be Null. This rule applies not only to single-column primary keys, but also to multi-column primary keys. In fact, in a multi-column primary key, no field in the primary key can be Null. This makes sense because, if any part of the primary key can be Null, the primary key can no longer act as a unique identifier for the row. Fortunately, the Access Database Engine (Access 2007's new version of the JET database engine, available with the new ACCDB file format) does not allow a field in a primary key to be Null.Database-Specific Rules The other set of rules applied to a database are not applicable to all databases but are, instead, dictated by business rules that apply to a specific application. Database-specific rules are as important as overall integrity rules. They ensure that only valid data is entered into a database. An example of a database-specific integrity rule is that the delivery date for an order must fall after the order date.
