Referential Integrity

What is the primary goal of maintaining data integrity in a database?

• To ensure the database runs quickly

• To maintain the consistency and accuracy of the data

• To increase the storage capacity of the database

• To make the database easier to use

What does referential integrity specifically aim to maintain in a relational database?

• The security of the database

• The speed of data retrieval

• The physical storage of the data

• The accuracy and consistency of data within a relationship

What could be a consequence of not maintaining referential integrity?

• Orphaned entries and inconsistent data

• Faster data processing

• Simplified database queries

• Increased database storage

What is a cascade delete restraint used for in maintaining referential integrity?

• To automatically delete associated rows in related tables

• To prevent users from deleting important data

• To backup data before deletion

• To increase the speed of deleting records

Why must cascade delete restraints be used with caution?

• They require additional storage space

• They are difficult to implement

• They can lead to accidental deletion of related records

• They significantly slow down the database

What is the risk of deleting a tutor group record without considering the implications of cascade delete?

• It might lock users out of the database

• It could accidentally promote students to the next grade

• It might delete all records of students in that tutor group

• It could lead to the deletion of all school records

What does data integrity ensure about the data stored in a database?

• That it can be accessed quickly

• That it remains private and secure

• That it reflects the reality it represents

• That it can be easily modified

What is a potential problem with manually removing an employee from multiple related tables?

• It can lead to mistakes and inconsistent data

• It is time-consuming

• It requires special software

• It is not allowed under data protection laws

How does referential integrity prevent the addition of inconsistent data?

• By encrypting data before it is added

• By automatically duplicating data across related tables

• By requiring administrator approval for all new records

• By preventing the addition of a record if there isn't a matching record in a related table

What is the effect of enforcing unique constraints in a database?

• It ensures that all records are duplicated for backup purposes

• It prevents duplicate entries in a column, ensuring data uniqueness

• It increases the storage requirements of the database

• It makes data retrieval significantly slower