DB 7 - Database Terms (Part 2)

Question 1

What does normalizing a database mean?

Answer 1

the act of cleaning and organizing the database

Question 2

What are the 2 conditions that are often looked after in database?

Answer 2

• Ensuring data integrity
• Reducing data redundancy

Question 3

What is data integrity?

Answer 3

Refers to a condition in which the data in the database complies with all entity,domain and referential integrity constraints

Question 4

Data integrity is assessed and enforced through 3 categories. What are those?

Answer 4

Referential integrity
Domain integrity
Entity integrity

Question 5

Elaborate referential integrity

Answer 5

References in a database must exist in both the source and the destination of the reference records. Foreign key must reference a valid existing value in another table

Question 6

Elaborate domain integrity

Answer 6

Placing boundaries on data to shape the data into the correct data type accepted by the database

Question 7

Elaborate entity integrity

Answer 7

It ensures that the primary key that identifies a relation is always unique. It cannot be NULL

Question 8

List 3 types of anomaly

Answer 8

Update anomaly
Deletion anomaly
Insertion anomaly