Define entity integrity and also mention two requirements that ensures that this condition is met.(4 Marks)Question 58Name three (3) characteristics that constitutes a well-informed table in database design.(3 Marks)

Entity Integrity is a concept in a relational database where each tuple (or row) is uniquely identified by its primary key. It ensures that no primary key value is null and that no two rows have the same primary key value. This is crucial in maintaining the integrity of the data in the table.

Two requirements that ensure entity integrity are:

1. Primary Key: Each table should have a primary key. This is a unique identifier for each record in the table. No two records can have the same primary key.
2. Not Null: The primary key cannot be null. This is because the primary key is used to identify individual records. If it were null, it would not be possible to identify records uniquely.

Three characteristics that constitute a well-formed table in database design are:

1. Atomicity: Each cell in the table should contain a single, indivisible value. This means that there are no sets of values or repeating groups.
2. Consistency: The data in the table should be consistent. This means that the same data should not be repeated in multiple places.
3. Independence: The table should be able to be modified independently of other tables. This means that changes to one table should not require changes to other tables.