7
AssignmentMultiple Choice

Designing a Relational Database

Question 7 • DRHS-Business and Tech BLOCK (07.4410030)

What task do the referential integrity settings prevent?

Answer
A
editing a non-key field in a destination table
B
sharing data from one field between two tables
C
linking a primary key to another table’s primary key
D
deleting a record that has related records in another table

Explanation

Referential integrity keeps relationships between records consistent. It prevents deleting a record when other records still refer to it through a related key, unless those related records are handled first. Therefore, the correct choice is “deleting a record that has related records in another table.”

AI-written and checked against the verified answer.

Previous
Next