What does "integrity" mean in the context of data management?
What will be an ideal response?
A relational DBMS protects data integrity at four levels: column (or attribute), row (or entity), inter-table, and procedural.
? Attribute integrity is ensured by type definition, foreign keys, and constraints.
? Entity integrity is assured by the primary key: one, and only one, entity within a table can be identified by a specific value (or combination of values) in the primary key.
? Inter-table integrity is called referential integrity and is implemented by enforcing the constraints of foreign keys.
? Procedural integrity is used when the relationships among entities are too complex for the other mechanisms. The main tools of procedural integrity are triggers, stored procedures, and transaction processing.
You might also like to view...
To relate one thought to another, what writing technique should be used?
A) Topic sentences B) Unified paragraphs C) Transitions D) Complex sentences E) Bullet points
_____ of a note or bond at any date subsequent to the initial borrowing equals the present value of the future, or remaining, cash flows discounted at an appropriate interest rate
a. The amount borrowed initially b. The market value c. The liquidation value d. The net realizable value less selling costs e. choices a and b
The expected return on dollar deposits in terms of dollars, RD, is
A) always the interest rate on dollar deposits, iD, for any exchange rate. B) the interest rate on dollar deposits, iD, only when Et > . C) the interest rate on dollar deposits, iD, only when Et < . D) the interest rate on dollar deposits, iD, only when Et = .
In many projects, people who have never worked together are assigned to the same project team
a. True b. False Indicate whether the statement is true or false