Upgrading your old model

In this part of the HA$2,$ you will be upgrading your ERD from HA$1.$ You are expected to use EERD modeling

tools and techniques. This part consists of the following steps:

$$ Design at least one specialization$/$generalization hierarchy for your model.

$$ Design at least one partial and total disjoint and overlapping constraint for your model.

$$ Pick one entity in your data model and design a mechanism that allows your database to store

historic data about it$.$ Make sure to clearly mark this part of your model.

$$ Demonstrate how do you plan to solve for Fan Traps if you have any in your previous model. If

you do not have any, explain where potential Fan Traps could occur in the future.

$*$please note: you are allowed to change the original business rules to meet these requirements.

$($NO SQL CODE NEEDED$).$ The company I have chosen is called Zaful, and this is my ERD $($its kind of wrong but please do help!$)$