I will design er diagram and db diagram for your scenario

About:

I ll give the ER diagram and DB diagram with bellow features.
1) Optimization
2) Normalize up to 3rd normal form
3) Industrial best practice
4) Deliver with DB scripts

Reviews

:

:

:

:

: