User269602965 posted
Does Table 2 already include the values for ITEM_INSPECTED > 2??
You have comma separated values in table 3 that you normalize into table 2, but then you create new values like parapet in table 2 and use in table 1.
The design appears not relational database traditional design.