• As you mentioned that in real scenario you can have more item type with many other attributes.So it is better to have separate tables for every item type instead of single table i.e. your first design would be better.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂