Question

1. What is elemental integrity? Describe four methods to provide elemental integrity in database systems. (2+8=10 points)

Answer 1

The term elemental integrity refers to the accuracy and consistency of the data in the database at the smallest level that can be the values for each element that can be row or column wise

Mthods:

1.Well-formed transaction here the user is not allowed to change the data arbitarily but allowed to it in a contrained way to ensure integrity.

2.Authenticated here integrity is maintained by allowing only the authentiated users only , not all can make changes.

3.Seperation of duties here the user are assigned the part where they can make changes , only a number of user are allowed to perform a particular duty.

4.Priveleges, here the users have different of privelege that they use to change the data and privilege is set by their usage type or by the organzation .