database-design - 如何处理删除异常？

Question

"There are circumstances in which the deletion of data representing certain facts
necessitates the deletion of data representing completely different facts. The 
"Faculty and Their Courses" table described in the previous example suffers 
from this type of anomaly, for if a faculty member temporarily ceases to be 
assigned to any courses, we must delete the last of the records on which that 
faculty member appears, effectively also deleting the faculty member. This 
phenomenon is known as a deletion anomaly."

http://en.wikipedia.org/wiki/Database_normalization

在关系数据库管理系统中应该如何处理删除异常？有没有“软删除”的替代品？

Answer 1

删除异常是不良数据库设计的明显症状(假设是事务性设计)。摆脱它们的最好方法是将您的模型规范化为 - 至少 - 3rd Normal Form (3NF)。

可以找到一个很好的解释here .