Repair Table Structure Question

[jwcoleman87]

Currently I'm debating the necessity of these two tables here:


TTRepair holds a single instance of a repair as it is in real time, whereas TTRepairHistory holds a line by line history of that same repair (which includes its present state). In other words, as a TTRepair object is interacted with and modified and changed, TTRepairHistory records those changes line by line. I keep asking myself this question: Do I really need TTRepair if TTRepairHistory already has the data for that repair? Further I question, if both are necessary, what are these tables missing that really causes them to be unique, because as the properties are laid out now, they are almost identical.

 

[jimmajsterski]

I don't remember how anymore, but it seems like normalization taken to whatever level is necessary would give the answer.